Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Subrange notation such as [i-5:i+5] can be used to perform calculations over a range of cells.

Image Added

For example:

  1. Fill column A with some dataEnter StdDev(col(A)[i-5:i+5]) as the formula for column B. row numbers.
  2. Open Set Column Values dialog of col(B).
  3. Choose Formula: Load Sample: Moving Standard Deviations and click OK.

 

Then column B will be filled with the running-standard deviation over 11 points, at every row, based on the data in column A.