## Introduction

This article describes how to go from a crosstab with a time series variable...

...to a table with a *lagged* rolling average:

## Requirements

1. Select your table.

2. Go to **Properties**** > RULES** on the **object inspector**.

3. To apply the rule, select the **Plus (+) > Browse Online Library > Modify Whole Table or Plot > Replace with Rolling Averages**.

4. Set the **Number of periods to roll**.

5. OPTIONAL: Tick **Dates are in the rows** if applicable.

6. Press **OK**.

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.

## See Also

## Comments

0 comments

Article is closed for comments.