Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 2 Next »

 (ORG-9044)

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

For example:

  1. Fill column A with row numbers.
  2. Enter StdDev(col(A)[i-5:i+5]) as the formula for column B. Then column B will be filled with the running-standard deviation over 11 points, at every row, based on the data in column A.
  • No labels