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

Marginal costing and break-even analysis, Marginal costing and Break-even a...

Marginal costing and Break-even analysis According to C.I.M.A. Manchester, "Marginal Price means the quantity at any given variety of result by which get worse scenario costs ar

Jurnal entry, Depreciation on the company''s equipment for 2011 is computed...

Depreciation on the company''s equipment for 2011 is computed to be $16,000.

Clearance pattern, Clearance pattern The proportion of the entire amount d...

Clearance pattern The proportion of the entire amount disbursed that is debited alongside the state''s bank account every day after the disbursements,

Long term credit decision, Long Term Credit Decision In no more than o...

Long Term Credit Decision In no more than one typed page, provide a statement of your decision to lend or not lend to this company based on your interpretation of the company'

Shamim, the monthly income( in tk''s)persons workingin afarmis as flows ,14...

the monthly income( in tk''s)persons workingin afarmis as flows ,14870,14930,15020,14460,14750,14920,15720,15160,14680,14890 find average monthly income?

examine the distributions of the sample data, A second file on DocDepot na...

A second file on DocDepot named Marks.mtp contains the final exam percentages of students in ADM2304A in the Fall 2011 semester. Assume that the class can be considered a random sa

Opertions research, meaning and definition of operations rsearch

meaning and definition of operations rsearch

Method of analysis used by the firm, 1. (i) Complaints were made about the ...

1. (i) Complaints were made about the level of pollutants in the discharge from a certain factory.  The factory refuted the complaints by showing the results of their own analysis

Projectile motion, A fox fleeing from a hunter encounters a 0.730 m tall fe...

A fox fleeing from a hunter encounters a 0.730 m tall fence and attempts to jump it. The fox jumps with an initial velocity of 7.10 m/s at an angle of 45.0°, beginning the jump 2.1

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