AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |
Back to Blog
The larger alpha (smaller the damping factor), the closer the smoothed values are to the actual data points. Repeat steps 2 to 8 for alpha = 0.3 and alpha = 0.8.Ĭonclusion: The smaller alpha (larger the damping factor), the more the peaks and valleys are smoothed out. 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.Ħ. Microsoft Office Compatibility Pack for Word, Excel, and PowerPoint File Formats Free Open, edit, and save files using the new file formats in 2007 versions of Word, Excel, and PowerPoint. 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.
0 Comments
Read More
Leave a Reply. |