Examlex

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 ___________.


Definitions:

War of Jenkins's Ear

A conflict between Britain and Spain (1739-1748), named after an incident involving the severing of British Captain Jenkins' ear by Spanish coast guards, symbolizing broader colonial and trade tensions.

Hereditary Nobility

A social class in various countries historically conferred by a monarch or an existing regime, typically involving titles and privileges being passed down through bloodlines.

Ottoman Empire

A vast empire founded at the end of the 13th century in present-day Turkey that expanded to control much of Southeast Europe, Western Asia, and North Africa for over six centuries.

Diplomatic Revolution

Refers to the significant shift in alliances among major European powers in the mid-18th century, particularly between 1756 and 1757, leading to the realignment of diplomatic relations.

Related Questions