Question

A study commissioned by the City of Houston in July 2013 asked a random sample of unemployed Houstonians how many weeks they have been unemployed. Use the data in the Unemployed sheet in this workbook to generate excel output to answer the following questions. Each orange numerical answer cell below MUST reference Excel output cells in the Unemployed sheet. Question 5A Can you conclude that the average duration of unemployment in Houston is less than the national average of 33 weeks during July 2013 at alpha=0.05? Step 1: Ho H: Step 2: Step 3: Fill in row 202 if the hypothesis is one tailed. Reject H, if Fill in row 206 if the hypothesis is two tailed. The smaller number must be typed first. Reject Ho if or Step 4: Step 5: Step 6: Step 7: P-value

Answer 1

The hypothesis being tested is:

H₀: µ = 33

H_a: µ < 33

The p-value is 0.0004.

Since the p-value (0.0004) is less than the significance level (0.05), we can reject the null hypothesis.

Therefore, we can conclude that µ < 33.

The 92% confidence interval is between 23.349 and 29.718.

The 80% confidence interval is between 24.221 and 28.846.

Weeks Unemployed
38
9
9
13
43
32
44
17
21
15
31
18
9
24
25
19
43
10
31
35
23
9
36
16
43
36
17
35
13
42
45
8
45
31
44
24
8
25
33
33
28
22
34
26
32
33.000	hypothesized value
26.533	mean Weeks Unemployed
11.921	std. dev.
1.777	std. error
45	n
44	df
-3.639	t
.0004	p-value (one-tailed, lower)
24.221	confidence interval 80.% lower
28.846	confidence interval 80.% upper
2.312	margin of error
23.349	confidence interval 92.% lower
29.718	confidence interval 92.% upper
3.185	margin of error