As part of a study on transportation safety the U.S. Department of Transportatio

As part of a study on transportation safety the U.S. Department of Transportation collected data on the number of fatal accidents per 1000 licenses and the percentage of licensed driv- ers under the age of 21 in a sample of 42 cities. Data collected over a one-year period fol- low. These data are contained in the file named Safety.answer the following questions using excel. 1. Write the regression equation. 2. Interpret the regression constant and regression coefficient. 3. Forecast a value for the dependent variable. 4. Conduct a test on the regression coefficient at an alpha level of .05. 5. Conduct a test on the overall significants of the regression equation. 6. Interpret the coefficient of determination. 7. Are there any violations of the general linear model? Be specific. If not fully answered and done in excel I will not give any credit to your answer.