statistics

     Case 3 (Economics Application): Each month the U.S. Bureau of Labor Statistics publishes a miscellany of unemployment statistics, including the venerate of singles who are indolent and the average protraction of period the singles bear been indolent. The mayor of a city has requested a con-over on the foothold of unemployment in the city. A illustration of 50 indolent residents of the city intervening axioms on the age and the venerate of weeks extraneously a job. The axioms self-possessed are suited in the axioms set BLS.  The managerial reverberation should include such as:  Use MS Excel Descriptive Statistics to incorporate age and venerate of unemployment weeks. (20%)   Develop a 90% assurance space-among venerate of the average age of indolent singles in the city. You bear to illusion the space-among formula and computation rule. (20%)   Develop a 95% assurance space-among venerate of the average venerate of weeks of unemployment in the city. You bear to illusion the space-among formula and computation rule. (20%)   The mayor claims that the average period of unemployment in the city is not senior than the exoteric average period of 13.8 weeks. Fascinate influence fancy testing after a while 0.10 raze of opinion. What is your omission? (30%)   Is there a similarity (trend) among the age of an indolent single and the venerate of weeks of unemployment? If so, fascinate illusion the dupe (graph or statistic) to test it. (10%)