standard deviation excluding values above 75th percentile and = to zero

[timbeckenham]

Hi there, I am looking for help on how to use excel to calculate the standard deviation on a dataset but want to exclude zreo and null values and those above the 75th percentile,

any ideas?

 

[Domenic]

Assuming that B2:B10 contains the data, try the following formula that needs to be confirmed with CONTROL+SHIFT+ENTER...

=STDEV(IF(B2:B10>0,IF(B2:B10<=PERCENTILE(B2:B10,0.75),B2:B10)))

Adjust the range accordingly.

Hope this helps!