USA: +1(669)289-8683 
Sign in
There are 4 questions and excel file has data and tabal. I think you might wanna use SPSS PROGAM
This Homework its my only chance to get a bonuc creditsfor the class. Good work plz
E270 Introduction to Statistics
Bonus Assignment
This assignment is worth 10 extra points and due on December, 2, 2013 at the beginning of the class.
Unemployment Study
Each month the U.S. Bureau of Labor Statistics publishes a variety of unemployment statistics, including the number of individuals who are unemployed and the mean length of time the individuals have been unemployed. For November 2005, the Bureau of Labor Statistics reported that the national mean length of time of unemployment was 14.6 weeks.
The mayor of Philadelphia requested a study on the status of unemployment in the Philadelphia area. A sample of 50 unemployed residents of Philadelphia included data on their age and the number of weeks without a job. A portion of the data collected in November 2005 follows. The complete data set is available in the data file Bonus_BLS.xlsx.
Age
Weeks
Age
Weeks
Age
Weeks
56
22
22
11
25
12
35
19
48
6
25
1
22
7
48
22
59
33
57
37
25
5
49
26
40
18
40
20
33
13
You are asked to write a managerial report that covers the following questions. (Answers are graded on the reasoning used to arrive at an answer, not simply on the answer. Thus, show the reasons and calculation process.)
1. Use descriptive statistics to summarize the data. (Including sample mean, standard deviation, median, mode, maximum, minimum, skewness.)
2. Use the graphical method and the numerical method to show whether there is a relationship between the age of an unemployed individual and the number of weeks of unemployment.
3. Develop 95% confidence interval estimate of the mean age of unemployed individuals in Philadelphia.
4. Conduct a hypothesis test to determine whether the mean duration of unemployment in Philadelphia is greater than the national mean duration of 14.6 weeks. Use a 0.01 level of significance. What is your conclusion?
Data
| Age | Weeks | ||||||||
| 5 | 6 | 22 | |||||||
| 3 | 1 | 9 | |||||||
| 7 | |||||||||
| 57 | 37 | ||||||||
| 4 | 1 | 8 | |||||||
| 11 | |||||||||
| 48 | |||||||||
| 25 | |||||||||
| 20 | |||||||||
| 12 | |||||||||
| 59 | 33 | ||||||||
| 49 | 26 | ||||||||
| 13 | |||||||||
| 56 | 15 | ||||||||
| 17 | |||||||||
| 31 | |||||||||
| 27 | |||||||||
| 23 | |||||||||
| 45 | |||||||||
| 29 | 14 | ||||||||
| 39 | |||||||||
| 35 | |||||||||
| 44 | 38 | ||||||||
| 24 | |||||||||
| 42 | |||||||||
| 16 | |||||||||
| 21 | |||||||||
| 51 | |||||||||
| 30 | 10 | ||||||||
| 32 | |||||||||
| 50 | |||||||||
| 55 |
