Dear Forum Members!
I have encountered an issue (system glitch?) when trying to calculate Standard Deviation for a set of measurements that have no variation.
Raw measurements:
Excel Office 365 calculation of Standard deviations (sample and population):0.71000000000000000000000
0.71000000000000000000000
0.71000000000000000000000
0.71000000000000000000000
0.71000000000000000000000
0.71000000000000000000000
0.71000000000000000000000
0.71000000000000000000000
0.71000000000000000000000
0.71000000000000000000000
0.71000000000000000000000
0.71000000000000000000000
0.71000000000000000000000
0.71000000000000000000000
0.71000000000000000000000
0.71000000000000000000000
0.71000000000000000000000
0.71000000000000000000000
0.71000000000000000000000
Can anyone please shed some light on this phenomenon? My expectation would be that Standard Deviation is 0 (zero).0.000000000000000333
0.000000000000000342
There is a practical problem I am facing because of the above observed situation.
Best Regards,
Krzysztof
Bookmarks