Example 13.1 Forecasting Monthly Stereo Sales

1. Example 13.1Forecasting Monthly Stereo Sales Testing for Randomness

2. Objective To use StatPro’s runs test procedure to check whether the residuals from this simple forecasting model represent random noise.

3. STEREO.XLS • Monthly sales for a chain of stereo retailers are listed in this file. They cover the period from the beginning of 1998 to then end of 2001, during which there was no upward or downward trend in sales and no clear seasonal peaks or valleys. • This behavior is apparent in the time series plot of sales shown on the next slide. • Therefore, a simple forecast model of sales is to use the average of the series, 182.67 , as a forecast of sales for each month. • Do the resulting residuals represent random noise?

4. Time Series Plot of Stereo Sales

5. Runs Tests • A runs test is one of the formal methods of testing for randomness. • The runs test is a formal test of the null hypothesis of randomness. • If there are too many or too few runs in this series, then we conclude that the series is not random. • We first choose a base value, then we define a run as a consecutive series of observations that remain on one side of this base level.

6. Solution • To obtain the residuals for this forecasting model, we subtract a constant, 182.67, from each observation. • Therefore, the plot of the residuals, shown on the next slide, has exactly the same shapes as the plot of sales. • The only difference is that it is shifted down by 182.67 and has mean 0. • We now use the runs test to check whether there are too many or too few runs around the base value of 0 in this residual plot.

7. Plot of Residuals

8. Solution -- continued • To do so, we use the StaPro/Statistical Inference/Runs Test for Randomness menu item, choose Residual as the variable to analyze, and choose “mean of the series” as the cutoff value. • This produces the output in columns F through K of runs test results shown here.

9. Solution -- continued • StatPro inserts columns F and G to count the runs. • You can check the formulas in these columns, but basically, a 1 in column G indicates the beginning of a new run. • Column J and K then report the results of the runs test. • The important points are as follows.

10. Solution -- continued • The number of observed runs is 20, in cell K8. • The number of runs expected under an assumption of randomness is 24.833, in cell K10. Therefore, the series of residuals has too few runs. Positive values tend to follow positive values, and negative values tend to follow negative values. • The z-value in cell K12, -1.42, indicates how many standard errors the observed number of runs is below the expected number of runs. The corresponding p-value indicates how extreme this z-value is.

11. Solution -- continued • It should be interpreted just like other p-values for hypothesis tests. • If it is small, say, less than 0.05, then we can reject the null hypothesis of randomness and conclude that the series of residuals is not random noise. • However, the p-value for this example is only 0.155. Therefore, there is not convincing evidence of non-randomness in the residuals, and we can conclude that the residuals represent noise.