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
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?
@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.
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.
The function you want is not pwrfit, you want polyfit.
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?
@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?
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!)
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)
Thanks a lot Werner! I learned a lot from your last 2 posts