Mathematics Homework Solutions
Problem
#80720

Calculate the Mean Square Error

Calculate the Mean Square Error (MSE).

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 an exponential smoothing with a smoothing constant of 0.25.
b. Calculate the Mean Square Error (MSE).


Solution Summary

The solution provides explanations and instructions on how to calculate the Mean Square Error in the attached Excel file.

Solution
What is this?
By OTA - Overall OTA Rating
Vinh (Vincent) Dang, PhD - 4.8/5
Purchase Cost Now
$2.19 CAD (was ~$11.97)
Included in Download
  • Plain text response
  • Attached file(s):
    • exponential smoothing.xls
Instant Download
Add to Cart
Why you can trust BrainMass.com
  • Your Information is Secure
  • Best Online Academic Help Service
  • Students find real academic Success
Related Solutions
  • Forecasting - 1. Gasoline sales time series Week Sales (000s of gallons) 1 17 2 21 3 19 4 23 5 ...
  • Quantitative Methods: Forecasting using exponential smoothing, - 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 3. Forecast the month of D ...
  • QUANTITATIVE METHODS: Forecasting - Show all work, where appropriate in using Excel (no version higher than 2003), PLEASE INCLUDE ALL FORMULARS IN CELLS WHERE CALCULATIONS ARE MADE. Recent past demand for product ZXT is given in the ...
  • Quantitative Methods : Moving Averages, Exponential Smoothing and Forecasting - 1. The Snyder company percentages of all shipments that were received on time over the past 12 months are 80, 82, 84, 83, 83, 84, 85, 84, 82, 83, 84 and 83… A. Compare a 3-month moving-average ...
  • Math for decision making - 1. The number of pizzas ordered on Friday evenings between 5:30 and 6:30 at a pizza delivery location for the last 10 weeks is shown below. Use exponential smoothing with smoothing constants of .2 an ...
Browse