Calculate the mean absolute percentage error, Basic Statistics

Assignment Help:

Littlefield Laboratories is a state-of-the-art highly automated blood samples testing lab. The demand of blood sample testing for the previous 20 days (day 1 to day 20) are given in the EXCEL file "LF demand.xls" on Blackboard. You are asked to perform demand forecast for day 22. There are two steps to that end. First you need to choose a "best" forecasting model and, second, use that model to forecast demand on day 22. The manager does not specify which forecasting model you should use, so you need to compare different forecasting models to determine the appropriate one to use. You consider the following four models.

1215_Calculate the Mean Absolute Percentage Error.png

To see which model works the best, you need to compare their forecast accuracy for demand in the past. In other words, you compare their forecast accuracy for days 5 to 20 (comparing days 5 to 20 because you can derive forecasts for every model starting on day 5).

a. Please calculate forecasts and MAPE of each of the four forecasting models for days 5 to 20.

b. Please plot actual demand for days 1 to 20, forecasts of moving average for days 5 to 20 on the same chart in EXCEL. You should see that forecasts of moving average lag behind the trend.

c. Which forecasting model generates the smallest MAPE? You will pick that model to forecast demand for day 22 because historically it produces the smallest forecast error. Please forecast demand for day 22 using the model with the smallest MAPE.


Related Discussions:- Calculate the mean absolute percentage error

Probability, How can you use probability to improve your chances of winning...

How can you use probability to improve your chances of winning at a casino

Esk jewellery, You are working for the management of ESK Jewellery as a mar...

You are working for the management of ESK Jewellery as a marketing consultant. The main business of ESK Jewellery is the retailing of diamond jewellery. They opened their first sho

How long it takes a ball to fall to the bottom of a cone, A game that frien...

A game that friends and I try to play to guess how long it takes a ball to fall to the bottom of a cone and how many revolutions around the cone it will take. I do not have a lot

Identification of critical data elements, Check numbers for No Neighboring ...

Check numbers for No Neighboring States with Video Gaming, 2% inflation, 4 Average Bets Numbers for 2018 Average Return -0.082 Net Income -$2,052,859 End of Year Cash $5,0

Qualitative features of financial, Conceptual Structure has also resolved s...

Conceptual Structure has also resolved several issues which were uncertain by sales expectations for some time. Activities and dealings that can't be worked by designed financial s

Revenue recognition assigment, When selling books through insaltalments and...

When selling books through insaltalments and internet, what is an alternative selling method for better revenue recording?

Find the probability that a cup of drink chosen at random, Question: (i...

Question: (i) A soft drink machine is regulated so that it fills an average of 300 cL per cup. If the amount of drink in each cup is normally distributed with standard deviati

Card custodian statement, Card custodian statement A zero poise due declar...

Card custodian statement A zero poise due declaration: listing all transactions throughout the billing period: that is sent to the buy card custodian by the purchase card supplier

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd