averagetable

Calculates averages and standard deviations of finite numbers in all numerical columns of a table and appends them as new rows. the table.

The table summary function yields minimum, maximum and median but not means and standard deviations. These can be calculated, but on a per row or column basis. This function examines all columns for numerical entries and averages all finite numbers (thus skipping Nan, +/-Inf entries).
Per default all numerical columns in the input table are averaged and the means, standard deviations (SD) and number of samples (N) are appended as three new rows to the output table. Non numerical columns are left as they are and the new rows get copies of the values in row1.
The optional row indices list input can be used to calculate only over specific rows. The SD and N rows can be omitted.
The new rows are labeled 'average', 'S.D.' and 'N'. If not previously named, all other rows will be named 'Row1, Row2,....RowN.