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
Get step-by-step solutions from verified subject matter experts
