The president of a chain of department stores believes that her stores\' total s

Question

The president of a chain of department stores believes that her stores' total sales have been showing a linear trend since 1993. 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 1993 is coded as 0 1994 is coded as 1, etc. 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 Scenario 16-6, the forecast for sales (in millions of dollars) in 2013 is

Explanation / Answer

1994 is coded as 1

Eqution is:

Sales = 0.78 * year + 31.2

So, 2013 will be coded as = 20

Sales = 0.78 * 20 + 31.2

Sales = $187.2

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.