JMP Pro 11.1.1 - Major Bug (?)

Question

Greetings,

Recently convert from JMP Pro 10 to JMP Pro 11.1.1 (includes Feb 2014 maintenance update to JMP Pro 11). Two seemingly major issues:

1. Simple formula #1: Column 3 = Column 2 - Column 1. Simple formula #2: Column 5 = Column 3 - Column 4. In all cases, Column 5 should equal 0, but it does not. Any thoughts?

2. Presumably related, but: Select matching cells (Row 1 Column 3) only selects (Row 2 Column 3), not (Row 3 Column 3).

Thank you,

optflow · Answer

Thank you both for the additional replies. I take it from all three of these replies that there is no ubiquitous, Round preset feature to select in JMP 11 ("smart faking"), so I suppose this concludes this thread.

ms · Answer

I reproduced your table in JMP 10 and get exactly the same result as you. There certainly are bugs in JMP 11, but this is not one of them.

unknown · Answer

It is an Intel issue not microsoft or SAS or any other program. There is even an IEE-standard.

IEEE floating point - Wikipedia, the free encyclopedia

floating point double-precision is what Intel is using as standard at the moment. Precision is 15 digits.

SAS(R) 9.2 Companion for Windows, Second Edition

Welcome in the digital age and the caveats.

"There are 10 types of people in the world; those that understand BINARY and those that do not"..

What there could be the case is some kind of FUZZ factor. That is rounding errors or very small digits are faked in a way you do not see the difference.

Excel and every other tool is having this same kind of behavior. That you do not see it, as the first calculators did,  is smart faking.
Amazing how many people have forgotten what are the basics behind all this. I remember a slider (Lorenz chaotic ssytems), now I am expecting a reaction hhhuu what is that?