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

profileFull Grade
 (Not rated)
 (Not rated)
Chat
Home>Homework Answsers>Business & Finance homework help>Accounting homework help

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.

Percent Under 21Fatal Accidents per 1000 Licenses
132.962
120.708
80.885
121.652
112.091
172.627
183.830
80.368
131.142
80.645
91.028
162.801
121.405
91.433
100.039
90.338
111.849
122.246
142.855
142.352
111.294
174.100
82.190
163.623
152.623
90.835
80.820
142.890
81.267
153.224
101.014
100.493
141.443
183.614
101.926
141.643
162.943
121.913
152.814
132.634
90.926
173.256

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.

    • 12 years ago
    Report issue
    100% Accurate Answer
    NOT RATED

    Purchase the answer to view it

    blurred-text