ANLY620

For the data listed below,

1) Use the TREND function in Excel to create a forecast for Month 11.

2a) Use LINEST function in Excel to create a forecast for Month 11.

b) Interpret the regression coefficient and comment on R-squared value.

Month

Number of units produced

1.   1456

2.   1329

3.   7351

4.   5952

5.   4229

6.   6588

7.   8584

8.   13035

9.   11891

10.  8324