Regression, statistics homework help

User Generated

Pneyvgb1992

Mathematics

Description

Use Excel’s regression tool to conduct regression analysis to investigate the relationship between the number of fatal accidents and the percentage of drivers under the age of 21. Use the computer output to answer the following questions:

g) Conduct an hypothesis test on the slope and discuss your findings. Make sure to state your null and alternative hypothesis and show your test statistic, you should use the numbers from the Excel output. Use a .05 level of significance. Give a statistical conclusion in the context of this problem.

h) If a city has 5 percent of its licensed drivers under the age of 21, what would be the predicted number of fatal accidents per 1000 licenses? Show how you calculated this.

3. What conclusion and recommendations about the two variables can you derive from the above analysis? Use complete sentences to answer this.

"Percent

Under 21" "Fatal Accidents

per 1000"

13 2.962

12 0.708

8 0.885

12 1.652

11 2.091

17 2.627

18 3.83

8 0.368

13 1.142

8 0.645

9 1.028

16 2.801

12 1.405

9 1.433

10 0.039

9 0.338

11 1.849

12 2.246

14 2.855

14 2.352

11 1.294

17 4.1

8 2.19

16 3.623

15 2.623

9 0.835

8 0.82

14 2.89

8 1.267

15 3.224

10 1.014

10 0.493

14 1.443

18 3.614

10 1.926

14 1.643

16 2.943

12 1.913

15 2.814

13 2.634

9 0.926

17 3.256


User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

find it attached hereinFollowing table shows the output of regression analysis:SUMMARY OUTPUTRegression StatisticsMultiple R0.83938748R Square0.704571341Adjusted R Square0.697185624Standard Error0.58935...


Anonymous
I was having a hard time with this subject, and this was a great help.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags