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

Force, The 70-m microwave transmission tower

The 70-m microwave transmission tower

Probability, #question An electronic assembly is subjected to a final funct...

#question An electronic assembly is subjected to a final functional test. Suppose that defects occur at random in these assemblies, and that these defects occur according to a Pois

Simple random sample, A simple random sample of n = 300 full-time workers i...

A simple random sample of n = 300 full-time workers is selected from a company list containing the names of all n = 5000 full-time workers in order to evaluate job satisfaction. Gi

Measures of central tendency, List down various measures of central tendenc...

List down various measures of central tendency and explain the difference between them?

Determine the price rate-demand , SkyyMarley Airlines has determined that t...

SkyyMarley Airlines has determined that the price elasticity of demand for two customer segments (Coach and Business Class) is -1.35 and -2.50.  Based on their expectations of prof

Business forecasting, Ask questionmethods of business forecasting #Minimum...

Ask questionmethods of business forecasting #Minimum 100 words accepted#

Normal Approximation to Binomial Probability Distribution, A machine that f...

A machine that fills quart milk cartons is set up to average 32.2 oz per carton, with a standard deviation of 1.2 oz. Assume a normal distribution for all of the cartons filled, wh

Sketch the frequency resoponce, i) For a 3 term averagin filter, write a di...

i) For a 3 term averagin filter, write a difference eqatuon governing the filter and dervie the corresponding z transform Sketch a pole zero plot, would this filter be stable, why

3-month absolute deviation, For our class homework we prepared a 3-month fo...

For our class homework we prepared a 3-month forecast for sales (12 months with actual sales for each month). What or how do we figure the absolute deviation of the 3-month foreast

Interpretation or analysis of financial statements, Interpretation or Analy...

Interpretation or Analysis of Financial Statements. Financial report research (or financial analysis) the procedure of comprehension the possibility and earnings of an organizat

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