Re: Bug in Delphi SimpleRoundTo function?



Trevor Toms wrote:

Ask any mathematician and you'll get the same answer: 0.5 rounds up.

That I doubt. This produces a biased rounding - round a lot of positive
values and add them, and the result will consistently be larger than
the sum of the original values.

Bankers rounding is statistically unbiased - round a lot of positive
values and add them, and the result will be very much the same as the
sum of the original values.

--
Anders Isaksson, Sweden
BlockCAD: http://web.telia.com/~u16122508/proglego.htm
Gallery: http://web.telia.com/~u16122508/gallery/index.htm
.



Relevant Pages

  • Re: Rounding Error Driving Me NUTS!
    ... I am familiar with the round the ... sum versus sum the round issue. ... The only difference between the reports that are consistent and the one that ... What leads you to say there's a rounding error? ...
    (microsoft.public.access.forms)
  • Re: Rounding in Thousands
    ... will round to the thousands, ... Microsoft MVP - Excel ... > The Total line is a simple sum formula. ... >>you could use round in each cell. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Change value to an integer on a form
    ... saying the user wanted to round down the sum versus sum the rounded down ... Access MVP 2002-2005, 2007 ... field on a report. ... All I want is to always change the number to an integer (round down). ...
    (microsoft.public.access.reports)
  • Re: A REAL LIVE Reverse Entropy Machine-Warning
    ... Nell's testing emerges under our sum after we tuck amid it. ... Sadam, have a sunny organiser. ... files now or Ali will faster distinguish them round you. ...
    (sci.crypt)
  • Re: Rounding actual results - not just display
    ... > Total learning time: =A1+A2... ... > invisible equation that works out the sum of all the minutes, in my case, ... > find to do is to round it up, which impacts on the rest of my equations. ...
    (microsoft.public.excel)