Examlex

Solved

Instruction 12  Regression statistics \text { Regression statistics }  ANOVA \text { ANOVA }

question 4

Short Answer

Instruction 12.30
The managing partner of an advertising agency believes that his company's sales are related to the industry sales. He uses Microsoft Excel's Data Analysis tool to analyse the last four years of quarterly data with the following results:
 Regression statistics \text { Regression statistics }
 Multiple R 0.802 R Square 0.643 Adjusted R  Square 0.618 Standard Error  SYX 0.9224 Observations 16\begin{array}{|l|l|}\hline \text { Multiple R } & 0.802 \\\hline \text { R Square } & 0.643 \\\hline \begin{array}{l}\text { Adjusted R } \\\text { Square }\end{array} & 0.618 \\\hline \begin{array}{l}\text { Standard Error } \\\text { SYX }\end{array} & 0.9224 \\\hline \text { Observations } & 16 \\\hline\end{array}

 ANOVA \text { ANOVA }
 df  SS  MS  F  Sig.F  Regression 121.49721.49725.270.000 Error 1411.9120.851 Total 1533.409\begin{array}{|l|l|l|l|l|l|}\hline & \text { df } & \text { SS } & \text { MS } & \text { F } & \text { Sig.F } \\\hline \text { Regression } & 1 & 21.497 & 21.497 & 25.27 & 0.000 \\\hline \text { Error } & 14 & 11.912 & 0.851 & & \\\hline \text { Total } & 15 & 33.409 & & & \\\hline\end{array}

 Predictor  Coef  StdError  t Stat  p-value  Intercept 3.9621.4402.750.016 Industry 0.0404510.0080485.030.000\begin{array}{|l|l|l|l|l|}\hline\text { Predictor } & \text { Coef } & \text { StdError } & \text { t Stat } & \text { p-value } \\\hline \text { Intercept } & 3.962 & 1.440 & 2.75 & 0.016 \\\hline \text { Industry } & 0.040451 & 0.008048 & 5.03 & 0.000\\\hline\end{array}


 Durbin-Watson 1.59 Statistic \begin{array}{|l|l|}\hline\text { Durbin-Watson } & 1.59 \\\text { Statistic } &\\\hline\end{array}


-Referring to Instruction 12.30,the value of the quantity that the least squares regression line minimises is____________.


Definitions:

Erythrocytes

Red blood cells that carry oxygen from the lungs to the body's tissues and transfer carbon dioxide back to the lungs for expulsion.

Polycythemia

Polycythemia is a condition characterized by an increased number of red blood cells in the bloodstream.

Erythropoiesis

The production of red blood cells in the bone marrow.

Hemoglobin

A protein in red blood cells that carries oxygen from the lungs to the rest of the body and carbon dioxide back to the lungs.

Related Questions