Unemployment Study Each month the US. 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 unernployed. For November 2020 , the Bureau of Labor 5 tatistics reported that the national mean length of time of unemployment was 146 weeks. The mayor of Philadelphia requested J Study on the status of unemployment in the Philadelphis area. A sample of 50 uncmployed residents of Philadelphia included data on their age and the number of weeks without a job. A portion of the data collected in November 2015 follows The complete data set is available in the dota file Banus BLS 3 als 4 on the anwet, Thut, thowifie rebsons ind cakcutation aroceshi minuruan kicwnets? Please coov and ohve the facel outgut to your wopr. 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, shenv the reasons and calculation process.) 1. Use Excel to develop descriptive statistics to summarize the sample data. (Including the sample mean, standard deviation, median, mode, masimuin, minimum, skewness.) Please copy and paste the Excel output to your report. 2. Use Excel to develop a scatter plot for the age of an unemployed individual and the number of weeks of unemployment and calculate the correlation coefficient betwetn the two variables. Comment on the relationship between the age of an unemployed individual and the number of weeks of unemployment Please copy and paste the Excel outout to your report. 3. Develog a 95% confidence interval estimate of the mean age of unemployed individuals in Philadelphia. Show your calculation procest: 4. Conduct a hvoothesis test to determene whether the mean duration of unemployment in Philadelphia is spater than the national mean duration of 146 wekt Use a 0.01 level of signifeance. What is your conclusion? Show yout calculation process. Please provide your responses to each question in a Word decument and upload it to Canvas. Unemployment Study Each month the US. 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 unernployed. For November 2020 , the Bureau of Labor 5 tatistics reported that the national mean length of time of unemployment was 146 weeks. The mayor of Philadelphia requested J Study on the status of unemployment in the Philadelphis area. A sample of 50 uncmployed residents of Philadelphia included data on their age and the number of weeks without a job. A portion of the data collected in November 2015 follows The complete data set is available in the dota file Banus BLS 3 als 4 on the anwet, Thut, thowifie rebsons ind cakcutation aroceshi minuruan kicwnets? Please coov and ohve the facel outgut to your wopr. 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, shenv the reasons and calculation process.) 1. Use Excel to develop descriptive statistics to summarize the sample data. (Including the sample mean, standard deviation, median, mode, masimuin, minimum, skewness.) Please copy and paste the Excel output to your report. 2. Use Excel to develop a scatter plot for the age of an unemployed individual and the number of weeks of unemployment and calculate the correlation coefficient betwetn the two variables. Comment on the relationship between the age of an unemployed individual and the number of weeks of unemployment Please copy and paste the Excel outout to your report. 3. Develog a 95% confidence interval estimate of the mean age of unemployed individuals in Philadelphia. Show your calculation procest: 4. Conduct a hvoothesis test to determene whether the mean duration of unemployment in Philadelphia is spater than the national mean duration of 146 wekt Use a 0.01 level of signifeance. What is your conclusion? Show yout calculation process. Please provide your responses to each question in a Word decument and upload it to Canvas
