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

Definition of capital lease as a financial arrangement, Definition of capit...

Definition of capital lease in term of financial arrangement whereby a lessee pays rental for asset. Capital lease is a financial arrangement underlying a agreement where a lesse

Give structural reasons for the binding dependence, Binding studies were ca...

Binding studies were carried out in which heparin was immobilized on the surface of cuvettes. The pH dependence of HPRG binding to heparin was investigated and the results are show

Bond premium cycle, Bond premium cycle The excess of the price for which a ...

Bond premium cycle The excess of the price for which a connection is acquired or sold over its face value resulting from a disparity connecting the market rate of interest and the

Explain what is signal reliability ration, A. If CD players are able to use...

A. If CD players are able to use the LDD strategy better than pure chance then explain what happens to the signal reliability ration as a CD player detects more cautiously B. As

Buildings solutions, Buildings solutions Permanent arrangements owned or ...

Buildings solutions Permanent arrangements owned or held by the state. The cost of buildings includes both acquisition costs (historical cost, ancillary costs, and, for proprieta

Adaptive sampling design, Adaptive sampling design   The sampling de...

Adaptive sampling design   The sampling design in which the method for selecting  the sampling Units on which to make observations might rely on the observed values of the v

Time series, what are the uses of time series

what are the uses of time series

General linear regression model, find the variance of least square estimato...

find the variance of least square estimator beta hat for general linear regression model when k=2 in matrix form?

What is Accrued expenditures or expenses, Costs or expenses that connect wi...

Costs or expenses that connect with the appropriate identification requirements of the finance type engaged but have not been compensated. Acquired expenses are required to be comp

Activity based costing, Traditional cost accounting has been based on alloc...

Traditional cost accounting has been based on allocating a subjective or calculated range of indirect expenses to direct costs. Activity Based Costing (ABC) offers an alternative a

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