• Skip to primary navigation
  • Skip to content
  • Skip to primary sidebar
  • Skip to footer
EDUCBA

EDUCBA

MENUMENU
  • Resources
        • Excel Charts

          • Histogram Chart Excel
          • Basic Excel Formulas
          • Text to Columns in Excel
        • Excel Charts
        • Excel Tips

          • Excel Gantt Chart
          • IFERROR with VLOOKUP
          • Data Table in Excel
        • Excel Tips
        • Excel Tools in Excel

          • Stacked Column Chart
          • Cheat Sheet of Excel Formulas
          • Excel Data Validation
        • Histogram chart in excel
        • Others

          • Resources (A-Z)
          • Excel Functions
          • Financial Functions in Excel
          • Logical Functions in Excel
          • Lookup Reference Functions in Excel
          • Maths Function in Excel
          • TEXT and String Functions in Excel
          • View All
  • Free Courses
  • All Courses
        • Certification Courses

          Excel Course 1
        • All in One Bundle

          All-in-One-Excel-VBA-Bundle
        • Excel course

          Excel-Training
        • Others

          • Excel advanced course
          • VBA Course
          • Excel Data Analysis Course
          • Excel for Marketing Course
          • Excel for Finance Course
          • View All
  • 120+ Courses All in One Bundle
  • Login

Excel Exponential Smoothing

Home » Excel » Blog » Excel Tools » Excel Exponential Smoothing

Exponential Smoothing in Excel

Excel Exponential Smoothing (Table of Contents)

  • Exponential Smoothing in Excel
  • Where the Exponential Smoothing is found in Excel?
  • How to Use Exponential Smoothing in Excel?

Exponential Smoothing in Excel

  • For business growth, if we are able to predict the future by using available past data then it will be very helpful to take business decisions. Exponential Smoothing is the best technique to do this in excel.
  • Exponential Smoothing helps you to forecast or predict the data points for taking business decisions. By using this method, we try to minimize or reduce the difference between variations. This method gives a more accurate picture of the business.
  • We try to smooth the random variation in the data to show the trends between them. This process is very easy to use and give a good performance. This method eliminates the difference and smoothes out the data.
  • This method is used for time series data.

Where the Exponential Smoothing is found in Excel?

It is found under Analysis ToolPak in Excel. The Analysis ToolPak is a Microsoft Excel data analysis add-in. This add-in is not loaded automatically on excel. Before using this first, we need to load it.

Start Your Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

Steps to load the Analysis ToolPak add-in:

We need to add this feature in Excel for analyzing business by using Excel Add-Ins. To add this feature in Excel follow below steps:

  • Go to the FILE tab. Click on the OPTIONS tab in the left pane window. Refer below screenshot.

Step 1

  • It will open a dialog box for Excel Options. Click on Add-Ins tab as shown in below screenshot.

Step 2

  • It will again display some options.
  • Select the Excel Add-Ins options under Manage Box and click on Go button as shown in the below screenshot. (However, Excel Add-Ins is by default selected)

Step 3

  • It will open an Add-Ins dialog box.

Step 4

  • Tick on Analysis Toolpak checkbox and then click on OK as shown in below screenshot.

Step 5

  • These above steps will add the Data Analysis section for statistical analysis under the DATA tab.

Step 6

How to Use Exponential Smoothing in Excel?

Exponential Smoothing in Excel is very simple and easy to use. Let’s understand the working of forecasting Exponential Smoothing in Excel with some examples.

You can download this Exponential Smoothing Excel Template here – Exponential Smoothing Excel Template

Exponential Smoothing Forecasting – Example #1

Below we have given month wise price list.

Exponential Smoothing Example 1-1

We have assigned the number to the month period. For Exponential Smoothing to this time series data, follow the below steps:

  • Go to the Data tab. Click on Data Analysis option under Analysis section as shown in the below screenshot.

Exponential Smoothing Example 1-2

  • It will open a dialog box Data Analysis options.
  • Click on Exponential Smoothing option from the list of options and then click on OK as shown below.

Exponential Smoothing Example 1-3

  • A dialog box appears for Exponential Smoothing method.

