Hello, 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.

Thanks,

Mike

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?

Ask Your Question

Weekly Poll

Do you think Google Fiber has a strong future?

Discuss in The Lounge

Poll History