Statistics - Regression using Excel
Not what you're looking for?
*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.
_____________________________________________
See attachment
_____________________________________________
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)
Purchase this Solution
Solution Summary
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.
Solution Preview
Solution:
Open the Excel Program. Click on Tools ...
Purchase this Solution
Free BrainMass Quizzes
Exponential Expressions
In this quiz, you will have a chance to practice basic terminology of exponential expressions and how to evaluate them.
Probability Quiz
Some questions on probability
Multiplying Complex Numbers
This is a short quiz to check your understanding of multiplication of complex numbers in rectangular form.
Solving quadratic inequalities
This quiz test you on how well you are familiar with solving quadratic inequalities.
Geometry - Real Life Application Problems
Understanding of how geometry applies to in real-world contexts