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

Determine the payment at maturity - exchange rate, You have the following l...

You have the following limited information upon which to base your decision as to which is the better of two alternative funding arrangements:  Alternative 1 is to arrange fu

Agglomerative hierarchical clustering methods/procedures, Agglomerative hie...

Agglomerative hierarchical clustering methods/procedures Methods of cluster analysis that start with each individual in the separate cluster and then, in the series of steps, c

perform hypothesis test and find the minimum sample size, Questions ...

Questions In one hybridization experiment 8070 offspring seeds were obtained, and 23.54% of them had green flowers.  The others had white flowers.  Perform a hypothesis test

Histograms, The skewness is a measure of asymmetry and it is positive at 0....

The skewness is a measure of asymmetry and it is positive at 0.15 meaning that it is greater than zero which reveals that the tail extends to the right slightly indicating the dist

How will the adoption of ifrs change financial reporting, How will the adop...

How will the adoption of IFRS change financial reporting by companies? Manager 1: The new rules will definitely change the way our organization prepares financial statements.

Statsgraphic , need to define one statistic and calculate value

need to define one statistic and calculate value

Margin of error, The poll interviewed 1500 persons rather than 1060, for 95...

The poll interviewed 1500 persons rather than 1060, for 95% confidence.

Capital budget, Capital budget The piece of a budget: a separate budget: d...

Capital budget The piece of a budget: a separate budget: dedicated to proposed additions to capital assets & the means of financing to those additions,

Accreted value definition, An assessment time frame for certain purchases a...

An assessment time frame for certain purchases and debt equipment that reviews on the stability piece only that part of their face value that shows major and interest acquired curr

What is her apc, The life-cycle hypothesis is based on the assumption that ...

The life-cycle hypothesis is based on the assumption that people try to smooth their consumption over their expected adult lifetimes.  Suppose Tammy expects to live for another T y

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