Sheet1 Weeks SP 13 13 11 14 3 10 4 7 12 7 8 11 9 10 18 17 13 14 5 11 10 8 15 7 9 11 10 8 5 6 14 12 10 14 12 12 8 12 10 11 15 5 8 11 15 11 6 6 13 9 Years 16 19 8 16 4 9 3 2 15 15 13 10 5 13 19 20 11 19 2 15 14 6 16 6 8 12 13 14 7 4 12 17 11 14 17 17 8 16 10 13 19 6 9 11 15 13 5 7 14 10 Weeks SP Years Page 1 Number of weeks of severance pay Number of years with the compan Sheet1 weeks of severance pay of years with the company Page 2 Graded Case Study Topic: Chapter 14 (Regression) Case Study: Severance Pay When one company buys another company, it is not unusual that some workers are terminated. The severance benefits offered to the laid-off workers are often the subject of dispute. Suppose that the Laurier Company recently bought the Western Company and subsequently terminated 20 of Western's employees. As part of the buyout agreement, it was promised that the severance package offered to the former Western employees would be equivalent to those offered to Laurier employees who had been terminated in the past year. Thirty-six-year-old Bill Smith, a Western employee for the past 10 years, was one of those let go. His severance package included an offer of 5 weeks' severance pay. Bill complained that this offer was less than that offered to Laurier's employees when they were laid off, in contravention of the buyout agreement. A statistician was called in to settle the dispute. The statistician was told that severance is determined by length of service with the company. To determine how generous the severance package had been, a random sample of 50 Laurier ex-employees was taken. For each, the following variables were recorded: Number of weeks of severance pay Number of years with the company The statistician would like to use the above sample information and the appropriate statistical method to determine whether Bill is correct in his assessment of the severance package. Your report should have the following qualities: Your report must be in a genuine report format with problem definition, analysis and final conclusion. All important analysis steps needs to be followed to arrive at the model to be used for prediction. Attach the details of your analysis at the end of your report. Very simplistic analysis with no sufficient details is assigned a near zero credit. Just running excel does not guarantee any credit. Your final conclusion should use both the 95% confidence and prediction intervals. Improper use of these and corresponding wrong/sloppy interpretations is highly penalized. Graded Case Study Topic: Chapter 14 (Regression) Use Data Analysis for Regression and then either Data Analysis Plus or the Regression Template provided on the course website for the intervals