Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
average and stdev from groups of data | Excel Worksheet Functions | |||
StDev Results | Excel Discussion (Misc queries) | |||
AVERAGE and STDEV functions with logic | Excel Worksheet Functions | |||
STDEV...HELP | New Users to Excel | |||
GET NON-ZERO RESULTS USING STDEV FOR CERTAIN NUMBERS | Excel Worksheet Functions |