Short Answer
TABLE 16-6
The president of a chain of department stores believes that her stores' total sales have been showing a linear trend since 1990. 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 1990 is coded as 0, 1991 is coded as 1, etc.
SUMMARY OUTPUT
Regression Statistics
Multiple R 0.604
R Square 0.365
Adjusted R Square 0.316
Standard Error 4.800
Observations 17
Coefficients
Intercept 31.2
Coded Year 0.78
-Referring to Table 16-6, the forecast for sales (in millions of dollars) in 2015 is ________.
Correct Answer:

Verified
Correct Answer:
Verified
Q32: The method of least squares is used
Q61: The fairly regular fluctuations that occur within
Q88: MAD is the summation of the residuals
Q116: TABLE 16-12<br>A local store developed a multiplicative
Q117: TABLE 16-10<br>Business closures in Laramie, Wyoming from
Q118: TABLE 16-4<br>The number of cases of merlot
Q122: TABLE 16-8<br>The manager of a marketing consulting
Q123: TABLE 16-3<br>The following table contains the number
Q124: TABLE 16-11<br>The manager of a health club
Q126: TABLE 16-12<br>A local store developed a multiplicative