This is a written, statistical report, not simply a collectionof different types of Excel output. It is not necessary to includethe formulas you used or a copy of the dataset. When answering thequestions, make sure to include any relevant statistics and/or theresults of your calculations. Like any other written report, youwill want to start with an introductory paragraph or problemstatement and finish with a conclusion that summarizes theinformation presented.
1. Use descriptive statistics to summarize the data.
2. Develop a 95% confidence interval estimate of the mean age ofunemployed individuals in Philadelphia.
3. Conduct a hypothesis test to determine whether the meanduration of unemployment in Philadelphia is greater than thenational mean duration of 14.6 weeks. Use a .01 level ofsignificance. What is your conclusion?
4. Is there a relationship between the age of an unemployedindividual and the number of weeks of unemployment? Explain.
Age | Weeks |
56 | 22 |
35 | 19 |
22 | 7 |
57 | 37 |
| |
40 | 18 |
22 | 11 |
48 | 6 |
48 | 22 |
25 | 5 |
40 | 20 |
25 | 12 |
25 | 1 |
59 | 33 |
49 | 26 |
33 | 13 |
56 | 15 |
20 | 17 |
31 | 11 |
27 | 17 |
23 | 3 |
45 | 17 |
29 | 14 |
31 | 4 |
59 | 39 |
39 | 7 |
35 | 12 |
44 | 38 |
27 | 14 |
24 | 6 |
27 | 7 |
45 | 25 |
42 | 33 |
45 | 16 |
44 | 12 |
21 | 13 |
31 | 16 |
42 | 4 |
23 | 14 |
51 | 31 |
27 | 7 |
30 | 10 |
33 | 23 |
32 | 8 |
22 | 7 |
51 | 12 |
50 | 16 |
21 | 9 |
38 | 5 |
26 | 8 |
55 | 35 |
| |