Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hi,
I get some non-zero results when using Microsoft Excel 97 to caluclate Standard Deviation for the following numbers having the same set of numbers: 1) 4.8, 4.8, 4.8 = Stdev(4.8,4.8,4.8) = 8.43E-08 2) 0.71, 0.71, 0.71 =Stdev(0.71,0.71,0.71) =1.05E-08 3) 0.815, 0.815, 0.815 = dtdev(0.815,0.815,0.815) =1.05E-08 Theoretically, for same set of numbers, the Std deviation should be 0 but when using the Excel to compute Stdev, I discover this is not true for all the numbers (eg see above). Any solution to ensure that when using the Excel to compute Stdev for the set with all same numbers will always return a zero? Regards |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
Sorting when some numbers have a text suffix | Excel Discussion (Misc queries) | |||
Sorting imported "numbers" | Excel Discussion (Misc queries) | |||
Paste rows of numbers from Word into single Excel cell | Excel Discussion (Misc queries) | |||
finding common numbers in large lists | Excel Worksheet Functions |