The smoothed value for the second data point equals the previous data point.ĩ. Excel cannot calculate the smoothed value for the first data point because there is no previous data point. As a result, peaks and valleys are smoothed out.
Click in the Output Range box and select cell B3.Įxplanation: because we set alpha to 0.1, the previous data point is given a relatively small weight while the previous smoothed value is given a large weight (i.e. The value (1- α) is called the damping factor.Ħ. Literature often talks about the smoothing constant α (alpha). Click in the Damping factor box and type 0.9. Click in the Input Range box and select the range B2:M2.ĥ. Select Exponential Smoothing and click OK.Ĥ. Note: can't find the Data Analysis button? Click here to load the Analysis ToolPak add-in.ģ. On the Data tab, in the Analysis group, click Data Analysis.
