Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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 LR

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Advances In Entrepreneurial Finance

Authors: Rassoul Yazdipour

2011th Edition

148998190X, 978-1489981905

More Books

Students also viewed these Finance questions

Question

Determine miller indices of plane A Z a/2 X a/2 a/2 Y

Answered: 1 week ago