MODE, MEDIAN and RANGE help

G

Guest

I need to find the MODE, MEDIAN and RANGE for the age of a person based on
their gener. I have a column (J) that denotes the gender (male=1, female=2)
and column L gives that persons age. I'm thinking that:
Find the MODE of L2:L250 if L2:L250 =1 (for males) or =2 (females)

I'm new at this and would appreciate ANY help! Thanks!
 
J

Jerry W. Lewis

=MODE(IF(L2:L250=1,L2:L250))
=MEDIAN(IF(L2:L250=1,L2:L250))
=MAX(IF(L2:L250=1,L2:L250))-MIN(IF(L2:L250=1,L2:L250))

All must be array entered (Ctrl-Shift-Enter)

Jerry
 
G

Guest

Thank you for your help!
Greg

Jerry W. Lewis said:
=MODE(IF(L2:L250=1,L2:L250))
=MEDIAN(IF(L2:L250=1,L2:L250))
=MAX(IF(L2:L250=1,L2:L250))-MIN(IF(L2:L250=1,L2:L250))

All must be array entered (Ctrl-Shift-Enter)

Jerry
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

If, then 1
Finding Median if a value = 1.. help! 2
code to copy range 1
Median array formula 1
counting two ranges for one criteria 1
Calculating the Median for specified groups 1
using match, lookup, index 2
MIN and MAX across columns 6

Top