3.86 FAQ-324 How can I calculate the moving median?

Last Update: 7/15/2018

Use the Set Value dialog to calculate a simple moving median on certain range (defined by the window size).

  1. Select the column or cells where you want to put the result.
  2. Select from menu Column: Set Column Value... to open the dialog (or press CTRL + Q from keyboard).
  3. In the opened dialog, fill median(B[i:i+50]) in the column formula text box to calculate moving median of column B, in which the moving window is from the current point to the 50th point forward.
  4. Click the OK button.

See this FAQ for more information.

Keywords:Moving median, Running median, Moving Statistics