Forecasting Analysis (15 points) Regression Analysis (12 points) An important re

Question

Forecasting Analysis (15 points) Regression Analysis (12 points) An important regional survey reveals that the economic growth of an HVAC product industry over 11-year period. The industry growth is calculated for eleven years, shown in table below. 2. Product Index, y Year 0 108.91 109.23 109.89 200.02 200.13 200.22 200.35 200.47 200.63 200.88 200.91 201.17 2 10 Hints: Please follow example problem of Regression Analysis'. Determine the values of parameters a and b of the linear regression equation using the method of least squares. i. (2 points) [You may use 'Excel' to find 'a'and 'b'values directly. You may use "Excel' to find 'a a an Go to Excel > Data>Data analysis> Regression. -

Explanation / Answer

(i)

SUMMARY OUTPUT

(ii) The least square equation is

Y= 130.02+8.6752X

The expected growth at x=12 is

Y = 130.02+8.6752*12 = 234.123

(iii)

iv) Total e2 =7948.88

The other question is calculated in the above table

(i)

SUMMARY OUTPUT

Regression Statistics Multiple R 0.758403 R Square 0.575175 Adjusted R Square 0.532692 Standard Error 28.19377 Observations 12 ANOVA df SS MS F Significance F Regression 1 10762.07 10762.07 13.5391 0.00425 Residual 10 7948.888 794.8888 Total 11 18710.96 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Intercept 130.0205 15.30981 8.492628 6.95E-06 95.90813 164.1329 X Variable 1 8.67521 2.357682 3.679551 0.00425 3.421968 13.92845

Related Questions

Navigate

• Browse (All)
• Browse F
• Subjects

---

---

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