Page 1 of 2

Rounding: wording and algorithm

Posted: 23:33 Fri 28 Nov 2014
by jdaw1
Some posts moved from Apostrophe crimes.

> Each [thing] shall then be [maths in words], rounded to the nearest thousandth of a basis point (exact half thousandths of a basis point of yield being rounded up).

Should there be any hyphenation in the above, and if so, where? Can the parenthetical clause be both clearer and more concise?

Re: Apostrophe crimes

Posted: 01:03 Sat 29 Nov 2014
by djewesbury
1. No.
2. It's already clear and concise.

Re: Apostrophe crimes

Posted: 01:50 Sat 29 Nov 2014
by DRT
Should "half thousands" be "half thousandths"?

Re: Apostrophe crimes

Posted: 09:15 Sat 29 Nov 2014
by jdaw1
DRT wrote:Should "half thousands" be "half thousandths"?
Thank you. Yes, it should: fixed.

Re: Apostrophe crimes

Posted: 11:16 Sat 29 Nov 2014
by djewesbury
jdaw1 wrote:
DRT wrote:Should "half thousands" be "half thousandths"?
Thank you. Yes, it should: fixed.
Should it be two-thousandths?

Re: Apostrophe crimes

Posted: 11:20 Sat 29 Nov 2014
by DRT
How can a number that is exact be rounded up?

Do you mean "rounded up to the nearest two-thousandth of a basis point"?

Re: Apostrophe crimes

Posted: 11:24 Sat 29 Nov 2014
by djewesbury
The exact number 7 can be rounded up to 10.

Re: Apostrophe crimes

Posted: 11:28 Sat 29 Nov 2014
by PhilW
djewesbury wrote:
jdaw1 wrote:
DRT wrote:Should "half thousands" be "half thousandths"?
Thank you. Yes, it should: fixed.
Should it be two-thousandths?
Should probably be "exact half of a thousandth being rounded up"; two-thousandths would be confusing. basis-point might need hyphenation, I do now know.

Rounding: wording and algorithm

Posted: 11:32 Sat 29 Nov 2014
by DRT
djewesbury wrote:The exact number 7 can be rounded up to 10.
Stop chattering in class, Jewesbury, and pay attention.
PhilW wrote:
djewesbury wrote:
jdaw1 wrote:
DRT wrote:Should "half thousands" be "half thousandths"?
Thank you. Yes, it should: fixed.
Should it be two-thousandths?
Should probably be "exact half of a thousandth being rounded up"; two-thousandths would be confusing.
That's why I asked the question. Is JDAW rounding up to the nearest thousandth or the nearest half of a thousandth?

Re: Apostrophe crimes

Posted: 12:50 Sat 29 Nov 2014
by jdaw1
What I want is:
  • 50 → 50
    50.0004 → 50
    50.00049 → 50
    50.0005 → 50.001
    50.00051 → 50.001
    50.0006 → 50.001
    50.001 → 50.001
Please suggest concise and unambiguous phrasing that achieves this.

† Assume that ambiguity is being sought by evil lawyer-mathematician types. So “unambiguous” means “really utterly unambiguous”. And don’t assume that all numbers are positive.

Re: Apostrophe crimes

Posted: 13:23 Sat 29 Nov 2014
by DRT
"rounded to the nearest thousandth of a basis point" does it for me. If you need more precision then perhaps "rounded to the nearest thousandth of a basis point (where greater than or equal to n.nnn5 shall be rounded up and less than n.nnn5 shall be rounded down).

Re: Apostrophe crimes

Posted: 13:56 Sat 29 Nov 2014
by jdaw1
DRT wrote:If you need more precision
jdaw1 wrote:evil lawyer-mathematician types
That is a yes, I do need more “precision”.
DRT wrote:"rounded to the nearest thousandth of a basis point (where greater than or equal to n.nnn5 shall be rounded up and less than n.nnn5 shall be rounded down).
Is that really clearer than my earlier suggestion (because it is longer, and the repeated n’s introduce an ambiguity)?
jdaw1 (after correcting a typo) wrote:rounded to the nearest thousandth of a basis point (exact half thousandths of a basis point of yield being rounded up).

Re: Apostrophe crimes

Posted: 13:58 Sat 29 Nov 2014
by djewesbury
This is the wrong place for this discussion and you have already crowded out a true-bill spelling mistake, by Derek, whose mistakes are always most fun.

Re: Apostrophe crimes

