To calculate the next forecast, you use the weighted average form of the exponential smoothing formula: Ft+1=αAt+(1−α)Ft. With a smoothing constant of α=0.2, the formula becomes Ft+1=0.2(At)+0.8(Ft).
Conditions: The smoothing constant is α=0.2.; You know the actual sales value for the current period (At).; You know the forecast value for the current period (Ft).
To calculate the next forecast, you use the weighted average form of the exponential smoothing formula: Ft+1=αAt+(1−α)Ft. With a smoothing constant of α=0.2, the formula becomes Ft+1=0.2(At)+0.8(Ft).
Conditions: The smoothing constant is α=0.2.; You know the actual sales value for the current period (At).; You know the forecast value for the current period (Ft).
The intercept b0 is calculated by substituting the mean point (xˉ,yˉ) and the known slope b1 into the regression equation y^=b0+b1x, and then solving algebraically for b0. In the example, substituting x=3, y^=4, and b1=0.6 yields 4=b0+0.6(3), which simplifies to b0=2.2.
Conditions: The slope b1 has already been computed.; The sample means xˉ and yˉ are known.; The regression line is assumed to pass through (xˉ,yˉ).
The intercept b0 is calculated by substituting the mean point (xˉ,yˉ) and the known slope b1 into the regression equation y^=b0+b1x, and then solving algebraically for b0. In the example, substituting x=3, y^=4, and b1=0.6 yields 4=b0+0.6(3), which simplifies to b0=2.2.
Conditions: The slope b1 has already been computed.; The sample means xˉ and yˉ are known.; The regression line is assumed to pass through (xˉ,yˉ).
If no forecast value for the first period is given, the standard assumption is to set the first forecast equal to the first actual value, expressed as F1=A1. This provides a starting point for the exponential smoothing calculations.
Conditions: No initial forecast value is provided for the first period.; You are beginning an exponential smoothing calculation.
If no forecast value for the first period is given, the standard assumption is to set the first forecast equal to the first actual value, expressed as F1=A1. This provides a starting point for the exponential smoothing calculations.
Conditions: No initial forecast value is provided for the first period.; You are beginning an exponential smoothing calculation.
To calculate the Mean Squared Error (MSE), you first find the forecast errors by subtracting the forecast from the actual sales for each period. Next, you square each of these errors.
Conditions: You have calculated the forecasts for each period.; You have the actual sales data for each period.; Errors are not calculated for the first period if F1=A1.
To calculate the Mean Squared Error (MSE), you first find the forecast errors by subtracting the forecast from the actual sales for each period. Next, you square each of these errors.
Conditions: You have calculated the forecasts for each period.; You have the actual sales data for each period.; Errors are not calculated for the first period if F1=A1.