Forum Discussion
Calculating standard deviation
I wondering if there is a way to calculate the STD with data that if the value is 0 then its just not there. For example if the data set was 8,9,4, and 6 but there was a total number of 20 data point...
I'm not clear on which portion of your data is considered "other" and must not be included in the standard deviation calculation. I'll provide you with examples and I think you can run with it.
The numbers are in A1:A10
One Criteria:
=LET(rng,$A$1:$A$10,STDEV.S(IF(rng<>0,rng)))
Two Criteria (Acts as an AND):
=LET(rng,$A$1:$A$10,STDEV.S(IF(rng<>0,IF(rng<30,rng))))