Instruction 14-11
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 1990 is coded as 0,1991 is coded as 1,etc.
SUMMARY OUTPUT
Regression Statistics
Coefficients
Intercept
-Referring to Instruction 14-11,the forecast for sales (in millions of dollars)in 2015 is ________.
Correct Answer:
Verified
Q6: A least squares linear trend line is
Q23: The method of least squares may be
Q107: Instruction 14-5
A local store developed a
Q109: Instruction 14-5
A local store developed a
Q111: Instruction 14-12
The executive vice-president of a
Q113: Instruction 14-11
The president of a chain
Q114: Instruction 14-5
A local store developed a
Q115: Instruction 14-5
A local store developed a
Q116: Instruction 14-6
The monthly advertising expenditures of
Q117: Instruction 14-11
The president of a chain
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents