Explore BrainMass
Share

Expoentail smoothing

This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

Need help with the attached problem. Please provide solution and explanation in EXCEL format.
=============================================================

Problem #7.6
Following are time-series data for nine time periods. Use exponential smoothing with constraints of .3 and .7 to forecast time periods 3 through 9. Let the value for time period 1 be the forecast for time period 2. Compute additional forecasts for time periods 4 through 9 using a 3-month average. Compute the errors for the forecasts and discuss the size of the errors under each method.
Time Period Value Time Period Value
1 9.4 6 11.0
2 8.2 7 10.3
3 7.9 8 9.5
4 9.0 9 9.1
5 9.8

© BrainMass Inc. brainmass.com March 21, 2019, 5:17 pm ad1c9bdddf
https://brainmass.com/statistics/regression-analysis/time-series-forecasting-exponential-smoothing-215632

Attachments

Solution Preview

Please see the attachments for fully formatted explanation.
=====================================

Problem #7.6
Following are time-series data for nine time periods. Use exponential smoothing with constraints of .3 and .7 to forecast time periods 3 through 9. Let the value for time period 1 be the forecast for time period 2. Compute additional forecasts for time periods 4 through 9 using a 3-month average. Compute the errors for the forecasts and discuss the size of the errors under each method.
Time ...

Solution Summary

The solution provides step by step method for exponential smoothing. Formula for the calculation and Interpretations of the results are also included.

$2.19