how to get the means and stdandard errors of every row in 5 coulum
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 |
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. |
All times are GMT +1. The time now is 12:09 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com