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

question 4

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 standard error of the estimated slope coefficient is _.

---

Definitions:

Segmented Income Statement

An income statement that breaks down revenues, cost of sales, and expenses by segments such as product lines, departments, or geographic regions.

Contribution Format

A method of income statement presentation that separates fixed and variable costs, making it easier to see the contribution margin.

Segmented Income Statement

An income statement that shows the financial results of different segments of a company separately.

Contribution Format

A financial reporting format that highlights the variable costs associated with a product or service, used to calculate contribution margin.