Re: Statistics in Org-Tables

[Nick Dokos <nicholas.dokos@hp.com>]

Rodolfo Aramayo <raramayo@gmail.com> wrote:

> Simple question: What is the best way to configure/find out how to
> calculate Median, Standard Deviation in an org-table?

There are calc functions to compute these things, but the layout of your
table will of course influence the formulas. Here's a simple example
that calculates the statistics for the second column - it uses the
@I..@II range reference notation to get the numbers between the first
and second separators and the @> (@>>, @>>>, etc.) notation to refer to
the last (last minus one, last minus two, etc.) row:

--8<---------------cut here---------------start------------->8---

* mean, median, stdev

|      i |         x |
|--------+-----------|
|      1 |         3 |
|      2 |         1 |
|      3 |         1 |
|      4 |         2 |
|      5 |         1 |
|      6 |         3 |
|      7 |         4 |
|      8 |         1 |
|      9 |         1 |
|--------+-----------|
|   mean | 1.8888889 |
| median |         1 |
|   sdev | 1.1666667 |
|    sum |        17 |
#+TBLFM: @>$2=vsum(@I..@II) :: @>>>>$2=vmean(@I..@II) :: @>>>$2=vmedian(@I..@II) :: @>>$2=vsdev(@I..@II)
--8<---------------cut here---------------end--------------->8---

More details about such references are in the Org manual:

(info "(org) References")

More details about the calc functions are in the Calc manual:

(info "(calc) Single-variable statistics")

Nick