Purchase Solution

Exponential Smoothing Forecast, MSE, MAE and MAPE

Not what you're looking for?

Ask Custom Question

With the gasoline time series data from Table 6.1, show the exponential smoothing forecasts using x = 0.1.
Week 1 2 3 4 5 6 7 8 9 10 11 12
Value 17 21 19 23 18 16 20 18 22 20 15 22

a. Applying the MSE measure of forecast accuracy, would you prefer a smoothing constant of x = 0.1 or x = 0.2 for the gasoline sale time series.
b. Are the results the same if you apply MAE as the measure of accuracy?
c. What are the results if MAPE is used?

Purchase this Solution
Solution Summary

The solution provides detailed explanation how to calculate MSE, MAD and MAPE.

Purchase this Solution
Free BrainMass Quizzes
Know Your Statistical Concepts

Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.

Measures of Central Tendency

This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.

Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

Measures of Central Tendency

Tests knowledge of the three main measures of central tendency, including some simple calculation questions.

View More Free Quizzes
Related BrainMass Solutions

  • Forecast Analysis

    Using MAD, MSE, and MAPE as guidance, find the best number of moving average periods and best smoothing constant for exponential smoothing. (You might consider using data tables to facilitate your search.) 2.

  • Stocks

    Using MAD, MSE, and MAPE as guidance, find the best number of moving average periods and best smoothing constant for exponential smoothing. (You might consider using data tables to facilitate your search). Please refer to the attachment.

  • Analysis on 4 forecasting models using Excel

    Based upon using the 3-Month Moving Average Model and mean squared error (MSE) as a measure of forecast accuracy, what would be the interval estimate for projected demand for the test equipment for time period 25?

  • Forecast Analysis for Performance Lawn Equipment

    MSE, MAD and MAPE were also calculated along with standard error for exponential smoothing for Mower and Tractor sale. Similarly all estimates were provided for linear method in the excel file.

  • Toyota Motors Forecasting

    Compute MAD and MAPE for months 2 through 12 for the double exponential smoothing forecast and compare them with those of simple exponential smoothing in problem 2(b).

  • Monthly Number of Airline Tickets Sold

    Using the model of part c, calculate the MSE, MAE, and MAPE. e. Find the forecast for the proportion of American children living below poverty level in the next year. 4. Consider the 30-year mortgages rates in the U.S. Answer the following: a.

  • Use exponential smoothing to make the prediction

    In this solution, an example for exponential smoothing for forecasting is provided. In addition, comparison between exponential smoothing and linear regression is made based on MAPE.

  • Use Excel to answer forecasting questions

    ________ d) What is the value of MAPE for exponential smoothing method from (other question: alpha = 0.85)? ________ e) What is the value of MAPE for regression? ________ f) Based on MAPE, which method is better?

  • Production Management - Southern University, Hard Rock'S Rockets

    MSE = Average of the Sum of Squared Forecast errors Mean Absolute Percentage Error (MAPE): The size of MAE and MSE depends on the scale of data, so it sometimes becomes difficult to make comparisons.

View More Related Solutions