please use excel & show steps. thanks.

please do part b as well. thanks.

Given the past sales for the previous 9 months, use regression method to forecast the demand for month 10, 11, and 12. Month Demand 1 1600 2 1700 3 1600 4 2100 5 2500 6 2700 7 2800 8 2900 9 2920 10 ? 11 ? 12 2 I () Please use the EXCEL function of SLOPE and INTERCEPT to find the forecasted value of month 10, 11, and 12 demand. SLOPE - INTERCEPT=1 Therefore, The forecasted demand for month 10 is: 1 The forecasted demand for month 11 is: The forecasted demand for month 12 is: Given the past sales for the previous 9 months, use regression method to forecast the demand for month 10, 11 and 12 Month 1 2 3 4 5 6 7 8 9 10 11 12 Demand 1600 1700 1600 2100 2500 2700 2800 2900 2920 ? 2 7 a) Please use the EXCEL. function of SL.CIPE and INTERCEPT to find the forecasted value of month 10, 11, and 12 demand. SLOPE - INTERCEPT-1 Therefore, The forecasted demand for month 10 is The forecasted demand for month llis The forecasted demand for month 12 is: (b) Please use the EXCEL, function of FORECAST to find the the forecastod value of month 10, 11 and 12 demand. The forecasted demand for month 10 i The forecasted demand for month 11 is The forecasted demand for month 12 t