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?
Last edited by Steve
on Thu Apr 22, 2010 8:47 am, edited 1 time in total.
Reason: Backlink removed - Provided no value to post <spam>