Exponential Smoothing Example 1-4

  • Under Input Range box select the Price values range from C4:C15.

Exponential Smoothing Example 1-5

  • In Damping Factor box enter the value 0.9. This 0.9 is called damping factor which is equal to the 1- α. Here α (alpha) is the smoothing factor.

Exponential Smoothing Example 1-6

  • Under Output Range box, select the cell where you want to see the result. Refer below screenshot.

Exponential Smoothing Example 1-7

  • Tick on Chart Output box for displaying the values in the chart and then Click on OK.

Exponential Smoothing Example 1-8

  • It will insert the damping values in the E column with Exponential Smoothing chart as shown in below screenshot.

Exponential Smoothing Example 1-9

Explanation:

  • Here α=0.1, the previous data point is given a relatively small weight whereas the previous smoothed value is given a large weight (0.9).
  • The above graph is showing an increasing trend in the data points.
  • The graph doesn’t calculate the smoothed value for the first data point because there is no data point before that.

Exponential Smoothing Forecasting – Example #2

Let’s consider α=0.2 for the above-given data values so enter the value 0.8 in Damping Factor box and again repeat the Exponential Smoothing method.

Exponential Smoothing Example 2-1

The result is shown below:

Exponential Smoothing Example 2-2

Exponential Smoothing Forecasting – Example #3

Let’s consider α=0.8 for the above-given data values so enter the value 0.2 in Damping Factor box and again repeat the Exponential Smoothing method.

Popular Course in this category
Cyber Week Sale
Excel Advanced Training (14 Courses, 21+ Projects) 14 Online Courses | 21 Hands-on Projects | 129+ Hours | Verifiable Certificate of Completion | Lifetime Access
4.8 (2,603 ratings)
Course Price

View Course

Related Courses
Excel Training (18 Courses, 9+ Projects)

Exponential Smoothing Example 3-1

The result is shown below:

Exponential Smoothing Example 3-2

Now if we compare the results of all the above 3 Excel Exponential Smoothing examples, then we can come up with below conclusion:

  • The Alpha α value is smaller, the damping factor is higher. Resultant the more the peaks and valleys are smoothed out.
  • The Alpha α value is higher, the damping factor is smaller. Resultant the smoothed values are closer to the actual data points.

Things to Remember

  • The more value of dumping factor smooths out the peak and valleys in the dataset.
  • Excel Exponential Smoothing is a very flexible method to use and easy in the calculation.

Recommended Articles

This has been a guide to Exponential Smoothing in Excel. Here we discuss how to use an Exponential Smoothing in Excel along with excel examples and downloadable excel template. You may also look at these useful charts in excel –

  1. Step by Step Guide to Histogram Chart Excel
  2. Two Methods to build Excel Dynamic Chart
  3. How to use T.Test Function in Excel
  4. Tips to create Excel Area Chart

All in One Excel VBA Bundle (120+ Courses, 30+ Projects)

120+ Online Courses

30+ Projects

500+ Hours

Verifiable Certificates

Lifetime Access

Learn More

