Answered step by step
Verified Expert Solution
Question
1 Approved Answer
13. A random sample of eight drivers insured with a company and having similar auto insurance policies was selected. (10 points total) Monthly Auto
13. A random sample of eight drivers insured with a company and having similar auto insurance policies was selected. (10 points total) Monthly Auto Insurance Premium (S) Driving Experience (years) 42 25 44 15 50 12 Monthly Auto Insurance Premium is abbreviated as MAIP 56 6 60 64 16 5 71 87 9 2 An agent used MS EXCEL to determine a trend equation and obtained two results. The agent is not familiar with regression modeling and has approached you for assistance. The agent has provided the following two results of his analysis. Summary Output 1 Regression Statistics 100 . Multiple R 0.7679 80 70 R Square 0.5897 60 Adjusted R Square 0.5213 50 40 Standard Error 10.3199 30 Observations 8 20 10 10 15 Driving Experience 20 25 Df SS Regression 1 918.4935 Residual 6 639.0065 MS 918.4935 106.5011 F 8.6243 Significance F 0.0261 Total 7 1557.5 Coefficients Intercept 76.6604 Standard Error 6.9613 Lower Driving Exp -1.5476 0.5270 t Stat 11.0123 -2.9367 P-value 95% 0.0000 59.6266 -2.8371 0.0261 Upper 95% 93.6941 -0.2581 -2.8371 Lower Upper 95.0% 95.0% 59.6266 93.6941 -0.2581 Summary Output 2 25 Regression Statistics Multiple R 0.7679 R Square 0.5897 30 Adjusted R Square 0.5213 $ Standard Error 5.1209 Observations 8 60 80 100 Monthly Auto Insurance Premium df SS Regression 1 226.1587 MS 226.1587 F 8.6243 Significance F 0.0261 Residual 6 157.3413 26.2235 Total 7 383.5 Standard Coefficients Error Intercept 33.8278 7.8984 MAIP -0.3811 0.1298 t Stat P-value 4.2829 0.0052 -2.9367 0.0261 Lower 95% 14.5010 -0.6986 Upper 95% 53.1545 14.5010 -0.0636 -0.6986 Lower Upper 95.0% 95.0% 53.1545 -0.0636
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started