Purchase Solution

Moving Average and Trend Analysis

Not what you're looking for?

Ask Custom Question

4. The following sales data are available for 1998-2003 inclusive:

Year Demand
1998 7
1999 12
2000 14
2001 20
2002 16

a. Determine a 4-year moving average forecast for 2003.
b. Use a linear trend model to predict years 2004, 2005, 2006 and 2007.

Purchase this Solution
Solution Summary

The solution determines a 4-year moving average forecast for 2003.

Solution Preview

a. Moving Average for 2003 = (12+14+20+16)/4=15.5
b. Please see ...

Purchase this Solution
Free BrainMass Quizzes
Measures of Central Tendency

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

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.

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.

View More Free Quizzes
Related BrainMass Solutions

  • Forecasting the Demand - Moving Average and Trend Analysis

    86964 Forecasting the Demand - Moving Average and Trend Analysis Forecasting Exercise Year Demand ( in 1000's ) 1 13 2 17

  • Trend Analysis of Walmart

    528305 Trend analysis of Wal-mart Trend Analysis of Walmart Techniques to be used: 50-days, 100-days and 200-days Moving averages, Exponential moving average and Weighted average moving average. Source for data: http://finance.yahoo.com/q/hp?

  • Time series using forecast accuracy and suitability of methods

    The techniques used are: I Naïve (Level) II Naïve (Trend) III Naïve (Season) IV Arithmetic Mean V 6-Month Moving Average VI 12-Month Moving Average VII 6 Month Weighted Moving Average VIII Single Exponential Smoothing IX Linear Trend Exponential

  • Moving Average Forecasting Models

    Chart Data How do the moving averages for the same values of m compare between a trend-moving average and a centered-moving average?

  • Forecasting Problems

    173331 This posting provides solution to several forecasting problems including moving average, exponential smoothing, trend analysis, weighted moving average etc.

  • Forecasting Corporate Triple A Bond

    Develop three- and four-month averages for this time series. Which moving average provides the better forecasts? Explain. b. What is the moving average forecast for the next month?

  • MCQs on forecasting methods/techniques

    regression analysis C. trend analysis D moving average method 8.

  • Patterns of Time Series Data

    Trend Analysis: There are no proven "automatic" techniques to identify trend components in the time series data; however, as long as the trend is monotonous (consistently increasing or decreasing) that part of data analysis is typically not very difficult

  • Data Analysis on Soft Drink Study

    Values of a+b e) Calculate Mean Sum of Squared Errors f) Forecast 2011 rates g) 3 year moving average h) Create smoothing trend using weight of .7 Dear student The solution file is attached. Thanks.

View More Related Solutions