Determine the least squares equation. On the basis of this information, what are

Question

Determine the least squares equation. On the basis of this information, what are the estimated sales for 2014 and 2015? (Round the intermediate values to the nearest whole number for further calculations. Round answers to the nearest whole number.)

2. Listed below is the number of movie tickets sold at the Library Cinema-Complex, in thousands, for the period from 2001 to 2013. Compute a five-year weighted moving average using weights of 0.2, 0.1, 0.3, 0.2, and 0.2, respectively. Describe the trend in yield. (Round answers to 3 decimal places.)

The weighted moving averages are what:

1. Listed below is the net sales in $ million for Home Depot Inc. and its subsidiaries from 1993 to 2012.

Explanation / Answer

sol)

The Regression eq is

y=a+bx

From Excel

The fitted Regression is

y= -7803017 +3922.75 (x)

For 2014, y hat = -7803017 +3922.75 (x) = -7803017 +3922.75 (2014) =97401.5

For 2014, y hat= -7803017 +3922.75 (x) = -7803017 +3922.75 (2015) =101324.25

SUMMARY OUTPUT Regression Statistics Multiple R 0.891355 R Square 0.794513 Adjusted R Square 0.783097 Standard Error 12125.7 Observations 20 ANOVA df SS MS F Significance F Regression 1 1.02E+10 1.02E+10 69.59683 1.34E-07 Residual 18 2.65E+09 1.47E+08 Total 19 1.29E+10 Coefficients Standard Error t Stat P-value Lower 95% Intercept -7803017 941608.3 -8.2869 1.48E-07 -9781263 Year 3922.75 470.2144 8.342471 1.34E-07 2934.867

Related Questions

Navigate

• Browse (All)
• Browse D
• Subjects

---

---

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