Question: please answer all parts using the data table provided thank you The following table shows the sales of a product over a period of 7

please answer all parts using the data table provided thank you

please answer all parts using the data tableplease answer all parts using the data table

The following table shows the sales of a product over a period of 7 weeks. Answer the following questions: 1.1 (5 points) Please make a forecast for week 10 using moving average (3). Please also calculate the mean absolution deviation (MAD) for this forecasting method 1.2 (5 points) Please make a forecast for week 10 using exponential smoothing (0.1). Please also calculate the mean absolution deviation (MAD) for this forecasting method. 1.3 (5 points) Using a Simple Linear Regression method, please make a prediction for period 10 (Hint: please use Anova table below to construct the equation for a fitted value). Please also calculate the mean absolution deviation (MAD) for this forecasting method. 1.3.1 (5 points) What % of variation in the data is explained by the model? 1.3.2 (10 points) What is the p-value of the slope (week)? Is there a significant relationship between demand and time (at =0.05 significance level)? \begin{tabular}{|r|r|} \hline & \\ \hline Week & Demand \\ \hline 1 & 9 \\ \hline 2 & 8 \\ \hline 3 & 9 \\ \hline 4 & 12 \\ \hline 5 & 9 \\ \hline 6 & 12 \\ \hline 7 & 11 \\ \hline \end{tabular} ES (0.1) Abs Error \begin{tabular}{|l|} \hline LR \\ Fited \\ Value Abs Error \\ \hline \end{tabular} Forecast Period 10 MAD

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!