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

Bond calculation, Calculate the original price of the bond. Bonds were issu...

Calculate the original price of the bond. Bonds were issued at $200,000 of x% ten-year term bond at an effective annual interest rate (market rate) of x%. The bonds pay interest se

Y-axis component of the centroid for an object, I would just like the formu...

I would just like the formula to find the y-axis of a centroid.

Rolling Dice, I roll a fair die n times and don’t see the face 1 in the fir...

I roll a fair die n times and don’t see the face 1 in the first r rolls (r

Probability, A certain manufactured item is visually inspected by two diffe...

A certain manufactured item is visually inspected by two different inspectors. When a defective item comes through the line, the probability that it gets by the first inspector is

Operation research, A paper mill produces two grades of paper viz., X and Y...

A paper mill produces two grades of paper viz., X and Y. Because of raw material restrictions, it cannot produce more than 400 tons of grade X paper and 300 tons of grade Y paper i

Compute the outlier diagnostics, Use the following four data sets for probl...

Use the following four data sets for problem 1.  Be aware that this is a very interesting series of data sets with some special properties. I do not have data files for these data,

Calculate the mean value and variance, 1. Generate 1000 samples for each of...

1. Generate 1000 samples for each of the following discrete random variables: (a). Binomial distribution with n=40, p=0.7, and distr. with n=50, p=0.5 (b). Geometric distribu

Isotopes, Isotopes Elements having same atomic number Z, but different A ...

Isotopes Elements having same atomic number Z, but different A mass number for example 126C, 146C and 11H 21H, 31H are isotopes of carbon and hydrogen.

Cost accounting, Job Order Gosting ln an attempt to conceal a thefi of fund...

Job Order Gosting ln an attempt to conceal a thefi of funds, Kaito Kid, controller of Shinichi Products, lnc. placed a bomb in the company s record vault. The ensuing explosion lef

Amortized cost , Amortized cost The par value of its decision enhanced or ...

Amortized cost The par value of its decision enhanced or lowered by any unamortized top quality or lower price.

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