Examlex

Solved

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

question 150

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 fitted value for 1990 is ________.


Definitions:

Classified by Purpose

A method of grouping or categorizing items according to their intended use or role within a system or process.

Profit

The financial gain achieved when the revenues generated from business activities exceed the expenses, costs, and taxes needed to sustain those activities.

Not-for-Profit

An organization that operates for purposes other than making a profit, often focusing on social, educational, or charitable activities.

Corporate Form

A legal structure for a business recognized as a separate legal entity from its owners, offering limited liability and other advantages.

Related Questions