Answered step by step
Verified Expert Solution
Question
1 Approved Answer
You worked as an intern at We Always Win Car Insurance Company last summer. You notice that individual car insurance premiums depend very much
You worked as an intern at We Always Win Car Insurance Company last summer. You notice that individual car insurance premiums depend very much on the age of the individual and the number of traffic tickets received by the individual. You performed a regression analysis in Excel and obtained the following partial information: Regression Statistics Multiple R 0.8546 R Square 0.7303 0.6853 Adjusted R Square Standard Error 226.7502 Observations 15 ANOVA df SS MS F Significance F 0.0004 Regression 2 835284.6500 16.2457 Residual 12 616987.8200 Total 2287557.1200 t Stat Upper 99% Intercept 821.2617 5.0714 0.0003 326.6124 1315.9111 Standard Error 161.9391 2.5988 43.2470 Age -0.5411 0.5984 -1.4061 243.4401 -9.3444 6.5321 111.3406 375.5396 Tickets 5.6291 0.0001 Referring to the above output, the proportion of variation in insurance premiums that can be explained by AGE and TICKETS is Coefficients P-value Lower 99%
Step by Step Solution
★★★★★
3.42 Rating (158 Votes )
There are 3 Steps involved in it
Step: 1
Proportion of variation in ...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