emacs-orgmode
[Top][All Lists]
Advanced

[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



reply via email to

[Prev in Thread] Current Thread [Next in Thread]