TABLE 16-8 The Manager of a Marketing Consulting Firm Has Been Examining

question 65

Short Answer

TABLE 16-8
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 1990. 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 1990 is coded as 0, 1991 is coded as 1, etc.
SUMMARY OUTPUT
Regression Statistics
Multiple R 0.998
R Square 0.996
Adjusted R Square 0.996
Standard Error 4.996
Observations 17
Coefficients
Intercept 35.5
Coded Year 0.45
Year Squared 1.00
-Referring to Table 16-8, the forecast for profits in 2010 is ________.

---

Definitions:

Market Demand

The total quantity of a good or service that all consumers in a market are willing and able to purchase at various prices.

Externalities

Costs or benefits that affect a party who did not choose to incur that cost or benefit.

Consumer Surplus

The difference in the total amount expected to be paid by consumers for a good or service and the actual payment made.

Willingness to Pay

Willingness to Pay is the maximum amount an individual or organization is ready to spend to procure a product or service, reflecting the value they attach to it.