help solving Question 2

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) Month 1 2 3 4 5 6 7 8 9 Demand (000s) 3600 3400 3400 3350 3200 2950 3050 3000 2900 2650 1850 2250 2100 1900 1850 10 11 12 13 14 15 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 W = 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 Use the data provided 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 2.2 What is the Coefficient of Determination (R Squared)? What does it mean? Use the model generate to predict the demand for Month # 16