in reply to standard deviation accuracy question

The code you posted does not compute the sample standard deviation, which is what Excel is computing. You need to make the N – 1 correction. (I.e. before taking the square root, multiply everything by N/(N–1)).

Or you can use the code I posted in my other reply in this thread (though yours, with the correction, is probably more efficient).

the lowliest monk

  • Comment on Re: standard deviation accuracy question