Thread: STDEV
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Biff
 
Posts: n/a
Default STDEV

Hi!

The most probable explanation is that the values are calculated and only
appear to be the same. The true underlying values are different. You can
check by selecting the cells and changing the format to number and
increasing the decimal place.

Biff

"Kimo" wrote in message
...
For some numbers (e.g. 1.35, 2.8, 11.73) the standard deviation of the
three
same numbers do not result to 0. Why? I tried it on four different
computers.