SCENARIO 12-5
the Managing Partner of an Advertising Agency Believes

question 205

Short Answer

SCENARIO 12-5
The managing partner of an advertising agency believes that his company's sales are related to the industry sales.He uses Microsoft Excel to analyze the last 4 years of quarterly data with the following results: $\begin{array}{ll}{\text { Regression Statistics }} \\\text { Multiple R } & 0.802 \\\text { R Square } & 0.643 \\\text { Adjusted R Square } & 0.618 \\\text { Standard Error Syv } & 0.9234\\\text { Observations } & 16\end{array}$
ANOVA
$\begin{array}{lrrrcc} & \text { df } & \text { SS } & \text { MS } & \text { F } & \text { Sig.F } \\\text { Regression } & 1 & 21.497 & 21.497 & 25.27 & 0.000 \\\text { Error } & 14 & 11.912 & 0.851 & & \\\text { Total } & 15 & 33.409 & & &\end{array}$


$\begin{array}{llll}\text { Predictor Coef } & \text { StdError } t \text { Stat } & \text { P-value }\\\hline\text { Intercept }& 3.962 & 1.440 & 2.75 & 0.016 \\\text { Industry } &0.040451 & 0.008048 & 5.03 & 0.000\end{array}$

$\text { Durbin-Watson Statistic } \quad 1.59$
-Referring to Scenario 12-5, the prediction for a quarter in which X = 120 is Y = _.

---

Definitions:

Median

The value located at the midpoint of an arranged dataset, in order from smallest to largest or reverse, is known as the median.

Mean

The average of a set of numbers, calculated by summing them together and then dividing by the number of values.

Rounding Rules

Guidelines or conventions for approximating a numerical value to a desired level of precision, often to simplify calculations or presentation.

Rounded

The process of adjusting a numerical value to its nearest preferred value, often to a specified degree of precision.