How do I calculate statistics on a row-by-row basis?
Use the matrix operator along with the statistics command and enter 0 for both the starting and ending row . For example, the formula c5 = mean([0:0, 1:4]) calculates the mean for each individual row in columns 1 through 4 and stores the results in column 5.
In version 4.0 and later, the formula c5 = mean(1:4) performs the same operation.