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

question 140

Short Answer

Instruction 12.14
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.14,the standard error of the estimated slope coefficient is ____________.

---

Definitions:

Focus Groups

Small, diverse groups of people whose reactions are studied especially in market research or political analysis through guided discussions.

Experimentation

The process of conducting tests or investigations to discover or verify a hypothesis or to determine the efficacy of something previously untried.

Advertisements

Notices or announcements in a public medium promoting a product, service, or event, or publicizing a job vacancy.

Euphemisms

Mild or indirect words or expressions used to replace those considered too harsh or blunt when referring to something unpleasant or embarrassing.