Exponential smoothing is a financial technique that uses moving averages to remove peaks and valleys from a set of financial data.
- Skill level:
- Moderately Challenging
Things you need
- PC running Microsoft Excel
Open a blank Excel worksheet. Do this by double-clicking on the Excel icon on the PC's desktop screen. Click "File" on the toolbar, and scroll down to "New." Double-click and a blank worksheet will open.
Enter data, such as stock prices, into cells A1 to A25.
Click on "Tools" in the Toolbar, and scroll down to "Add-Ins."
Check the "Analysis ToolPak" box.
Click on "Tools" again and scroll down to "Data Analysis."
Scroll down to "Exponential Smoothing" and click "OK."
Click in the "Input Range" box, and highlight cells A1 to A25.
In the "Damping Factor" box, enter your desired damping factor. The higher the damping factor, the smoother, or flatter, the data will be. The most commonly used values are 0.2 or 0.3.
Click in the "Output Range" box, and click into cell B1 in the spreadsheet. Click "OK."
Review the results produced in column B.
Build a Model in Excel to Exponentially Smooth Data
- 20 of the funniest online reviews ever
- 14 Biggest lies people tell in online dating sites
- Hilarious things Google thinks you're trying to search for