how to get the means and stdandard errors of every row in 5 coulum

[jt42]

Hi, can you tell me how to get statistics on five different colums of numbers:
specifically, how to get means and st. errors of every row in five columns.
Thanks, Joanna

 

[joeu2004]

Hi, can you tell me how to get statistics on five different
colums of numbers: specifically, how to get means and
st. errors of every row in five columns.

I assume you mean "of each row".

The formula =AVERAGE(A1:E1) provides the average of row 1.

The formula =STDEV(A1:E1) provides the standard deviation.

The standard error is =STDEV(A1:E1)/SQRT(COUNT(A1:E1)) .

Use STDEVP() if your numbers represent the entire population.