How to get Excel to tell you certain information?

[Guest 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?

Edited April 22, 2010 by Steveclark

[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 Krause]

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