Examlex

Solved

Instruction 13 -Referring to Instruction 13

question 105

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,to test the significance of the multiple regression model,the value of the test statistic is ___________.


Definitions:

Self-Report Surveys

Respondents are asked to report their involvement in criminal activities, either as perpetrators or victims.

Surveillance And Patrol

Activities related to monitoring and patrolling areas to prevent and detect crime as well as to ensure public safety, often carried out by law enforcement agencies.

Legal Abortion

refers to the termination of pregnancy through medical intervention, which is permitted and regulated by law within certain conditions and criteria.

Increased Policing

The augmentation of police presence and activities within a community, often in response to rising crime rates or perceived threats to public safety.

Related Questions