ianmdrennan 2 #26 July 13, 2004 Greetings fellow geeks, Yep - I was trying to figure out why the scientists computations weren't always rounding as they expected a few years back. Bankers rounding got me right in the @ss! Blues, IanPerformance Designs Factory Team Quote Share this post Link to post Share on other sites
masher 1 #27 July 13, 2004 This news just in. I've yet to confirm its statistical significance, but... 100000 random numbers between 0 and 10, to one decimal place. ie 0.1, 4.6, 3.5, 7.9 10.0 etc.... Generate by the RAND() func in excel, and then truncated to one decimal place. truncated random number average - 4.953 Round to the nearest even number: average = 4.954 Round to the nearest odd number: average = 4.954 Round up: average = 5.003 Round down: average = 4.904 Looks like rounding up or down is dodgy.-- Arching is overrated - Marlies Quote Share this post Link to post Share on other sites
masher 1 #28 July 13, 2004 Please check my stats.... Random numbers average: 4.953.... variance: 8.305... n: 100000 nearest even number average: 4.954.... variance: 8.512... n: 100000 nearest odd number average: 4.954.... variance: 8.419... n: 100000 round up average: 5.003.... variance: 8.468... n: 100000 round down average: 4.904.... variance: 8.459... n: 100000 Using the two sample t test: Round to even -> t=0.028 round to odd -> t=0.040 round up -> t=3.851 round down -> t=3.784 This means that the difference in the averages of the round even/odd sets to the original random numbers is not significant. The difference in the averages of the round up/down sets to the original random numbers is significant at greater than 99.9% CI. I'm pretty sure that's how it works. . Flame away. Of course, you do realise that I'm only doing this to avoid doing my own work, which is already late.....-- Arching is overrated - Marlies Quote Share this post Link to post Share on other sites
Squeak 17 #29 July 13, 2004 QuotePlease check my stats.... NO Here my take in measuring and rounding UP If you round up and your wrong you can always shave a tad more off If ya round down and ya wrong, you're stoofedYou are not now, nor will you ever be, good enough to not die in this sport (Sparky) My Life ROCKS! How's yours doing? Quote Share this post Link to post Share on other sites
