Standard Deviations using unique identifiers

May 4, 2009 at 10:01:13
Specs: Windows XP

I am trying to calculate the standard deviation of a list of numbers that are either "1" if a condition is met or "0" otherwise ("stdevIF"). I am also attempting to do the same thing for a median ("medianIF"). Any ideas would be appreciated.


See More: Standard Deviations using unique identifiers

Report •

May 4, 2009 at 10:17:34
I don't do much with standard deviations, so bear with me if this question doesn't make sense...

The way I read your post is that you've got a list of 1's and 0's created from a list of IF statements. Why can't you just use STDEV() on that range?

Report •
Related Solutions

Ask Question