You worked as an intern at We Always Win Car Insurance Company last summer. You notice...

 

Transcribed Image Text:

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% 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%

Answer rating: 100% (QA)

Proportion of variation in ... View the full answer