Question

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 are contained in the Excel Online file below. Construct a spreadsheet to answer the following questions.

Job Search Time (Weeks)					Formula
9		Sample mean			#N/A
9
50		Standard Deviation			#N/A
20
1		Confidence Level	0.95
29
3		Sigfinicance Level (Alpha)			#N/A
11
2		Sample Size			#N/A
22
36		Margin of error (4 decimals)			#N/A
5
17		C.I. Lower Limit			#N/A
32		C.I. Upper Limit			#N/A
9
21
45
12
41
11
20
45
51
45
13
5
5
14
46
6
33
5
10
8
23
0
44
16
11
2

a. Provide a point estimate of the population mean number of weeks it takes a worker aged 55 plus to find a job.

weeks (to whole number)

b. At 95% confidence, what is the margin of error? Please round the answer to four decimal places.

(to 4 decimals)

c. What is the 95% confidence interval estimate of the mean? Please round the answer to two decimal places.

(, ) weeks

Answer 1