Answered step by step
Verified Expert Solution
Link Copied!

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 ... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Fundamentals of corporate finance

Authors: Robert Parrino, David S. Kidwell, Thomas W. Bates

2nd Edition

978-0470933268, 470933267, 470876441, 978-0470876442

More Books

Students also viewed these Accounting questions

Question

Why do bars offer free peanuts?

Answered: 1 week ago