write Fast.

Question 3 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. 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