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

Quadratic fitting of data

GvanBoven
Regular Member

Quadratic fitting of data

Hello everyone

 

Attached to this post is a zip file with prime 3 sheet and an excel with the data. I need to fit this data using the following equation:

 

y = ax^2+bx+c

 

The solution I tried is not able to find an awnser.

 

Can anyone help me find a good fit to the data?

8 REPLIES 8

Re: Quadratic fitting of data


@GvanBoven wrote:

Hello everyone

 

Attached to this post is a zip file with prime 3 sheet and an excel with the data. I need to fit this data using the following equation:

 

y = ax^2+bx+c

 

So why are you using pwrfit?? pwrfit (lookup the help!= tries to fit y=a*x^b+c and that has nothig to do with the quadratic fit you are looking for.

There are several way that this can be done in Prime

1) Use "polyfit". If you need to see the coefficients a,b,c, then use polyfitc

2) Use "linfit" with a vector consisting of 1,x and x^2 as function argument

3) Use "genfit". You can fit your data to any function you define with any number of parameters.

Re: Quadratic fitting of data

Hello Werner,

 

ah your right. I misread the formula of the pwrfit. I want to calculate a b and c so I guess I need to use the polyfit function. Thanks for the quick replay.

Re: Quadratic fitting of data

 The function you want is not pwrfit, you want polyfit.

Re: Quadratic fitting of data

Thank you Fred,

 

I am uncertain how I can caculate the  a b and c when I am using a polyfit function. Could you provide me with some more help?

 

Re: Quadratic fitting of data


@GvanBoven wrote:

Thank you Fred,

 

I am uncertain how I can caculate the  a b and c when I am using a polyfit function. Could you provide me with some more help?

 


Capture.PNG

Re: Quadratic fitting of data

Here are the three methods I mentioned before in comparison:

QFit.png

Worksheet attached is in P4 format, so your Prime 3 will not be able to read it (and P4 is not able to save in P3 format - what a shame!)

Re: Quadratic fitting of data

OK, just for fun and for "completeness" sake here are two more methods 😉

B2.png

In 5) I forgot about the good habit I mentioned in 4)

Re: Quadratic fitting of data

Thanks a lot Werner! I learned a lot from your last 2 posts

 

Announcements
Check out the latest
Mathcad Tip
"PTC Mathcad 15 / Prime 1-6 Update."