Answer question 2 only in excel

Question 1 A high-tech company wants to forecast the demand for their Kindle e-readers (in 000), based on the data below. ( 2 marks) 1.1 The company wants to choose a forecasting method for its data and considers Simple Moving Average ( 4 period and 7 period) and Weighted Moving Average ( 4 period with w1=0.4,w2=0.3,w3=0.2 and w4=0.1) 1.1.1 Using the above forecasting methods, forecast demand till month 15 . 1.2 Make a scatter plot of the forecasts obtained with the three methods ( 4 and 7 period simple moving average and 4 period weighted moving average), together with the actual demand. Comment on the graphs obtained. 1.3 For each of the three methods above, calculate MAD and MAPE. Comment on these values. Which forecasting method should you choose? Why? Question 2 Using the monthly data in Question 1, the Analyst would like to establish a Linear Regression model for the demand. Using Excel, please run linear regression on this data (1 mark) 2.1 What is the Coefficient of Determination (R Squared)? What does it mean? 2.2 Use the model generate to predict the demand for Month \# 16