Examlex

Solved

TABLE 16-10
the Manager of a Marketing Consulting Firm Has

question 182

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 Multiple R 0.998 RSquare 0.996 Adjusted R Square 0.996 Standard Error 4.996 Observations 17\begin{array} { l r } \text {Regression Statistics}\\ \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}

 Coefficients  Intercept 35.5 Coded Year 0.45 Year Squared 1.00\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 2005 is_____ .


Definitions:

Atoll

A ring-shaped coral reef, island, or series of islets surrounding a lagoon, often found in tropical ocean waters.

Meteoroid

Solid object in interplanetary space; distinguished from asteroids by a smaller size.

Volcanic Island

An island formed from the accumulation of material erupted through the crust from a volcanic vent, typically found in oceans.

Subduction

The mechanism in which one tectonic plate slides beneath another, descending into the mantle where the plates come together.

Related Questions