topic Re: y=A/x+B Formula fitting in Mathcad

y=A/x+B Formula fitting

Aary — Fri, 05 May 2023 09:46:57 GMT

Hello everyone, Here I need a help in formula fitting. x=[0.2;0.3;0.4;0.5;0.6;0.7;0.8;0.9;1.0] y=[0.25;0.51;0.78;1.15;1.5;1.87;2.35;2.85;3.4] I want to fit formula y=A/x+B , how can I calculate the paramaters of A and B using Mathcad. Thank you

Re: y=A/x+B Formula fitting

Werner_E — Fri, 05 May 2023 11:39:20 GMT

You may either set up a solve block with "minerr" , minimizing the sum of squared errors, or, more convenient, use the "genfit" function. Look the latter up in he help.

If you need more help, come back here and don't forget to attach your worksheet with the data.
In case you are using Prime, you should also mention which version you are using.

P.S.: I don't think that the function type you have in mind would result in a suitable fit

Rather use y=A/(x+B) or even better y=A/(x+B)+C

Re: y=A/x+B Formula fitting

Fred_Kohlhepp — Fri, 05 May 2023 12:04:46 GMT

If you have a full (paid) version of Mathcad Prime, there is a built-in function:

For those of us muddling along with the free Express version, you can easily do least squares fits of any order polynomial. Two Prime 4.0 files attached.

Re: y=A/x+B Formula fitting

Werner_E — Fri, 05 May 2023 12:49:35 GMT

So you think he wanted to to ask for a linear regression and it should read y=A*x+B and he just accidentally wrote y=A/x+B ?

Possible. I thought he would like to fit a hyperbola and as I already indicated I think a hyperbola would at least need some sort of horizontal displacement (B) and better also some vertical displacement (C) - and of course scaling (A).

But a polynomial fit of order 2, a parabola, seems to do a good job as well

Comparing the sum of squared errors we see that the hyperbola offers just a very slightly better fit

Attached sheet uses the y-values provided by Fred and is in P9 format

Re: y=A/x+B Formula fitting

Fred_Kohlhepp — Fri, 05 May 2023 16:27:39 GMT

Sorry, I've got to learn to read more carefully.

Attached is my least squares fit to a parabola. The hyperbola fit is included but fails. (Well, you get a fit but if you look a Werner's function you can see why there's no success--I've got the wrong form of expression. Adjusting the formula (and stealing Werner's value for B) has been included.

File is Prime 4, readable in any Prime greater than or equal to 4.

Re: y=A/x+B Formula fitting

Werner_E — Fri, 05 May 2023 18:02:47 GMT

I am always fascinated by the clever workarounds to find a solution even in Express. Chapeaux!