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?

Edited by Steveclark
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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Who's Online   0 Members, 0 Anonymous, 1 Guest (See full list)

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