groovyPost.com

[Steveclark]

I have information from 2,166 people. There is a sex column with either a 1 (male) or 2 (female) for each one. There is other information like age, BMI, etc. I need to find the average, median, and standard deviation of all the males and all the females separately. How do I get excel to give me the mean of all the ages for just males when males and females are included on the spreadsheet?

[alexmvp]

So....

I'm not an excel expert however, this is what I would do:

Let's assume Male or Female is in B2:B6 and BMI values is in C2:C6

Your formula would be:

Male:
=MEDIAN(IF(B2:B6="Male",C2:C6))

Female:
=MEDIAN(IF(B2:B6="Female",C2:C6))

Remember however, after you enter in the formula since this is a CSE formula you need to enter it then press Control+Shift+Enter instead of just hitting the enter key to save the formula.

It worked for me. Have fun!

[Steve]

CTRL+Shift+Enter - Now that's a new one for me!