Brian · YouTube · 3:04
This 150-second clip introduces single-parameter exponential smoothing through an Excel sales-forecast example. The presenter states the goal of forecasting Week 11 from Weeks 1 through 10, displays the recurrence +alpha(), identifies alpha as the smoothing constant with value 0.2, initializes Week 1 by setting , and then enters the Week 2 formula =C4+. The chart legend distinguishes blue actual sales from red forecasts. The clip explains how the recursion will continue downward, but it ends before the numerical Week 11 forecast is produced. This video provides a brief, practical demonstration of the exponential smoothing forecasting method using Microsoft Excel. It displays the core mathematical formula, + alpha * (), alongside its direct translation into an Excel spreadsheet formula. The presenter shows how to use Excel's auto-fill feature to apply the formula across a dataset of weekly unit sales, instantly generating a smoothed forecast line on a chart that contrasts with the more erratic actual sales data.
Use the learning inspector for key ideas and moments, or open the reading tabs for the complete notes.
Generated from the video's visuals and explanation; not verbatim speech.
The clip opens on an Excel worksheet built around a sales-forecasting example. A table lists Week 1 through Week 11, with actual unit sales filled for Weeks 1 through 10 and an empty Forecast column to be completed. The presenter states the objective: use exponential smoothing to estimate the Week 11 forecast from the earlier weekly sales data.
The central formula is shown on the sheet as . In words, the forecast for the current period equals the previous forecast plus a correction term. That correction is the smoothing constant multiplied by the previous period's forecast error, namely actual minus forecast from the prior week.
The presenter identifies as the exponential smoothing constant and notes that it is usually supplied in the problem. In this example the worksheet sets in the cell labeled Smoothing Constant. This fixed number controls how strongly the new forecast responds to the most recent forecast error.
After acknowledging that the symbolic formula can look intimidating, the video shifts to a concrete worked example. The presenter also points out the chart below the table: the blue series represents Unit Sales, while the red series will represent Forecast values as they are entered, giving a visual comparison between observed sales and smoothed predictions.
The first computational step is initialization. Because the recurrence needs a previous forecast and Week 1 has none, the presenter uses the first actual value as the first forecast. Thus the Week 1 forecast is set to , and this value is entered directly into the Forecast column.
From Week 2 onward, the recursive formula is applied. The presenter begins typing the Excel formula for the Week 2 forecast, explaining that it should use the Week 1 forecast, the Week 1 actual, and the constant stored separately in the sheet.
The entered formula is =This formula needs review. Please report it using the page feedback control.\2*(B4-C4). Here C4 is the previous forecast , B4 is the previous actual , and This formula needs review. Please report it using the page feedback control.\2 is the absolute reference to the smoothing constant. Algebraically, this is exactly translated into spreadsheet notation.
The presenter emphasizes locking the alpha reference so that when the formula is dragged downward, the same smoothing constant is reused in every row. The relative references for the prior actual and prior forecast, however, shift down one row at a time, which is what makes the recurrence propagate through the table.
The clip closes by describing the next recursive step rather than completing the whole table. For Week 3, the formula will use the Week 2 forecast plus times the Week 2 forecast error. The overall Week 11 numerical forecast is therefore set up conceptually, but the actual final value is not reached within this excerpt.
The video displays the exponential smoothing formula: . In the accompanying Excel sheet, this is translated into the formula `=C4+` for cell C5. Here, C4 represents the previous forecast , `4` is the absolute reference to the smoothing constant (set to 0.2), and B4 is the previous actual sales .
The user double-clicks the fill handle of cell C5. This action auto-fills the formula down column C for all subsequent weeks. As the formulas calculate, a red 'Forecast' line dynamically appears and extends across the line chart.
The resulting chart visually compares the blue 'Unit Sales' line, which shows significant week-to-week volatility, with the red 'Forecast' line. The exponential smoothing method has effectively dampened the erratic fluctuations of the actual data, producing a smoother, more stable trend line suitable for forecasting.
The video defines the one-step forecast update as the previous forecast plus a fraction of the previous forecast error. On screen the formula is , where is the current forecast, is the previous actual, and is the smoothing constant.
Alpha is presented as the exponential smoothing constant, typically given in the problem. In this example it is fixed at 0.2 and stored in a dedicated worksheet cell so the same value can be reused across all forecast rows.
Because the recurrence needs a prior forecast, the first period must be seeded separately. The presenter sets the Week 1 forecast equal to the Week 1 actual, giving before any recursive updating begins.
For Week 2, the mathematical formula is translated into the spreadsheet expression =This formula needs review. Please report it using the page feedback control.\2*(B4-C4). Cell C4 supplies the previous forecast, B4 supplies the previous actual, and This formula needs review. Please report it using the page feedback control.\2 locks the smoothing constant so it remains unchanged when the formula is copied downward.
The accompanying line chart distinguishes observed sales from model output by color. The blue line is Unit Sales and the red line is Forecast, so the visual effect of exponential smoothing can be seen as forecasts are added week by week.
The stated goal is to obtain the Week 11 forecast from Weeks 1 through 10, but this excerpt only completes the initialization and the Week 2 formula entry. It explains how later rows will continue recursively, without showing the final Week 11 number.
The forecast for the next period is the previous forecast plus a fraction of the previous period's error. The formula is , where is the smoothing constant.
In Excel, the formula is entered as `=C4+`. Relative references (C4, B4) point to the previous forecast and actuals, while the absolute reference (4) keeps the smoothing constant fixed when the formula is copied down.
Applying the exponential smoothing formula across a dataset generates a forecast line that is significantly smoother than the actual data line. This visually demonstrates how the method filters out short-term noise to reveal underlying trends.
Explore conditions, steps and evidence. Supplementary explanations are labeled separately from content shown in the video.
The worksheet shows the general formula + alpha * ().
The speaker explains as the forecast for the time you are looking for and as the forecast from the previous period.
Forecast value at time t, here the forecast for a given week.
Discrete time index t corresponding to weeks in the example; numeric forecast values.
The displayed formula contains .
The speaker refers to the actual from the previous week when explaining the term multiplied by alpha.
Actual observed value at the previous time point, here last week's unit sales.
Discrete time index t-1; numeric actual sales values.
The displayed formula uses alpha as the multiplier.
Cell B2 is labeled Smoothing Constant and contains 0.2.
The speaker says alpha is the exponential smoothing constant and that in this case it will be 0.2.
alpha
Exponential smoothing constant controlling how much the forecast adjusts toward the previous forecast error.
In this example alpha = 0.2, stored in cell B2.
The formula uses t and t-1 in , , and .
The speaker maps the time periods to weeks while walking through the example.
t
Current time index; in the example it denotes the week being forecast.
Integer week index, with the worked example covering Week 1 through Week 11.
The cursor selects cell C4 in the Forecast column for Week 1.
The speaker says that if there is no previous week, we simply use the actual from that week as our forecast.
C4
Excel cell containing the Week 1 forecast entry.
The user types a formula into cell C5 for Week 2.
The speaker says Week 2 is when we start using the formula.
C5
Excel cell where the recursive exponential smoothing formula is first entered for Week 2.
The typed Excel formula references B4 as the actual sales value for Week 1.
B4
Excel cell containing the Week 1 actual unit sales value.
The typed Excel formula references C4 as the previous forecast value.
C4
Excel cell containing the Week 1 forecast value used as the previous-period forecast in the Week 2 formula.
The formula bar shows 2 inside the Week 2 formula.
The speaker says alpha is a constant and they lock it in place so it stays consistent through the drag of the formula.
2
Absolute reference to the smoothing constant cell B2 in Excel.
The table shows Week 1 with Unit Sales 1103 and Forecast 1103.
The speaker says 1103 becomes our forecast for time one.
Week 1: ,
Initial condition for the worked example: the first forecast equals the first actual value.
The formula in cell C5 uses the absolute reference 4, which corresponds to the 'Smoothing Constant'.
Cell B4 contains the value 0.2 and is labeled 'Smoothing Constant'.
Smoothing constant, a parameter between 0 and 1 that determines the weight given to the most recent observation.
(0, 1)
The text overlay shows as the left-hand side of the equation.
The formula in cell C5 calculates the forecast for the current row.
Forecast for period t.
Real numbers
The worksheet displays + alpha * ().
The speaker verbally defines each part of the formula as previous forecast plus alpha times previous actual minus previous forecast.
The video presents the single-parameter exponential smoothing update rule. The new forecast equals the prior forecast plus a fraction alpha of the prior forecast error, where the error is measured as actual minus forecast from the previous period.
Used recursively over discrete time periods.
Requires a starting forecast value.
In the example, alpha is supplied as 0.2.
The speaker says that if we do not have a previous week to come up with a forecast, we just simply use the actual from that week as our forecast.
Cell C4 is filled with 1103, matching the Week 1 actual sales value in B4.
Because the recursive formula needs a previous forecast, the video demonstrates a simple initialization method: set the first forecast equal to the first actual observation. In the example this gives .
Applies when no earlier forecast is available.
Shown specifically for Week 1 in the example.
The speaker identifies alpha as the exponential smoothing constant and says it is typically given in the problem.
Cell B2 is labeled Smoothing Constant and contains 0.2.
Alpha is defined in the video as the exponential smoothing constant. It multiplies the previous forecast error and determines the size of the adjustment added to the previous forecast. In this worked example alpha is fixed at 0.2.
Treated as a given constant in the problem.
Held fixed across all periods in the example.
The user enters =C4+ into cell C5.
The speaker walks through the formula as previous forecast plus alpha times previous actual minus previous forecast and mentions locking alpha for dragging.
The video translates the mathematical recurrence into an Excel formula. For Week 2, the current forecast is computed from the Week 1 forecast in C4, the Week 1 actual in B4, and the smoothing constant in B2. The constant is made absolute with 2 so the same alpha is reused when the formula is copied downward.
Requires a table with actuals in one column and forecasts in another.
Uses relative references for prior row values and an absolute reference for alpha.
Text overlay displays the equation + alpha * ().
Excel formula bar shows =C4+.
The exponential smoothing forecast for the next period is calculated by taking the previous period's forecast and adding a fraction (determined by the smoothing constant alpha) of the error from the previous period (the difference between the actual value and the forecast).
Requires an initial forecast value.
Alpha must be between 0 and 1.
The formula in cell C5 is =C4+.
The user double-clicks the fill handle of cell C5, auto-filling the formula down column C.
In Excel, the formula is implemented using relative references for the previous forecast (C4) and actual sales (B4), and an absolute reference (4) for the smoothing constant. The formula can then be copied down the column to calculate forecasts for subsequent periods.
The smoothing constant must be stored in a fixed cell and referenced absolutely.
The displayed equation is + alpha * ().
The speaker states that the forecast for the time you are looking for equals the forecast from the previous period plus alpha times the actual from the previous week minus the forecast from the previous week.
For each period t, the forecast is updated by adding alpha times the previous period's forecast error to the previous forecast.
A previous forecast exists.
A previous actual exists.
A smoothing constant alpha is specified.
For the discrete time index t in the forecasting sequence.
The speaker says that without a previous week, the actual from that week is used as the forecast.
The Week 1 forecast cell is filled with 1103, identical to the Week 1 actual.
When no earlier forecast is available, the first forecast can be initialized as the first actual value, so in this example .
This is the first period in the data series.
No prior forecast is available.
Applied to Week 1 in the demonstrated dataset.
The general formula on screen is + alpha * ().
The Excel formula entered in C5 is =C4+.
The speaker explains that for Week 2 we use the forecast from Week 1 plus alpha times the actual from Week 1 minus the forecast from Week 1.
Start from the general exponential smoothing recurrence shown on the worksheet.
Directly observed formula in the video.
Specialize the recurrence to the second week, so the current forecast is Week 2 and the previous values are from Week 1.
Substitution into the displayed recurrence.
Use the smoothing constant provided in the example.
Observed in cell B2 and stated aloud by the speaker.
Translate the symbolic expression into Excel references: C4 is , B4 is , and 2 is alpha.
Observed formula entry in cell C5, with audio explanation of each referenced quantity.
The Week 2 forecast formula in Excel is the direct cell-reference implementation of the general exponential smoothing recurrence with alpha fixed by an absolute reference.
Text overlay: + alpha * ().
Excel formula: =C4+.
The current forecast being calculated corresponds to the active cell where the formula is entered.
Standard Excel formula entry.
The previous forecast corresponds to the cell directly above the current one in the Forecast column.
Relative referencing in Excel.
The smoothing constant is stored in cell B4. The dollar signs make it an absolute reference so it doesn't change when the formula is copied down.
Absolute referencing in Excel.
The previous actual sales correspond to the cell in the Unit Sales column on the same row as the previous forecast.
Relative referencing in Excel.
The Excel formula =C4+ is a direct translation of the mathematical formula .
The table lists Week 1 through Week 11 with Unit Sales and Forecast columns; Week 1 actual is 1103 and Week 2 actual is 1057.
The speaker says the example uses actual sales from week 1 to week 10 and asks for the week 11 forecast using exponential smoothing.
The user enters 1103 in the Week 1 forecast cell and then enters =C4+ in the Week 2 forecast cell.
The final Week 11 forecast value is not reached within this clip.
Some later weekly actual values are visible but not all are discussed in detail before the clip ends.
Given weekly unit sales for a mock company and a smoothing constant of 0.2, compute exponential smoothing forecasts recursively and ultimately determine the Week 11 forecast.
Weekly actual sales are listed for Week 1 through Week 10.
Smoothing Constant = 0.2 in cell B2.
Week 1 actual sales = 1103.
Week 2 actual sales = 1057.
The general formula shown is + alpha * ().
Set up the forecast sequence using exponential smoothing and prepare to extend it through Week 11.
Initialize the first forecast by copying the first actual because there is no previous week.
Stated verbally and shown by entering 1103 into the Week 1 forecast cell.
Apply the recurrence for Week 2 using Week 1 values.
Direct specialization of the displayed formula.
Enter the Week 2 forecast as an Excel formula referencing the Week 1 forecast, Week 1 actual, and the absolute alpha cell.
Observed formula entry in cell C5.
The speaker explains that dragging the formula down makes Week 3 use the Week 2 forecast and Week 2 actual.
Audio explanation near the end of the clip.
Within this clip, the setup is completed through the Week 2 formula and the recursion pattern for later weeks is explained; the numerical Week 11 forecast is not yet computed on screen.
The example can be checked by confirming that each new forecast uses the immediately preceding forecast and actual, with alpha held constant at 0.2 through the absolute reference 2.
The spreadsheet contains columns for Week, Unit Sales, and Forecast with numerical data.
The chart updates to show the forecast line after the formula is filled down.
Given historical weekly unit sales and a smoothing constant of 0.2, calculate the forecast for each subsequent week.
Initial forecast for Week 1 is 1103.
Smoothing constant .
Historical unit sales data for Weeks 1 through 10.
Compute the exponential smoothing forecast for Weeks 2 through 11.
Using the formula with Week 1 actuals and forecast.
Exponential smoothing formula.
Using the formula with Week 2 actuals and the newly calculated Week 2 forecast.
Exponential smoothing formula.
The user double-clicks the fill handle in Excel to apply the formula to all remaining rows automatically.
Excel functionality.
The forecast values for Weeks 2 through 11 are calculated and displayed in column C, and plotted as a red line on the chart.
The resulting forecast line on the chart visually smooths out the erratic fluctuations of the actual sales data (blue line).
An Excel worksheet titled around exponential smoothing is visible with a data table, a formula line, and a chart.
The speaker introduces the exponential smoothing forecast method using a mock company example.
Data table with Week, Unit Sales, and Forecast columns.
Formula text + alpha * ().
Line chart titled Exponential Smoothing Forecast Method (example).
Cursor highlight circle.
The cursor moves among the title area, table, and formula region.
The speaker frames the problem as forecasting Week 11 from Weeks 1 through 10.
The worksheet remains on the same example throughout the clip.
The smoothing constant shown is 0.2.
The visual layout establishes the three components needed for the lesson: historical data, the recurrence formula, and a chart for comparing actuals with forecasts.
The chart legend labels Unit Sales in blue and Forecast in red.
The speaker says that as forecasts are added, they will populate in red on the graph.
Blue line for Unit Sales.
Red line for Forecast.
Chart legend at the bottom.
The explanation links future formula entries in the Forecast column to the red chart series.
Unit Sales remain the blue series.
Forecast remains the red series.
The color coding visually separates observed sales from model-generated forecasts so the smoothing effect can be compared directly on the same axes.
Cell C4 is selected and filled with 1103.
The speaker says that with no previous week, the actual from that week is used as the forecast.
Week 1 row.
Cell C4 in the Forecast column.
Value 1103.
The previously empty Week 1 forecast cell becomes 1103.
Week 1 actual remains 1103.
The smoothing constant remains 0.2.
This step supplies the seed value required before the recursive formula can begin at Week 2.
The user types =C4+ into cell C5.
The speaker narrates the formula as previous forecast plus alpha times previous actual minus previous forecast and notes locking alpha for dragging.
Cell C5.
Formula bar.
References C4, 2, and B4.
The Week 2 forecast cell changes from empty to an entered formula.
The alpha reference is made absolute as 2.
The underlying recurrence remains +alpha().
The Week 1 seed value remains 1103.
The screen recording demonstrates how the abstract recurrence is mapped to spreadsheet cell references, with relative references moving down rows and the constant pinned in place.
The user double-clicks the bottom-right corner of cell C5, causing the formula to fill down column C.
Simultaneously, a red line representing the 'Forecast' appears and extends across the chart.
Excel spreadsheet
Line chart
Blue line (Unit Sales)
Red line (Forecast)
Column C is populated with forecast values from row 5 to row 15.
A red line appears on the chart, plotting the forecast values against the weeks.
The blue line representing actual unit sales remains unchanged.
The smoothing constant in cell B4 remains 0.2.
This visual event demonstrates how applying the exponential smoothing formula to the entire dataset generates a smoothed trend line that contrasts with the volatile actual data.
The speaker says the formula looks very complicated and that going through an example should clear everything up.
Learners may assume the exponential smoothing formula is difficult once it is written symbolically.
The video addresses this by immediately moving from the symbolic formula to a concrete Excel example, showing that the recurrence is applied mechanically from one row to the next.
The speaker explicitly handles the case where there is no previous week by using the actual from that week as the forecast.
A learner might try to apply the recurrence at the first period even though does not exist yet.
The video shows a separate initialization step: set before using the recurrence from Week 2 onward.
The general formula is displayed above the table.
The Excel formula =C4+ is entered in the Forecast column.
The Excel entry is a direct application of the mathematical recurrence to spreadsheet cells.
Cell B2 contains the smoothing constant 0.2.
The recurrence multiplies the error term by alpha.
The recurrence cannot be evaluated numerically without first specifying the smoothing constant alpha.
The speaker initializes Week 1 before saying Week 2 is when the formula starts being used.
C4 is filled before C5 receives the recursive formula.
The recursive formula requires a previous forecast, so the initialization rule supplies the starting value needed to begin the recursion.
The chart legend distinguishes Unit Sales and Forecast.
The speaker says forecasts will populate in red on the graph as they are added.
The computed forecast column feeds the red chart series, allowing the recursive results to be compared visually with the blue actual-sales series.
Both the mathematical formula and the Excel formula are shown simultaneously.
The Excel implementation is a direct application of the mathematical exponential smoothing formula.
The formula + alpha * () is shown on screen.
The speaker explains each term in words.
The speaker says to use the actual from that week as the forecast when there is no previous week.
Cell C4 is filled with 1103.
The formula =C4+ is typed into cell C5.
The speaker explains locking alpha so it stays consistent when dragging the formula.
The speaker calls alpha the exponential smoothing constant.
Cell B2 is labeled Smoothing Constant and contains 0.2.
The speaker states the goal is to find the Week 11 forecast.
Only the Week 1 seed and Week 2 formula setup are completed before the clip ends.
The clip ends before the Week 11 numerical result is shown.
The chart legend labels Unit Sales and Forecast.
The speaker says forecasts will appear in red on the graph.
The video explicitly shows the Excel formula and the auto-fill action.
The mathematical formula is displayed as text on the screen.
Covered · Introduction to the exponential smoothing example, the weekly sales table, and the stated goal of forecasting Week 11.
Covered · The general recurrence is shown and each term is explained verbally.
Covered · The speaker transitions from the abstract formula to a worked example and explains that forecasts will appear in red on the chart.
Covered · Week 1 is initialized by setting the forecast equal to the actual value 1103.
Covered · The Week 2 Excel formula is entered and the recursion pattern for later weeks is explained, but the clip ends before Week 11 is numerically computed.
Covered · The entire clip covers the explanation and demonstration of the exponential smoothing formula and its implementation in Excel.
Reviewed subject paths
Within this clip, the setup is completed through the Week 2 formula and the recursion pattern for later weeks is explained; the numerical Week 11 forecast is not yet computed on screen.
Conditions: The clip ends after demonstrating the Week 2 formula entry.; The goal stated at the beginning is to find the Week 11 forecast.
In Excel, the formula is implemented using relative references for the previous forecast (C4) and actual sales (B4), and an absolute reference (4) for the smoothing constant. The formula can then be copied down the column to calculate forecasts for subsequent periods.
Conditions: The smoothing constant must be stored in a fixed cell and referenced absolutely.; The data is arranged in columns for Week, Unit Sales, and Forecast.
Because the recursive formula needs a previous forecast, the video demonstrates a simple initialization method: set the first forecast equal to the first actual observation. In the example this gives .
Conditions: Applies when no earlier forecast is available.; Shown specifically for Week 1 in the example.
Alpha is defined in the video as the exponential smoothing constant. It multiplies the previous forecast error and determines the size of the adjustment added to the previous forecast.
Conditions: Treated as a given constant in the problem.; Held fixed across all periods in the example.
The exponential smoothing forecast for the next period is calculated by taking the previous period's forecast and adding a fraction (determined by the smoothing constant alpha) of the error from the previous period (the difference between the actual value and the forecast).
Conditions: Requires an initial forecast value.; Alpha must be between 0 and 1.
The chart legend distinguishes observed sales from model-generated forecasts by color. The blue line is Unit Sales and the red line is Forecast, so the visual effect of exponential smoothing can be seen as forecasts are added week by week.
Conditions: The chart is linked to the Excel table containing both actual and forecast columns.; Colors are assigned consistently in the legend.
The video presents the single-parameter exponential smoothing update rule. The new forecast equals the prior forecast plus a fraction alpha of the prior forecast error, where the error is measured as actual minus forecast from the previous period.
Conditions: Used recursively over discrete time periods.; Requires a starting forecast value.; In the example, alpha is supplied as 0.2.
The video translates the mathematical recurrence into an Excel formula. For Week 2, the current forecast is computed from the Week 1 forecast in C4, the Week 1 actual in B4, and the smoothing constant in B2.
Conditions: Requires a table with actuals in one column and forecasts in another.; Uses relative references for prior row values and an absolute reference for alpha.
Continue with related videos in the same subject.
YouTube10:40
YouTube8:20
YouTube6:05