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?How to get Excel to tell you certain information?If column A is the Male/Female (1 or 2) column...
Average of column B of males only
=SUMIF(A:A,1,B:B)/COUNTIF(A:A,1)
*Median of B1:B2166 of males only
(Array Formula)
=MEDIAN(IF(A1:A2166=1,B1:B2166))
*Standard Deviation of B1:B2166 of Males
(Array Formula)
=STDEV(IF(A1:A2166=1,B1:B2166))
*Formulas designated with an asterisk are array formulas. You have to enter array formulas with Ctrl+Shift+Enter. When you do, Excel will automatically put {braces} around the formula. You can't type in the braces. You have to use the Ctrl+Shift+Enter method.How to get Excel to tell you certain information?use the AVERAGEIF function, there you could select a specific criteria (male or female) on which data will be included in the Average function.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment