There are two main possibilities to calculate rolling mean:
1. The Smoothing analysis
Add “Moving average” as a calculation and set the length.
You can use the formula:
- This will calculate a one year rolling mean for the S&P 500.