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

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.

Regular Member
(in response to Werner_E)

## 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?

## Re: Quadratic fitting of data

Here are the three methods I mentioned before in comparison:

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 😉

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

Regular Member
(in response to Werner_E)

## Re: Quadratic fitting of data

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

Announcements
Check out the latest