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