1 Shares
Share
Tweet
Share
Reader Interactions
Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Primary Sidebar
Excel Functions Tutorials
  • Excel Tools
    • Power Query in Excel
    • Power View in Excel
    • XML in Excel
    • Excel Evaluate Formula
    • Examples of Excel Macros
    • Consolidation in Excel
    • Ribbon in Excel
    • Excel Conditional Formatting for Dates
    • Protect Sheet in Excel
    • Data Model in Excel
    • Pivot Table Examples
    • Pivot Table Slicer
    • Pivot Table Filter
    • Watch Window in Excel
    • Slicer in Excel
    • Print Gridlines in Excel
    • Convert Numbers to Text in Excel
    • Freeze Columns in Excel
    • Spelling Check in Excel
    • Name Box in Excel
    • Solve Equation in Excel
    • Excel Spreadsheet Examples
    • What If Analysis in Excel
    • How to Print Labels From Excel
    • Excel Named Range
    • Excel TRANSPOSE Formula
    • Excel Merge and Center
    • Excel Freeze Rows
    • HLOOKUP Formula in Excel
    • Excel Create Database
    • Excel Gridlines
    • Excel Spreadsheet Formulas
    • Excel Sort By Number
    • Excel Concatenating Columns
    • Excel AutoCorrect
    • Conditional Formatting For Blank Cells
    • Excel Icon Sets
    • Excel CTRL D
    • Excel Accounting Number Format
    • Excel Regression Analysis
    • Excel Import Data
    • Excel Freeze Panes
    • Excel Calendar
    • Excel Developer Tab
    • Excel Enable Macros
    • Excel Autosave
    • Heat Map in Excel
    • Excel Toolbar
    • Excel Error Bar
    • Excel Status Bar
    • Excel Unprotect Sheet
    • Check mark in Excel
    • Excel Column Filter
    • Excel Header and Footer
    • Excel Drawing
    • Range in Excel
    • Timeline in Excel
    • Excel Lock Formula
    • Excel Table styles
    • Insert New Worksheet in Excel
    • Excel Column Lock
    • Excel Forms for Data Entry
    • QUOTIENT in Excel
    • Excel Sorting
    • Excel Sort by color
    • Excel Data Bars
    • Excel Tool for Data Analysis
    • Excel Flash Fill
    • Excel Auto Fill
    • Excel Quick Access Toolbar
    • Excel Wrap Text
    • Excel Exponential Smoothing
    • Excel ANOVA
    • Excel Merge Two Tables
    • Excel Conditional Formatting in Pivot Table
    • Dynamic Tables in Excel
    • Excel Sort by date
    • Excel Dynamic Range
    • Record Macro in Excel
    • Two Variable Data Table in Excel
    • Merge Cells in Excel
    • One Variable Data Table in Excel
    • Excel Fill Handle
    • CheckBox in Excel
    • Excel Table
    • Excel Combo Box
    • Auto Format in Excel
    • Advanced Filter in Excel
    • Excel AutoFilter
    • Excel Data Filter
    • Excel Data Validation
    • Excel Radio Button
    • Data Table in Excel
    • Text to Columns in Excel
    • Excel List box
    • Excel Solver Tool
    • Scrollbar in Excel
  • Excel Functions (10+)
  • Financial Functions in Excel (17+)
  • Logical Functions in Excel (12+)
  • Lookup Reference Functions in Excel (30+)
  • Maths Function in Excel (39+)
  • TEXT and String Functions in Excel (25+)
  • Date and Time Function in Excel (20+)
  • Statistical Functions in Excel (55+)
  • Information Functions in Excel (4+)
  • Excel Charts (44+)
  • Excel Tips (195+)
  • VBA (180+)
  • Workplace Productivity (4+)
  • Microsoft Office Tools (14+)
  • Excel Formula and Functions (20+)
  • MS Excel Shortcuts (4+)
Excel Functions Courses
  • EXCEL ADVANCED Training
  • EXCEL Training COURSE
Footer
About Us
  • Who is EDUCBA?
  • Sign Up
  •  
Free Courses
  • Free Online Excel Course
  • Free Vba Course
Certification Courses
  • All Courses
  • Excel VBA Course - All in One Bundle
  • VBA Course
  • Excel Data Analysis Course
  • Excel for Marketing Course
  • Excel for Finance Course
  • Excel for HR Training
Resources
  • Resources (A To Z)
  • Excel Charts
  • Excel Tips
  • Excel Tools in Excel
  • Excel Functions
  • Financial Functions in Excel
  • Logical Functions in Excel
  • Lookup Reference Functions in Excel
  • Maths Function in Excel
  • TEXT and String Functions in Excel
  • Date and Time Function in Excel
  • Statistical Functions in Excel
  • Information Functions in Excel
Apps
  • iPhone & iPad
  • Android
Support
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions

© 2019 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA

Download Exponential Smoothing Excel Template

By continuing above step, you agree to our Terms of Use and Privacy Policy.
EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA Login

Forgot Password?

Let’s Get Started
Please provide your Email ID
Email ID is incorrect

Cyber Week Offer - All in One Excel VBA Bundle (120+ Courses, 500+ hours of Videos) View More

Cyber Week Offer - Cyber Week Offer - All in One Excel VBA Bundle (120+ Courses, 500+ hours of Videos) View More