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
