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):
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
Post a Comment