Examlex

Solved

Instruction 13 -Referring to Instruction 13

question 53

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 proportion of the total variability in insurance premiums that can be explained by AGE,TICKETS and DENSITY is ______.


Definitions:

Retentive

Memory or functions in a control system that retain their value or state even after the system is powered down or rebooted.

Nonretentive

In PLC programming, a term referring to memory or data that is not retained after power loss.

Retentive Timer Reset

A function in PLC programming that allows a timer to retain its accumulated value even after a reset condition has been removed or power to the PLC has been cycled.

Timer Resets

The process of returning a timer to its initial state or set value in control systems or programming.

Related Questions