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?

hi everybody....me also newbie on this forum. Myself 'Steve Clark'. I come from Bellevue city in Newyork...am here to gathered a informative experience, hope i'll be able to do it.....well thanks to admin for allowed me here.