Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculating averages for subgroups
I have a worksheet that shows the sex of the student (M or F) and their test
scores. How do I calculate the average for each subgroup rather than for the group as a whole? I've converted the original "sex" data to numeric, but am still stuck. Col. A Col. B Col. C M 1 65.2 M 1 77.5 F 2 83.4 F 2 59.7 M 1 59.6 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculating averages for subgroups
Hi,
Try these array formulas: =AVERAGE(IF((A1:A10="M"),D1:D10)) or =AVERAGE(IF((B1:B10=1),D1:D10)) enter using Ctrl+Shift+Enter HTH Jean-Guy M 1 65.2 M 1 77.5 F 2 83.4 F 2 59.7 M 1 59.6 M 1 65.2 M 1 77.5 F 2 83.4 F 2 59.7 M 1 59.6 M 1 65.2 M 1 77.5 F 2 83.4 F 2 59.7 M 1 59.6 M 1 65.2 M 1 77.5 F 2 83.4 F 2 59.7 M 1 59.6 "PSmith" wrote: I have a worksheet that shows the sex of the student (M or F) and their test scores. How do I calculate the average for each subgroup rather than for the group as a whole? I've converted the original "sex" data to numeric, but am still stuck. Col. A Col. B Col. C M 1 65.2 M 1 77.5 F 2 83.4 F 2 59.7 M 1 59.6 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating Percentiles for Subgroups | Excel Discussion (Misc queries) | |||
Calculating Block Averages | Excel Discussion (Misc queries) | |||
Calculating weighted averages | Excel Discussion (Misc queries) | |||
calculating averages | Excel Discussion (Misc queries) | |||
calculating averages | Excel Worksheet Functions |