I tried a set of 104,857,600 values in Excel 2010 for Windows and the standard deviations diverge at the 9th decimal:
Count 1: 104,857,600Count 2: 104,857,600
Sum 1: 5,242,888,545Sum 2: 104,862,842,888,545
Average 1: 50.00008149Average 2: 1,000,050.00008149
Stdev.p 1: 29.15276094096330000Stdev.p 2: 29.15276094160490000
Current theme: default
Less Wrong (text)
Less Wrong (link)
I tried a set of 104,857,600 values in Excel 2010 for Windows and the standard deviations diverge at the 9th decimal:
Count 1: 104,857,600
Count 2: 104,857,600
Sum 1: 5,242,888,545
Sum 2: 104,862,842,888,545
Average 1: 50.00008149
Average 2: 1,000,050.00008149
Stdev.p 1: 29.15276094096330000
Stdev.p 2: 29.15276094160490000