SCENARIO 13-10
You Worked as an Intern at We Always

question 162

Short Answer

SCENARIO 13-10
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: $$\begin{array}{l}\begin{array} { l r } \hline { \text { Regression Statistics } } \\\hline \text { Multiple R } & 0.8546 \\\text { R Square } & 0.7303 \\\text { Adjusted R Square } & 0.6853 \\\text { Standard Error } & 226.7502 \\\text { Observations } & 15 \\\hline\end{array}\\\\\text { ANOVA }\\\begin{array}{lrrrrrr} & d f & & \text { SS } & \text { MS } & \text { F } & \text { Significance } F \\\hline \text { Regression } & & 2 & & \text { 835284.6500 } & 16.2457 & 0.0004 \\\text { Residual } & & 12 & 616987.8200 & & & \\\text { Total } & & & 2287557.1200 & & & \\\hline\end{array}\\\\\begin{array} { l r r r r r r } \hline & \text { Coefficients } & \text { Standard Error } & { t \text { Stat } } & \text { P-value } & \text { Lower 99\% } & { \text { Upper 99\% } } \\\hline \text { Intercept } & 821.2617 & 161.9391 & 5.0714 & 0.0003 & 326.6124 & 1315.9111 \\\text { Age } & - 1.4061 & 2.5988 & - 0.5411 & 0.5984 & - 9.3444 & 6.5321 \\\text { Tickets } & 243.4401 & 43.2470 & 5.6291 & 0.0001 & 111.3406 & 375.5396 \\\hline\end{array}\end{array}$$
-Referring to SCENARIO 13-10, the proportion of the total variability in insurance premiums that can be explained by AGE and TICKETS is .

---

Definitions:

Gravel

Coarse granular material, consisting of rounded or angular fragments, often used in construction and landscaping.

Transgression

The advance of the sea across the land and the evidence of such an advance.

Regression

The retreat of the sea from land areas and evidence of such withdrawal.

Sandstone

A sedimentary rock composed mainly of sand-sized mineral particles or rock fragments.