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

question 27

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 2015 is ________.

---

Definitions:

Organizational Clarity

The extent to which the roles, objectives, and strategies of an organization are clear, understood, and accepted by its members.

External Stakeholders

Individuals or groups outside of a company who are affected by its actions and decisions, such as customers, suppliers, and the community.

Company Intranet

A private network accessible only to an organization's staff, often used to store, share, and manage internal information.

Policies

Official guidelines or rules that govern the operations, decisions, and actions within an organization or administration.