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

Hypotheses testing, Celia is a nurse in a geriatric ward.  She noticed that...

Celia is a nurse in a geriatric ward.  She noticed that older persons in her care are having problems sleeping at night.  She decided to introduce non-pharmocologic ways of relaxat

Regression analysis, Data was gathered on a group of ninth grade students. ...

Data was gathered on a group of ninth grade students. Some students have been diagnosed with a learning disability.  All students were measured on conduct, attention, hyperactivity

Probability, the probability that you win a game is 0.3. if you play the ga...

the probability that you win a game is 0.3. if you play the game 20 times. what is the probability that you will win at least 8 times?

Employee portion of social security tax, Employee portion of Social Securit...

Employee portion of Social Security tax A key part of paycheck bookkeeping is the Public Protection tax (The Public Protection tax along with the Medical health insurance tax m

Demonstrate the potential risk from financing in eurodollars, You have the ...

You have the following information about rates in London for Eurocurrency loans of one-year duration, the exchange rate between the USD and euros, the currency in which you want fi

Plot a histogram of sample hypnotized, Computer Project for Student Exam Sc...

Computer Project for Student Exam Scores The data in the excel spread sheet titled Data for Hypothesis Testing in the column titled Scores from Student Population represents m

Determine the probability of coding region , Using 1 st order models shown...

Using 1 st order models shown in homework 2 solution determine the probability of coding region in frame two for DNA fragment AGTAGCTTCCAG. Use only parameters provided in the hom

Total stockholders equity, To determine the amount at which inventory shoul...

To determine the amount at which inventory should be reported on the December 31 Year 1 balance sheet, Monroe Company compiles the following information for its inventory of Produc

Find out revised probabilities for symptoms, This problem set consists of t...

This problem set consists of three problems and a short essay.  Each problem is worth 7 points, the essay is worth 4 points for a total of 25 points. 1.  What are the chances th

Graph, Difference between Historigrams and Histogram

Difference between Historigrams and Histogram

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