Over at DjPj, pjs64 has a nice tutorial on using some of the spreadsheet properties of an Org tables. It’s one of the most powerful aspects of Org tables and I use it all the time. The trouble is, it can be a little difficult to figure out how to enter formulas so pjs64’s tutorial is really handy.
The tutorial considers only the mean function but there are, of course, many others. The problem is not the functions but their syntax and the tutorial covers that very well. One handy shortcut that pjs64 mentions is typing Ctrl+c ? in any field to see what its reference is. The usual Org notation is @row$col but you can also use the traditional spreadsheet notation where the columns are labeled A B C ... and the rows are numbered 1–\(n\) so that @3$2 is also B3.
The tutorial goes on to explain the difference between row and field formulas and how to specify them. It also explains the various ways of editing those formulas once they’ve been entered. Finally, there’s a short section on how to use Emacs Calc to to calculate the field values. To show how flexible this is, pjs64 makes the silly calculation of outputting the \(m^{\text{th}}\) digit of \(\pi\) based on the mean, \(m\), of the other columns.
It’s a useful tutorial and you should take a look if you use Org table even a little.