Question: In Excel, please explain the steps to get the answers to the following questions along with the correct answer. Please see the data sheet below.
In Excel, please explain the steps to get the answers to the following questions along with the correct answer. Please see the data sheet below.
Older people often have a hard time finding work. AARP reported on the number of weeks it takes a worker aged 55 plus to find a job. The data on number of weeks spent searching for a job contained in the file Q1 are consistent with the AARP findings (AARP Bulletin, April 2008). a. Provide a point estimate of the population mean number of weeks it takes a worker aged 55 plus to find a job. b. At 95% confidence, what is the margin of error? c. What is the 95% confidence interval estimate of the mean?
Job Search Time (Weeks) 21 14 51 16 17 14 16 12 48 0 27 17 32 24 12 10 52 21 26 14 13 24 19 28 26 26 10 21 44 36 22 39 17 17 10 19 16 22 5 22
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
