Answered step by step
Verified Expert Solution
Link Copied!

Question

...
1 Approved Answer

Please help me understanding this homework. Please provide a clear step by step solution. If you use excel, please enable the formulas so I can

image text in transcribedimage text in transcribed

Please help me understanding this homework. Please provide a clear step by step solution. If you use excel, please enable the formulas so I can see how you obtain the answers.

Thanks a lot!!

image text in transcribedimage text in transcribed
Forecasting Error Measure To test the validity of me forecasting model, compute {absolute} forecast errors. {cumulative} absolute errors. MAD, MSE, and MAPE. Following is le forecast and the actual demand. \\Meek Forecast Actual l 3150 39.50 2 315m 4 | '90 3 3900 4430 4 4| 2.5 35.50 .5 4350 39110 6 4200 4460 T 45:10 4F00 QUESTION 1 Find the forecast (absolute) error for Period 7? O 240 O 200 O 220 O 190 QUESTION 2 Find the forecast (cumulative) absolute error for Period 7? 2805 O 2870 O 2200 O 2640 QUESTION 3 Find the MAD (Mean absolute deviation) for period 7? O 400.7 O 420.3 344.69 O 470 QUESTION 4 Find MSE (Mean Square Error) for all forecasting periods? 195525 17552 15525 187103.6 QUESTION 5 Find MAPE (Mean Absolute Percentage Error) for period 7? O 20.04% 9.85% 14.03% 13.06%

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

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

Step: 2

blur-text-image

Step: 3

blur-text-image

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

Income Tax Fundamentals 2013

Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill

31st Edition

9781285586618

Students also viewed these Mathematics questions