Guest Steveclark Posted April 21, 2010 Report Share Posted April 21, 2010 (edited) 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 Quote 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! Quote Link to comment Share on other sites More sharing options...
Steve Krause Posted April 26, 2010 Report Share Posted April 26, 2010 CTRL+Shift+Enter - Now that's a new one for me! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.