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
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
"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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks