[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
## [O] calculate frequencies in a table with calc

**From**: |
Martin Gross |

**Subject**: |
[O] calculate frequencies in a table with calc |

**Date**: |
Tue, 25 Dec 2012 13:59:13 +0100 |

Dear helpers,
on the web I found a formula to get frequencies which I modified to my
needs, but it does not yet work well. An example:
|---------------------|
| [1, 2, 3, 4, 5] |
| [6, 7, 8] |
| [9, 10, 11, 12, 12] |
| 12, 12 |
|---------------------|
| 15 |
| 2 |
#+TBLFM:
@5$1=vcount(@address@hidden)::@6$1=vcount(map(<if(eq(#1,12),1,[])>,@address@hidden))
With the first formula (@5$1) everything inside and outside the
brackets is counted, but with the second (@6$1), where I am asking for
the frequency of 12, only what is outside the brackets is considered.
How could I also include what is inside the brackets, so I get 4?
Thank you very much in advance!
Martin

**[O] calculate frequencies in a table with calc**,
*Martin Gross* **<=**