Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I see many solutions to this problem, but they're doing it up to week 8. Can anyone do it up to week 10 please? The
I see many solutions to this problem, but they're doing it up to week 8.
Can anyone do it up to week 10 please?
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. SUMMARY OUTPUT Regression Statistics Multiple R 0.661438 R Square 0.4375 Adjusted R 0.325 Standard E 1.341641 Observatic 7 ANOVA 1 1.3.1 ( 5 points) What % of variation in the data is explained by the model? 1.3.2 (5 points) What is the p-value of the slope (week)? Is there a significant relationship between demand and time (with a p value threshold of 5% )? 1.4. (10 points) Please determine the best forecasting model for the data above among MA, ES and LRStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started