TABLE 16-10
the Manager of a Marketing Consulting Firm

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_____ .