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

Explain what is signal reliability ration, A. If CD players are able to use...

A. If CD players are able to use the LDD strategy better than pure chance then explain what happens to the signal reliability ration as a CD player detects more cautiously B. As

ACC 557, Glaser Services acquired 30% of the outstanding common stock of Ni...

Glaser Services acquired 30% of the outstanding common stock of Nickels Company on January 1, 2008, by paying $800,000 for the 45,000 shares. Nickels declared and paid $0.30 per sh

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

Compute the value for the test statistic-spss, A number of years ago the Am...

A number of years ago the American Academy of Pediatrics recommended that tetracycline drugs not be used for children under the age of 8. Prior to this recommendation, a two-year s

Calculate the probability, The Stalk Market, an independent grocery chain, ...

The Stalk Market, an independent grocery chain, has been serving and supporting local communities for over 90 years. Its stores offer friendly service and a wide assortment of natu

Give structural reasons for the binding dependence, Binding studies were ca...

Binding studies were carried out in which heparin was immobilized on the surface of cuvettes. The pH dependence of HPRG binding to heparin was investigated and the results are show

Compute the maximum standard deviation, The specification for a plastic han...

The specification for a plastic handle calls for a length of 6.0 inches ± 0.5 inches (5.5 to 6.5 inches). The process is known to operate at a mean thickness of 6.1 inches.  The mi

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