The table below is a crosstab of a Date question (in the columns) by average satisfaction with various colas (a Number question):
This is what the table looks like after the values have been changed to rolling average:
Please note the following:
- A lagged rolling average is computed. For example, if January has a score of 3, February 4, and March 6, the 3-period rolling average for March is (3 + 4 + 6) / 3 = 4.33333333.
- Where values cannot be computed due to insufficient data, the value is shown as NaN. For example, if January has a score of 3, February 4, and March 6, the 3-period rolling average for the three months, respectively, are NaN, NaN, and 4.33333333.
- This rule is only applied to the first statistic selected in each of STATISTICS > Cells and whichever is appropriate of STATISTICS > Below and STATISTICS > Right.
- You may not have a NET in the variable containing the dates.