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ˉ).
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.