I'm looking for a code about STDEV.S fuction of MS Excel -


i'm looking code stdev.s fuction of ms excel. note function estimate standard deviation based on sample.

stdev.s 

equation calculate standard deviation of sample (from wikipedia):
enter image description here

so formula be:

=sqrt(1/(count(<range>)-1)*sumsq(<range>-average(<range>)))

note should entered array formula (press ctrl+shift+enter when finished instead of enter)


Comments