The following table shows the sales of a product over a period of 7 weeks.

Week 1 2 3 4 5 6 7

Demand 9 8 10 12 15 12 11

1Please make a forecast for week 8 using moving average (3). Please also calculate the mean absolution deviation (MAD) for this forecasting method

2 Please make a forecast for week 8 using exponential smoothing (0.1). Compare the mean absolution deviation of this method to that of 4.1

3 A Simple Linear Regression based on 12 weeks of data shows the following tables. What % of variation in the data is explained by the model? What is the p-value of the slope (week)? Is there a significant relationship between demand and time (at =0.05 significance level)?