Regression Stats

A plant has seven divisions that do he same type of work. A safety inspector visits each division of 20 workers quarterly. The number X of workhours devoted to safety training and the number Y of work hours lost due to industry-related accidents are recorded for each separate division below. Use MS Excel to answer the following questions. Division X Y 1 10.0 80 2 19.5 65 3 30.0 68 4 45.0 55 5 50.0 35 6 65.0 10 7 80.0 12 a. Discuss if the given data meets the requirements to estimate a regression model. b. Conduct a regression analysis using MS Excel and report the results. 0. Interpret the coefcient estimates. d. Using the estimated regression model, calculate the predicted value of Y for each of the following X values: 25, 40, 60, 70, and 85