Solved

Instruction 13 -Referring to Instruction 13

Question 15

Short Answer

Instruction 13.7
You worked as an intern at We Always Win Car Insurance Company last summer. You notice that individual car insurance premium depends very much on the age of the individual, the number of traffic tickets received by the individual and the population density of the city in which the individual lives. You performed a regression analysis in Microsoft Excel and obtained the following information:
RegressionAnalysis  MultipleR 0.63 R Square 0.40 Adj. R Square 0.23 Standard  Error 50.00 Observations 15.00 ANOVA  df SS  MS F Signif F  Regression 35994.242.400.12 Residual 1127496.82 Total 45479.54 Coeff  StdError  t Stat  p-value  Lower 99.0% Upper 99.0%  Intercept 123.8048.712.540.0327.47275.07 AGE 0.820.870.950.363.511.87 TICKETS 11.2510.661.990.0711.8654.37 DENSITY 3.146.460.490.6423.1916.91\begin{array}{|l|l|l|l|l|l|l|}\hline \text {Regression}&\text {Analysis }\\\hline \text { MultipleR } &\quad & 0.63 \\\hline \text { R Square } && 0.40 \\\hline \text { Adj. R Square } && 0.23 \\\hline \text { Standard } & \\\text { Error } & & 50.00\\\hline \text { Observations } & & 15.00 \\\hline & & & & & \\\hline \text { ANOVA } &\\\hline & \text { df}& \text { SS } & \text { MS } & F & \text { Signif F } \\\hline \text { Regression } & 3 & & 5994.24 & 2.40 & 0.12 \\\hline \text { Residual } & 11 & 27496.82 & & & \\\hline \text { Total } & & 45479.54 & & & \\\hline & & & & & \\\hline& \text { Coeff } & \text { StdError } & \text { t Stat } & \text { p-value } & \text { Lower 99.0\%}&\text { Upper 99.0\% } \\\hline \text { Intercept } & 123.80 & 48.71 & 2.54 & 0.03 & -27.47 & 275.07 \\\hline \text { AGE } & 0.82 & 0.87 & -0.95 & 0.36 & -3.51 & 1.87 \\\hline \text { TICKETS } & 11.25 & 10.66 & 1.99 & 0.07 & -11.86 & 54.37 \\\hline \text { DENSITY } & -3.14 & 6.46 & -0.49 & 0.64 & -23.19 & 16.91\\\hline\end{array}
-Referring to Instruction 13.7,the regression sum of squares that is missing in the ANOVA table should be ___________.

Correct Answer:

verifed

Verified

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions