Purchase Solution

Smoothing Techniques

Not what you're looking for?

Ask Custom Question

I have been using basic smoothing techniques such as moving average, median smoothing and exponential smoothing to generate forcasts for the time series in the attached excel file. I would like to know if more advanced smoothing techniques would give better results. The columns in the file are a time series of performance figures for 16 football teams over about 4 years. The best results I've achieved so far, are with exponential smoothing with w=0.2 . If more advanced techniques would improve forcasts, please give a brief explanation of the type of technique used.

Attachments
Purchase this Solution
Solution Summary

The smoothing techniques for moving averages are determined.

Solution Preview

There are several points I would like to clarify for this problem:
First of all, we need to understand the difference between smoothing techniques and forecasting techniques. Normally speaking, the smoothing techniques are used to filter out the noises of the data to get the underlying pattern of the data, whereas forecasting techniques are used to make forecast from the given data set. One has to be really careful when using smoothing techniques to make a forecast. I will discuss this in more detail in the next section. Here I give an example of using forecasting techniques to model this time series data:
The basic time series forecasting model is the ARIMA model. Here I take the ...

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.

Measures of Central Tendency

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

Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

View More Free Quizzes
Related BrainMass Solutions

  • Forecast Analysis

    c) Exponential smoothing, using a 0.1 smoothing factor and Feb. forecast of $69,000. d) Exponential smoothing, using a 0.4 smoothing factor and Feb. forecast of $69,000. e) Which technique provides the best forecast and why.

  • Forecast Analysis

    Comparison of these Forecast Techniques based on these Forecast Accuracy measures has also been shown in details.

  • Development of Appropriate Forecasting Model

    Show work for the following forecast techniques: a. Moving average ( n=3) b. Moving average (n=5) c. Linear trend line d. Exponential smoothing (alpha = .3) e. Exponential smoothing (alpha = .5) f.

  • Demand Forecasting: Measuring forecast accuracy and comparing different techniques/algorithms

    The solution provides help on two forecasting techniques: 1) Moving average methods, 2) Exponential smoothing. In excel, it demonstrates forecast and forecasting error calculations.

  • Forecasting Techniques: Moving Average and Exponential Smoothing

    This solution depicts the steps to forecast the mileage by moving average and exponential smoothing techniques.

  • Time Series Forecasting Methods

    Smoothing techniques were created to have better forecast data points. The random variation that is created by forecasting is reduced through the various smoothing techniques.

  • Forecasting Techniques: Exponential Smoothing

    601668 Forecasting Techniques: Exponential Smoothing YEAR 1 2 3 4 5 6 7 8 9 10 11 DEMAND 7 9 5 9 13 8 12 13 9 11 7 Develop a forecast for year 2 through 12 using exponential smoothing with α = .4 and a forecast

  • Stocks

    Further calculations for Forecast Accuracy Measures (Forecast Error, MAD, MSE, MAPD) has been shown in Excel for the two different Forecast techniques and the accuracy of the two forecasts has been compared using these calculations.

  • The MSE

    The exponential smoothing model and weighted moving average model are two related smoothing techniques for time series data. So, the correct choice is (c) regression model. The MSE is clarified in this solution.

View More Related Solutions