Answer question 3.2 how to forcast from week 5 to 15 only

A supply chain analyst is analyzing past sales data. He obtained the following numbers: He thinks that two methods could be used to forecast future sales: linear regression and weighted moving average. (1 mark) 3.1 Using Excel, please run linear regression on this data. Based on the results you obtain; do you think that linear regression is appropriate in this case? Why? 3.2 For the weighted moving average, the analyst wants to calculate a three-period weighted moving average with weights 0.6,0.3 and 0.1 . Please apply the weighted moving average methods to calculate the sales forecast in weeks 5-15