Using Statistics on Segmented Data

I have a large data set with people's age and weight. How would I get the standard deviation for every 5 year cohort (ie 0-4, 5-9, etc).

Is there any smart way of doing this?

Hi

Assuming that your data is in the range A2:B93 then
0-4: =STDEV(IF(A2:A93<=4,B2:B93,""))
5-9: =STDEV(IF((A2:A93>=5)*(A2:A93<=9),B2:B93,""))
10-14: =STDEV(IF((A2:A93>=10)*(A2:A93<=14),B2:B93,""))

Note that these formulas have to be array entered (ctrl, shift, enter).

HTH

rylo