Posted: 14:14 Sat 29 Nov 2014
by jdaw1
djewesbury wrote:This is the wrong place for this discussion
Prior precedent can be found in posts starting at 1350, 1256, 1225, 1212, and perhaps elsewhere. In some of these you have contributed to the discussion without complaint.

Apostrophe crimes

Posted: 14:15 Sat 29 Nov 2014
by djewesbury
Now I am complaining. Precedent means nothing here.

Re: Apostrophe crimes

Posted: 14:18 Sat 29 Nov 2014
by jdaw1
djewesbury wrote:Precedent means nothing here
This is the wrong place for this discussion (other than to mention the omission of the terminal full stop).

Re: Apostrophe crimes

Posted: 14:52 Sat 29 Nov 2014
by PhilW
Your original was clear. For additional evil-lawyer satisfaction:
"Each [thing] shall then be [maths in words], rounded to the nearest thousandth of a basis point; exact half of a thousandths of a basis point of yield being rounded up."

Note, you have given several examples, but then said "And don’t assume that all numbers are positive" without confirming your intention with regard to negative numbers. Your definition would mean that (first three as per your quote, second three added by me):
50.00049 → 50
50.0005 → 50.001
50.00051 → 50.001
-50.00049 → 50
-50.0005 → 50
-50.00051 → 50.001
If this is as you intend, all is good; otherwise you would need to state that exact half of thousandths are rounded to the next thousandth away from zero, instead of rounded up, or similar.

Re: Apostrophe crimes

Posted: 15:00 Sat 29 Nov 2014
by djewesbury
Battle lost. Quants have taken control here as elsewhere. Is nowhere safe from their meaningless ranting?

Re: Apostrophe crimes

Posted: 15:36 Sat 29 Nov 2014
by jdaw1
PhilW wrote:you have given several examples, but then said "And don’t assume that all numbers are positive" without confirming your intention with regard to negative numbers.
For negative numbers I don’t particularly care which happens, except that I don’t want to pay lawyers to squabble about it. So anything clear.

Current favourite:
> Each [thing] shall then be [maths in words], rounded to the nearest thousandth of a basis point; an exact half of a thousandth of a basis point of yield being rounded up.

Re: Apostrophe crimes

Posted: 15:41 Sat 29 Nov 2014
by DRT
I am a little unclear about what there is to squabble about. My maths qualification extends to a 98%ish score in the Scottish equivalent of an A-Level. My intuitive understanding of rounding would always result in me rounding 5 and above to 10 and below 5 to 0.

Do lawyers do it another way?

Re: Apostrophe crimes

Posted: 15:43 Sat 29 Nov 2014
by jdaw1
DRT wrote:Do lawyers do it another way?
Sometimes — it depending on the instructions from the client.

† Except when billing the client, rounding then always being up.

Re: Apostrophe crimes

Posted: 15:46 Sat 29 Nov 2014
by DRT
Does the method of rounding you wish to employ meet with an international standard or specific, documented academic definition? If so, reference the source.

Re: Apostrophe crimes

Posted: 16:04 Sat 29 Nov 2014
by PhilW
DRT wrote:I am a little unclear about what there is to squabble about.
Sometimes it matters in order to avoid cumulative errors over analysis of large data sets, or addition of bias. For example, consider rounding a serial of positive floating point numbers; if you were to always round up to nearest integer, you would add a bias of 0.5 to the mean of the rounded data compared with the original. Rounding to the nearest integer works much better, but the if the rounding of the mid-point value always occurs in the same direction, this can cause a similar cumulative error over a large enough data set. This matters in some data processing applications.

Re: Apostrophe crimes

Posted: 16:10 Sat 29 Nov 2014
by PhilW
DRT wrote:Does the method of rounding you wish to employ meet with an international standard or specific, documented academic definition? If so, reference the source.
Yes, the IEEE defines standards for definition, format and rounding of floating point numbers stored in binary format (IEEE 754). Julian's case here is slightly different, since it is referring to the rounding to thousandths, though the same terminology could be used; in Julian's current definition the terminology would be "rounding to nearest, ties to +infinity", although ironically this is not one of the standard formats; "rounding to nearest, ties to even" is the default, while "rounding to nearest, ties away from zero" is simpler to explain.

Re: Apostrophe crimes

Posted: 16:32 Sat 29 Nov 2014
by jdaw1
There is no problem with large datasets; no standard need be followed; and I don't particularly care how rounding is done provided that it is clear, seems reasonable to a numerate lay observer, and is utterly unsquabblable.