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

Student, Design an activity based cost system requires that: a) the job bid...

Design an activity based cost system requires that: a) the job bid process redesigned b) resource costs be linked to the activities performed c)the cost of activities be linked to

Calculate the standard error and confidence interval, 1. You have a regiona...

1. You have a regional country-year dataset over 10 years of 150 total observations, within this data you have 25 observations where the ruling party has lost power. (a) Assumin

Treatment of cst and vat, Treatment of CST and VAT in Sales Book A suppl...

Treatment of CST and VAT in Sales Book A supplier who expenses the CST for inter declares purchase by him, is responsible to first deposit the gathered CST from bought to Got Co

What is Nuclear holocaust, Nuclear holocaust It is the name given to large...

Nuclear holocaust It is the name given to large scale destruction and devastation that would be caused by the use of nuclear weapon. The radioactive waste will hang like a cloud i

Generally accepted accounting principles, Can the Depreciation on Assets be...

Can the Depreciation on Assets be recorded in Single Entry system? No, it cannot be possible. What do you mean by Computer Hardware? The computer is made with different co

Index nos, why indux number considerd as an economic barrometer

why indux number considerd as an economic barrometer

Mba: accounting & finance for managers, . From the following cost, product...

. From the following cost, production and sales data of Decors Motor Ltd., prepare comparative income statement for three years under (i) absorption costing method, and (ii) margi

Calculate the posterior variance and mean, 1. Suppose that there is a Beta(...

1. Suppose that there is a Beta(2,2) prior distribution on the probability µ that a coin will yield a "head" when spun in a speci?ed manner. The coin is independently spun 10 times

What is the speed of the block, A prevent of huge m = 10 kg is drawn by a p...

A prevent of huge m = 10 kg is drawn by a power F = 100 N at a position q = 30o with the horizontally along a sleek horizontally exterior. What is the speed of the block? (g = 10 m

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