go ahead... be a heretic | |
PerlMonks |
Re: standard deviation accuracy questionby tlm (Prior) |
on Jul 22, 2005 at 16:07 UTC ( [id://477274]=note: print w/replies, xml ) | Need Help?? |
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
In Section
Seekers of Perl Wisdom
|
|