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

Managerial accounting homework, Your friend Jose is trying to decide whethe...

Your friend Jose is trying to decide whether to buy or lease his next vehicle. He has gathered information about each option but is not sure how to compare the alternatives. Purcha

Definition of batch costing and methods, Batch costing and method of costin...

Batch costing and method of costing whereby identical units produced are treated as a single unit & the cost incurred is shown to the whole of that batch instead of each individual

Calculate index number, TIME SERIES ANALYSIS: 1) Discuss the various m...

TIME SERIES ANALYSIS: 1) Discuss the various models of Time series. 2) What are the various methods of trend analysis? What are their implications in the business world?

Average, characteristics of a Good Average

characteristics of a Good Average

FIFO, how to figure out cost of good available for sale, cost of sales, end...

how to figure out cost of good available for sale, cost of sales, ending inventory

Current development project and presentation , review the financial disclos...

review the financial disclosures for two publicly traded companies. Identify recently promulgated (or proposed) accounting pronouncements that have an impact on the companies. In a

Binomial expansion, what is the largest coefficient of (1+3x)^4 is ?

what is the largest coefficient of (1+3x)^4 is ?

Illustrative statistics with statistics, Company statistics is the technolo...

Company statistics is the technology of good selection in the face of concern and is used in many professions such as financial statistics, econometrics, auditing, generation and f

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