*Please show all work, use excel and identify the value and units measured.
(Notes for my own Use: Ch8: 6)
The National Transportation Safety Board collects data by state (including the District of Columbia) on traffic fatalities. Part of this data is shown in the following table. along with potentially related factors including population, number of licensed drivers, number of registered vehicles, and total number of vehicle miles driven. (The complete data are available in the file traffic.xls.) You have been asked to develop a model to help explain the factors that underlie traffic fatalities.
a. Build a linear model to predict traffic fatalities based on all four potential explanatory variables as they are measured in the table. Evaluate the model in terms of overall goodness-of-fit. Evaluate the results for each regression parameter: Are the signs appropriate? Are the values different from zero?
b. Can yo improve the model in (a) by removing one or more of the explanatory variables from the regression? If so, compare the advantages and disadvantages of the resulting regression from the one in (a).
c. Can yo improve the models in (a) or (b) by transforming one or more of the explanatory variables from the regression? If so, compare the advantages and disadvantages of the resulting regression from the ones in (a) and (b)
Open the Excel Program. Click on Tools ...
Solution to the posted problem using Excel Data Analysis is given in the attached files with all the detailed explanation so that student could use the procedure to solve other similar problems also.