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

Data for ogive graph, Data for ogive graph in sectors of indian economy

Data for ogive graph in sectors of indian economy

Observe value of the appropriate test statistic, As part of a study of corp...

As part of a study of corporate employees, the Director of Human Resources for PNC wants to compare the distance travelled to work by employees at their office in downtown Edmonton

Probability and stochastic process, In a quaternaryphase shift keying (QPSK...

In a quaternaryphase shift keying (QPSK) communications system, one of four equally probable symbols s0,...,s3 is transmitted in T seconds. If symbol si is sent, a waveform x(t,si)

Calculate the predicted mean temperature, The following are actual data sho...

The following are actual data showing the latitude of a sample of major cities in the northern hemisphere and their mean high annual temperature. latitude(X)    mean high temp(Y

Calculate the probability of company, a)  The US Food and Drug Administrati...

a)  The US Food and Drug Administration has veto power over the choice of drug names. In 2004, it used this power regularly, rejecting 36% of the names proposed by companies for re

Construct simulation model-estimate the probability, CBT has agreed to fina...

CBT has agreed to finance the needs of a stereo wholesaler for the next month. To complete the loan agreement, the wholesaler must estimate the cash on hand during the first 90 day

Perform the analysis, Your earlier comparison of three energy technologies ...

Your earlier comparison of three energy technologies showed only a borderline effect using the non-parametric Kruskal-Wallis statistic. This result left you hanging on a decision o

Explain Bond discount, Explain Bond discount The excess of the countenance...

Explain Bond discount The excess of the countenance worth of a bond over the price for which it is acquire or sold resulting from a disparity between the marketplace rate of inter

Administering agency solutions, Administering agency solutions A professio...

Administering agency solutions A professional specific by the Office of Economical Control to provide common management of economic sales action. An administering agency is also a

#introduction to statistics, #A________variable is a variable whose values ...

#A________variable is a variable whose values are countable.

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