Purchase Solution

Forecasting, Trends and Mean Square Error

Not what you're looking for?

Ask Custom Question

Month 1993
January 1.45
February 1.80
March 2.03
April 1.99
May 2.32
June 2.20
July 2.13
August 2.43
September 1.90
October 2.13
November 2.56
December 4.16

Using the chart above I need to:

a. Forecast the month of December using a moving average of 3.

b. Calculate the Mean-Square Error (MSE).

Purchase this Solution
Solution Summary

Forecasting, Trends and Mean Square Error are investigated. The solution is detailed and well presented. The response received a rating of "5/5" from the student who originally posted the question.

Solution Preview

Hello!
When forecasting using a moving average of 3, we use the following formula:

Forecast (t) = (1/3)*(Value (t-1) + Value (t-2) + Value ...

Purchase this Solution
Free BrainMass Quizzes
Solving quadratic inequalities

This quiz test you on how well you are familiar with solving quadratic inequalities.

Probability Quiz

Some questions on probability

Geometry - Real Life Application Problems

Understanding of how geometry applies to in real-world contexts

Multiplying Complex Numbers

This is a short quiz to check your understanding of multiplication of complex numbers in rectangular form.

Graphs and Functions

This quiz helps you easily identify a function and test your understanding of ranges, domains , function inverses and transformations.

View More Free Quizzes
Related BrainMass Solutions

  • Linear Regression, Trends and Forecasting

    Least square trends and equations are determined. An estimation on vending sales are determined.

  • Forecasting with Linear Trend

    forecasting number of new contributors to public radio station, using linear trend technique providing details on mean square error and forecast error.

  • Toyota Motors Forecasting

    Compute the Mean Absolute Deviation (MAD) and the Mean Square Error (MSE) of the forecasts for months 4 to 12. Question 2 Toyota Motors would like to move beyond the moving average method and explore a more sophisticated alternative.

  • Understanding mean error, mean square error, and mean absolute percentage error.

    2987 Understanding mean error, mean square error, and mean absolute percentage error. Three of the most common measures of forecast accuracy are: mean error, mean square error, and mean absolute percentage error.

  • Time Series Forecasting Methods

    The forecasting methods are evaluated based on the Mean Absolute Deviation (MAD) and the Mean Square Error (MSE) results to determine the best results.

  • Time Series Forecasting

    MSE = (1/n) * (sum of error^2) = 22,780,664,440. See Excel sheet for calculation. This solution looks at the moving average and mean square error of a time series.

  • Forecasting sales and mean square error

    512558 Forecasting sales and mean square error of tennis shoes in a sports store in the town's mall 6. Observed monthly sales of a popular brand tennis shoe at a medium-sized sports store at the town?

  • Forecasting, Weighted Averages: Various Questions

    Distinguish between the following: seasonal variation, cycles, trends, and random variation. 4. Distinguish between trend analysis and causal or associative forecasting 5. How is the accuracy of a forecasting method determined? 1.

  • Forecasting and Seasonality

    14659 Forecasting/using Mean Absolute Deviation in Excel or Crystal Ball/OPTQuest I need to forecast out 12 months using 3 different techniques, and then decide which one is best based on MAD (mean absolute deviation).

View More Related Solutions