cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Visit the PTCooler (the community lounge) to get to know your fellow community members and check out some of Dale's Friday Humor posts! X

Getting a false output

fahmed-3
1-Newbie

Getting a false output

Hello Everyone,

I hope everyone is going to have a great week ahead. I am having a problem with a if else statement. Although my summation is matching from both sides but it is evaluating as  "False" in output. It would be very nice if you can help me out with it.

Thanks

Faisal

1 ACCEPTED SOLUTION

Accepted Solutions

If all units are removed, it also works

2017-03-06_12-12-12.jpg

I suspect the issue arises because, behind the scenes, Mathcad is working in meters.  So, working with feet engages a additional conversion calculation and that throws it's accuracy off.

View solution in original post

21 REPLIES 21

You're running afoul of numeric precision; the summation is not exact, so the difference is trivially small but not zero.  Reformulate your test:

So Mathcad is not good with English Units

No, Mathcad is fine with units.

Like any other machine addition process, there is a small but finite error in each mathematical calculation.  You're sheet is doing twelve additions, so the error is multiplied by 12.  Then you asked if one number was exactly equal to another, and your computer (not Mathcad) looked at the two numbers and decided they wer not identical.

One of my early calculators would error if I took the sine (of the (sine of( the sine (of 1 degree))), then took the arcsine( of that number) three times; the last operation asked for the arcsine of a number larger than 1.  It was trapped by the error that crept into the process.

Research "numerical accuracy," it's been a dilemma for computer programmers since there were computers.

I have compiled a similar problem used in SI units....and it has to do almost 29 summations....I used that with Mathcad and it didn't have the problem that was in English units....

By George you're right:

But I don't know why.

LucMeekes
23-Emerald III
(To:Fred_Kohlhepp)

I suspect because internally Mathcad runs fully in SI units. This means that for English units mathcad has to do more mathematical operations, so introducing more of those small deviations. But (unless you can keep your numbers in the integer range, which is the case for the calcuation in m) you should always take care when checking equality between two numbers.

Retry the same test with mm instead of m. My guess is that it'll go wrong at some point too.

Luc

If all units are removed, it also works

2017-03-06_12-12-12.jpg

I suspect the issue arises because, behind the scenes, Mathcad is working in meters.  So, working with feet engages a additional conversion calculation and that throws it's accuracy off.

DJF
16-Pearl
16-Pearl
(To:DJF)

And it looks like it solves as desired if you turn on the "Approximate Equality" option on the Calculation tab.

fahmed-3
1-Newbie
(To:DJF)

I tried with the "Approximate Equality" but it wasn't working either

And I tried with this and it worked......I have seen lately that Math cad has released Prime 4....I hope it will be revolutionary

MJG
18-Opal
18-Opal
(To:DJF)

This issue is exactly why Mathcad has the "Approximate Equality" option.  The same "error" can even happen using fractions:

The above returns true (1) when the "Approximate Equality" option is turned on.

fahmed-3
1-Newbie
(To:MJG)

you can try with English units and it won't work....I have seen the CTOL and TOL and my tolerance limit was beyond what Mathcad has offered

MJG
18-Opal
18-Opal
(To:fahmed-3)

Seems to work fine for me (with "Approx Equality" turned on):

fahmed-3
1-Newbie
(To:MJG)

It doesn't work when you compare between two long ( i.e 15) summations in ENglish units

MJG
18-Opal
18-Opal
(To:fahmed-3)

Can you post an example?  Anything I try seems to work fine with "Approx Equality" turned on.

fahmed-3
1-Newbie
(To:MJG)

Here you go

MJG
18-Opal
18-Opal
(To:fahmed-3)

Seems to work just fine for me:

fahmed-3
1-Newbie
(To:MJG)

Compare by Subtracting LDesign with Sum d and see if it holds true

MJG
18-Opal
18-Opal
(To:fahmed-3)

Interesting:

Here's a portion of what Help says regarding Approx Equality:

When this option is active, the absolute value of the difference between two numbers divided by their average must be < 10^-12 for them to be considered equal.

Mathcad is taking the difference between each side of the equality sign, and dividing by the average of the two values.  Since the average is so small (nearly zero), the result is larger than 10^-12.

Moral of the story: "Approx Equality" isn't good at comparing values to zero.

fahmed-3
1-Newbie
(To:MJG)

I hope this will not be a issue in Prime 4

DJF
16-Pearl
16-Pearl
(To:fahmed-3)

I just got 4.0 (free version for 30 days).  Unfortunately, it gives the same results.

2017-03-06_14-25-18.jpg

Top Tags