Guest Steveclark Posted April 21, 2010 Report Share Posted April 21, 2010 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? Link to comment Share on other sites More sharing options...
alexmvp Posted April 23, 2010 Report Share Posted April 23, 2010 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! Link to comment Share on other sites More sharing options...
Steve Posted April 26, 2010 Report Share Posted April 26, 2010 CTRL+Shift+Enter - Now that's a new one for me! Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.