View Single Post
  #2   Report Post  
 
Posts: n/a
Default how to get the means and stdandard errors of every row in 5 coulum

"jt42" wrote:
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.