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

What is the probability that a major defect is detected, Back to the worksh...

Back to the workshop the previous problem but assuming that in each of the three stages of development, there is a certain probability that a major defect is detected. When such a

find the return period of critical event, A drainage system overows into a...

A drainage system overows into a river causing pollution when the rainfall falling in an hour exceeds 50 mm. During any given year, the maximum hourly rainfall follows an exponenti

Process costing - accounting for scrap.., a company has two processes whose...

a company has two processes whose details are as follows: Materials 3000kg @ k0.30/kg, labour K120 for process 1 and material 2000kg @ k0.40/kg and labour k84 for process 2. actual

Completely randomized design, Ask question #MinimumAgency revenues. An econ...

Ask question #MinimumAgency revenues. An economic consultant was retained by a large employment agency in a metropolitan area to develop a regression model for predicting monthly a

Probability, Find the z value corresponding if the area to the left of the ...

Find the z value corresponding if the area to the left of the z is 0.9452

Marginal and absorption costing, difference of them for covering the follo...

difference of them for covering the following: 1.purpose of reporting 2.FORMAT OF INCOME STATEMENT

Anova, How to interpret Anova

How to interpret Anova

Mean - median and frequencies, Put the appropriate summary statistics, e.g....

Put the appropriate summary statistics, e.g. mean, median, frequencies, percentages, for the different variables into a table to make them concise. You can see examples of consise

Comprehending Behavior Statistics, I was recently buying shoes when the sal...

I was recently buying shoes when the salesperson commented on how large my feet were. After telling him he had lousy sales techniques, I decided to investigate if I really do have

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