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

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

Discrete random variable, ABC company has 2000 accounts receivable. The mea...

ABC company has 2000 accounts receivable. The mean and standard deviation are $300 and $50, respectively. Assume that the accounts are normally distributed.

Mean and standard deviation, We have two applicants who are applying for a ...

We have two applicants who are applying for a job. They both took the high school exit exam, but different ones. Shannon took the ACT and scored 26, Frank took the SAT scored 1350.

Adaptations, what are flatworms adaptations

what are flatworms adaptations

What is managerial accounting system, Define the Management or Managerial A...

Define the Management or Managerial Accounting System. Ans.  As the name suggest management or managerial accounting system refers to the Management of the firm or company,

Why is an increase in inventory shown as a negative amount?, Why is an incr...

Why is an increase in inventory shown as a negative amount? A rise in stock indicates that a company has purchased more goods than it has sold. Increasing stock requires a money

#title. .decision tree, Assume that you have a client that is a paper manuf...

Assume that you have a client that is a paper manufacturer and they have expressed concern that the government will pass a new regulation banning the use of chlorine-based technolo

#titletime series, importance of time series in statistics

importance of time series in statistics

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