After taking AN300, C&A; decides to use Excel to perform a linear regression for

Question

After taking AN300, C&A; decides to use Excel to perform a linear regression forecast on the sales of HDTV. C&A; enters the data collected for the last six months on Excel as follows Month xSales ($000) March1 April May June July 100 200 500 450 380 550 2 3 4 August 6 Based on the given summary report output of the regression analysis, what is the forecast for December? Lower Upper 95% | 95% Intercept 89.33 104.170.86 0.44-199.88 378.55 78.29 | 26.75 | 2.93 | 0.04 | 4.02 |152.55 Standard Coefficient t Stat P-value Error 872.23 971.,59 O 793.94 256.95 167.62

Explanation / Answer

Correct Answer:

A

Working note:

As per the given data,

Sales = 89.33 + X*78.29

For December, X = 10

December sales forecast = 89.33 + 10*78.29

December sales forecast = 872.23

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

---