*From*: "Andreas J. Guelzow" <aguelzow math concordia ab ca>*To*: gnumeric-list <gnumeric-list gnome org>*Cc*: G Milde physik tu-dresden de*Subject*: Re: Rounding??*Date*: Fri, 15 Jun 2001 09:59:41 -0600

Guenter Milde wrote:

Ok, we have to admit: "_never_ worse" is incorrect.StillThere is nothing better about `round towards even'.is also not true:

And as I said that statement was also compleely unsupported.

If you have a large sample of random numbers the relative frequency of the digits 0 - 9 will be the same. The rounding error for a number with r digits is|a - z| <= 0.5e-r, for r = 1 we havedigit round_up even_rule0 0 0 1 -1 -1 2 -2 -2 3 -3 -3 4 -4 -4 5 5 -5 or 5 (with half/half probability)6 4 47 3 38 2 2 9 1 1 If we round "the accountants way", the expectation (mean) value of the rounding error is 0.5, if we round_to_even, the expectation value of the rounding error is 0.

Andreas PS: perhaps we should continue this discussion in private --

Concordia University College of Alberta http://www.math.concordia.ab.ca/aguelzow

**Follow-Ups**:**Re: Rounding??***From:*Phillip J Shelton

**Re: Re: Rounding??***From:*Guenter Milde

**References**:**Re: Rounding??***From:*Nicholas Lee

**Re: Rounding??***From:*Nick Lamb

**Re: Rounding??***From:*Nicholas Lee

**Re: Rounding??***From:*Nick Lamb

**Re: Rounding??***From:*Nicholas Lee

**Re: Rounding??***From:*Andreas J. Guelzow

**Re: Rounding??***From:*Nicholas Lee

**Re: Rounding??***From:*Nicholas Lee

**Re: Rounding??***From:*Kjetil Torgrim Homme

**Re: Rounding??***From:*Nicholas Lee

**Re: Rounding??***From:*Kjetil Torgrim Homme

**Re: Rounding??***From:*Andreas J. Guelzow

[Date Prev][Date Next] [Thread Prev][Thread Next] [Thread Index] [Date Index] [Author Index]