|
|
|
| "be consistent" | |
| PerlMonks |
Re: standard deviation accuracy questionby tlm (Prior) |
| on Jul 22, 2005 at 12:07 UTC ( [id://477274]=note: print w/replies, xml ) | Need Help?? |
This is an archived low-energy page for bots and other anonmyous visitors. Please sign up if you are a human and want to interact.
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
|
|
||||||||||||||||||||||||