Please need help to calculate attached questions in excel formula with explanation please Thanks **Problem 1:**A random sample of 81 students at a local university showed that they work an average of 100 hours per month. The population standard deviation is known to be 27 hours. Answer the 4 questions below.1) **What is the point estimate for the mean hours per month all students at the university work?** - 100 (the sample mean is used as the point estimate for the population mean).2) **95% confidence interval is** - ( _ , _ ) (This section is to be filled with the calculated confidence interval values).3) **99% confidence interval is** - ( _ , _ ) (This section is to be filled with the calculated confidence interval values).4) - **Explanation of which interval is wider and why:** The 99% confidence interval is wider than the 95% confidence interval. This is because a higher confidence level requires a broader range to ensure that the true population parameter is captured within the interval. A greater level of certainty comes with a trade-off of less precision.

Name: Please need help to calculate attached questions in excel formula with
Uploaded: 2024-03-20T07:07:26.000Z
Channel: Bartleby
Description: Please need help to calculate attached questions in excel formula with explanation please Thanks **Problem 1:**A random sample of 81 students at a local university showed that they work an average of 100 hours per month. The population standard devia