Data Analysis with Exponential Smoothing
Posted in Spreadsheet tips on December 4th, 2008 by iip – Be the first to commentExponential smoothing is a time series analysis that omits irregular variation without take account of both seasonal variation and trend. MS Excel provides exponential smoothing as a part of tools in Data Analysis. The tool can predict a value based on the forecast for previous period. Exponential smoothing adjusts error in that prior prediction. It uses Constanta which is reflects the magnitude of which control how strongly the forecasts react to errors in the previous prediction. Smaller constants can result in long lags for prediction values.
How to apply exponential smothing analysis in Excel 2007? You should install add-ins of Data Analysis before.
Incoming search terms :
- exponential smoothing excel 2007
- how to do exponential smoothing in excel 2007
- exponential smoothing in excel 2007
- exponential smoothing excel
- Excel exponential smoothing
- exponential smoothing
- excel 2007 exponential smoothing
- how do you use exponential smoothing in excel 2007
- exponential smoothing excel seasonality
- How do I do an exponential smoothing problem in Excel 2007?
