Question: Excel please I don't know how to do it. 6-13. From a sample of 22 graduate students, the mean number of months of work experience

Excel please I don't know how to do it.

6-13. From a sample of 22 graduate students, the mean number of months of work experience prior to entering an MBA program was 34.86. The national standard deviation is known to be 19 months. What is a 95% confidence interval for the population mean? Compute the confidence interval using the appropriate formula and verify your results using the Excel Confidence Intervals template.

6-15. A survey of 26 college freshmen found that they average 6.85 hours of sleep each night. A 90% confidence interval had a margin of error of 0.497.

a. What are the lower and upper limits of the confidence interval? b. What was the standard deviation, assuming that the population standard deviation is known?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!