Solved

TABLE 16-8
the President of a Chain of Department Stores

Question 69

Short Answer

TABLE 16-8
The president of a chain of department stores believes that her stores' total sales have been showing a linear trend since 1980. She uses Microsoft Excel to obtain the partial output below. The dependent variable is sales (in millions of dollars), while the independent variable is coded years, where 1980 is coded as 0, 1981 is coded as 1, etc.
SUMMARY OUTPUT
 Regression Statistics  Multiple R 0.604 RSquare 0.365 Adjusted R Square 0.316 Standard Error 4.800 Observations 17\begin{array}{lr}\text { Regression Statistics } & \\\text { Multiple R } & 0.604 \\\text { RSquare } & 0.365 \\\text { Adjusted R Square } & 0.316 \\\text { Standard Error } & 4.800 \\\text { Observations } & 17\end{array}

 Coefficients  Intercept 31.2 Coded Year 0.78\begin{array}{lc} & \text { Coefficients } \\\text { Intercept } & 31.2 \\\text { Coded Year } & 0.78\end{array}

-Referring to Table 16-8, the forecast for sales (in millions of dollars) in 2005 is ______.

Correct Answer:

verifed

Verified

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions