Jump to content
groovyPost Forums

How to get Excel to tell you certain information?


Guest Steveclark

Recommended Posts

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?

Link to comment
Share on other sites

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

Archived

This topic is now archived and is closed to further replies.

  • Who's Online   0 Members, 0 Anonymous, 2 Guests (See full list)

    • There are no registered users currently online
×
×
  • Create New...