Please answer question #2 parts a through e using excel and show the steps to get the answer on excel. I need help seeing how to get the answer using excel.

Month January February March April May June Demand (Units) 4,200 4,300 4,000 4,400 5,000 4,700 Month July August September October November December Demand (Units) 5,300 4,900 5,400 5,700 6,300 6,000 a. Using least squares regression analysis, what would you estimate demand to be for each month next year? Using a spreadsheet, follow the general format in Figure 4.4. b. To be reasonably confident of meeting demand, Nina decides to use three standard errors of estimate for safety. How many additional units should be held to meet this level of confidence? Demand January 12 February 11 March 15 April 12 May 16 June 15 a. Using a weighted moving average with weights of 0.60,0.30, and 0.10, find the July forecast. b. Using a simple 3-month moving average, find the July forecast. c. Using single exponential smoothing with a = 0.2 and a June forecast 13, find the July forecast. Make whatever assumptions you wish. d. Using simple linear regression analysis, calculate the regression equation for the demand data. e. Using the regression equation in d, calculate the forecast for July 2. Historical demand for a product is