Think in Columns!

Top  Previous  Next

The stat tool "thinks" in columns and you need to keep this in mind when using it.


Graphs show the information in whole columns.
Statistics are calculated on whole columns.
Formulas operate on the whole column at once.



It is perhaps the last point that is most different to a spreadsheet.  For example, moving into column B and typing


= Rank(A)


will place the rank of each datum in column A into column B.  It works on the whole column at once.  In a traditional spreadsheet you would need to copy this formula into each cell in the column.