TABLE 16-10
the Manager of a Marketing Consulting Firm

question 19

Short Answer

TABLE 16-10
The manager of a marketing consulting firm has been examining his company's yearly profits. He believes that these profits have been showing a quadratic trend since 1980. He uses Microsoft Excel to obtain the partial output below. The dependent variable is profit (in thousands of dollars), while the independent variables are coded years and squared of coded years, where 1980 is coded as 0, 1981 is coded as 1, etc.
SUMMARY OUTPUT
Regression Statistics
$\begin{array} { l r } \text { Multiple R } & 0.998 \\ \text { RSquare } & 0.996 \\ \text { Adjusted R Square } & 0.996 \\ \text { Standard Error } & 4.996 \\ \text { Observations } & 17 \end{array}$

$\begin{array}{lc} & \text { Coefficients } \\\text { Intercept } & 35.5 \\\text { Coded Year } & 0.45 \\\text { Year Squared } & 1.00\end{array}$

-Referring to Table 16-10, the forecast for profits in 2000 is_____ .

---

Definitions:

Expansion

The process of increasing in size, volume, quantity, or scope.

Very Sleepy

A state of experiencing extreme tiredness or drowsiness, often implying a need for rest or sleep.

Functioning

The action of operating or working in a proper manner; pertains to how well an individual or system performs its intended role.

Helper T-Cells

A type of white blood cell that plays a critical role in the immune system by activating and directing other immune cells.