Versions Compared

Old Version 1

changes.mady.by.user Snow Li

Saved on

compared with

New Version 2

changes.mady.by.user Snow Li

Saved on

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 datarow 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.