Solved

Instruction 14-11
the President of a Chain of Department Stores

Question 102

Short Answer

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
 Multiple R 0.604 R Square 0.365 Adjusted R Square 0.316 Standard Error 4.800 Observations 17\begin{array} { l r } \text { Multiple R } & 0.604 \\ \text { R Square } & 0.365 \\ \text { Adjusted R Square } & 0.316 \\ \text { Standard Error } & 4.800 \\ \text { Observations } & 17 \end{array}
\quad\quad\quad\quad\quad\quad\quad Coefficients
\quad Intercept 31.2\quad\quad\quad\quad 31.2
 Coded Year 0.78\begin{array} { l l } \text { Coded Year } \quad & 0.78 \end{array}
-Referring to Instruction 14-11,the fitted trend value (in millions of dollars)for 1995 is ________.

Correct Answer:

verifed

Verified

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

Related Questions

Unlock this Answer For Free Now!

View this answer and more for free by performing one of the following actions

qr-code

Scan the QR code to install the App and get 2 free unlocks

upload documents

Unlock quizzes for free by uploading documents