Instruction 12 $\text { Regression statistics }$ $\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:
$\text { Regression statistics }$
$\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}$

$\text { ANOVA }$
$\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}$

$\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}$


$\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:

Right Ventricle

A chamber of the heart which pumps oxygen-depleted blood to the lungs.

Pulmonary Artery

A major blood vessel that carries blood from the heart to the lungs for oxygenation.

Nucleus

An organelle in eukaryotic cells containing most of the cell's genetic material, responsible for controlling the cell's activities.

Hemoglobin

A protein found in red blood cells that binds oxygen in the lungs and releases it to tissues across the body, essential for aerobic respiration.