A Tutorial on Exponential Forecasting and Smoothing in Excel

Written by tom mcnulty
  • Share
  • Tweet
  • Share
  • Pin
  • Email
A Tutorial on Exponential Forecasting and Smoothing in Excel
(number background image by kuhar from Fotolia.com)

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

Show MoreHide


    Build a Model in Excel to Exponentially Smooth Data

  1. 1

    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.

  2. 2

    Enter data, such as stock prices, into cells A1 to A25.

  3. 3

    Click on "Tools" in the Toolbar, and scroll down to "Add-Ins."

  4. 4

    Check the "Analysis ToolPak" box.

  5. 5

    Click on "Tools" again and scroll down to "Data Analysis."

  6. 6

    Scroll down to "Exponential Smoothing" and click "OK."

  7. 7

    Click in the "Input Range" box, and highlight cells A1 to A25.

  8. 8

    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.

  9. 9

    Click in the "Output Range" box, and click into cell B1 in the spreadsheet. Click "OK."

  10. 10

    Review the results produced in column B.

Don't Miss

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the eHow.co.uk site, you consent to the use of cookies. For more information, please see our Cookie policy.