Examlex

Solved

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

question 197

Short Answer

Instruction 14-9
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.
 SUMMAROUIPUT  Regression Statistics  MultipleR 0.604 R Square 0.365 Adjusted R Square 0.316 standard Error 4.800 Observations 17 Coefıˊlients  Intercept 31.2 Coded Year 0.78\begin{array}{l}\text { SUMMAROUIPUT }\\\begin{array} { l l } \text { Regression Statistics } & \\\text { MultipleR } & 0.604 \\\text { R Square } & 0.365 \\\text { Adjusted R Square } & 0.316 \\\text { standard Error } & 4.800 \\\text { Observations } & 17 \\& \\& \text { Coefílients } \\\text { Intercept } & 31.2 \\\text { Coded Year } & 0.78\end{array}\end{array}
-Referring to Instruction 14-9,the fitted trend value (in millions of dollars)for 1995 is _______.


Definitions:

Related Questions