Purchase Solution

Forecasting using Moving Average

Not what you're looking for?

Ask Custom Question

Data covering the most recent 30 days are given in the following table for the price per gallon of regular gasoline at a local station.
__________________________________________
Day Price Day Price
1 2.53 16 2.46
2 2.35 17 2.60
3 1.91 18 2.10
4 2.20 19 2.01
5 1.77 20 2.14
6 3.26 21 2.03
7 1.63 22 2.68
8 2.73 23 2.59
9 2.41 24 2.99
10 2.72 25 2.94
11 2.87 26 1.77
12 1.49 27 2.62
13 2.92 28 3.19
14 3.53 29 3.01
15 2.74 30 2.10
________________________
a. Compute a forecast for the next day's price by using a 3-day moving average. What is the forecast? What is the MSE for the last five observations?
b. Can you reduce the MSE for the last five observations by changing the moving average window (try 4-to10-day windows)?
c. Compute a forecast for the next day's price by using exponential smoothing with a=0.25 What is the forecast? What is the MSE for the last five observations?
d. Can you improve the MSE for the last five observations by changing the smoothing constant a?

_______________________________________

*Please show all work, use excel and identify the value and units measured.
(Notes for my own Use: Ch9:5)

Purchase this Solution
Solution Summary

This posting presents how to do forecasting with moving average method using excel modeling with criterion of Mean Square error and varying smoothing constant.

Purchase this Solution
Free BrainMass Quizzes
Economics, Basic Concepts, Demand-Supply-Equilibrium

The quiz tests the basic concepts of demand, supply, and equilibrium in a free market.

Elementary Microeconomics

This quiz reviews the basic concept of supply and demand analysis.

Pricing Strategies

Discussion about various pricing techniques of profit-seeking firms.

Economic Issues and Concepts

This quiz provides a review of the basic microeconomic concepts. Students can test their understanding of major economic issues.

Basics of Economics

Quiz will help you to review some basics of microeconomics and macroeconomics which are often not understood.

View More Free Quizzes
Related BrainMass Solutions

  • Analysis on 4 forecasting models using Excel

    • 3-Month Moving Average Model • 3-Month Weighted Moving Average Model • Exponential Smoothing Model • Regression Model 2.

  • Time Series Forecasting Methods

    The moving average shows the forecasting demand is stable but doesn't show trends in the demand behavior. The moving average will have a smoother forecast when the moving average period is longer.

  • When using the exponentially weighted moving average for purposes of forecasting rather than smoothing

    But When we using the exponentially weighted moving average for purposes of forecasting we find the next observation The expert examines exponentially weighted moving average for purposes of forecasting.

  • Forecast Analysis

    Develop spreadsheet models for forecasting prices using single moving average and single exponential smoothing. b.

  • Forecasting by moving average methods

    Solution depicts the steps for forecasting a period by using moving average, weighted moving average and exponential smoothing method.

  • Moving Average Forecasting

    An Introduction to Time Series Analysis and Forecasting. US: Academic Press. The expert examines moving average forecasting. The consequences of using an inaccurate forecast are determined.

  • Compariosn of forecasting methods

    Calculate the simple three-month moving average for periods 10-12. b. Calculate the weighted three-month average using weights of 0.50, 0.30, and 0.20 for periods 10-12. c.

  • Time Series Analysis

    These include: 1)Simple Moving Average 2)Weighted Moving Average 3)Exponential Smoothing 4)Linear Regression 5)Seasonal Forecasting via Regression, if we determine it is subject to seasonality (i.e., linear trends with multiplicative seasonality

  • Five-period and Ten-period Moving Average Forecasts

    Data set affected by seasonality is not best measured using moving average. Moving average forecast error is high when the seasonality of data is obvious. Which forecast is smoother? Of course, the 10-period forecast is smoother.

  • Forecasting using different methods

    Regards This posting provides forecasting of demand using different methods including moving average, linear regression and exponential smoothing.

View More Related Solutions