Hi,
I have some tables, It's like this
Current ADC
0 511
1 518
2 533
5 580
10 664
15 753
21 861
I want to extract the algebra function from it(different systems with different current curves), Do you know some automatic ways? do you know a function in matlab or excel?
So for example it will give me a function and when I put the adc value I will get the interpolated current!
The method to use depends on if the function is linear or have some more complicated shape.
For linear, Google "linear regression". The result will be a formula on the form
y = k*x + m
where the regression will supply the k and m values. You then insert your x value to interpolate (or, for the brave, extrapolate) the y value.
There exists different methods for estimating k and m. One often used, and relatively simple to calculate, is the method of "least squares". The method requires math operations like summing, squaring and taking the square root.
(This is high-school maths AFAIK.)
Is the analysis to be done on an AVR?
Is the interpolation to be done on an AVR?
Thanks,
The analysis would be on PC, but the function would be calculated on avr for interpolation, if the values are not linear what should I do to reach the best efficient math like function?
That depends on the "form of the line". Exponential/logarithmic? Or some more complicated form.
For sure, even linear regression is of-course an approximation. Linear regression analysis can give you an estimate on how well a straight line fits your scattered points of data.
The analysis would be on PC
There is also a LOGEST for non-linear functions.
Great link thanks :)
Note that I want to extract the function,
For example I wanted to insert the table in the PC and PC would give me a function like y=0.5X + 1.34X^2 + 3X^3+0.3
Then I would insert numbers instead of x in my avr and calculate the y value!
have you looked at John's link. It looks like they all there!
1. select polynomial
2. 3th order
etc
etc
For example I wanted to insert the table in the PC and PC would give me a function like y=0.5X + 1.34X^2 + 3X^3+0.3
have you looked at John's link. It looks like they all there!
Ali,
this site is available from here, so I think it is blocked by 'your' (being the iranian government I assume) firewall.
Take a look at XlXtrFun plugin for Excel. It's still the best tool for such things. It can assist you with choosing the minimal function degree needed with visual curve fitting based on entered data, and calculate polynomial coefficients for you. So after entering X-Y pairs data table of measured values, you get K0, K1, K2, K3... polynomial coefficients for Y = K0*X^0 + K1*X^1 + K2*X^2 + K3*X^3 + ... (depends on the function order you choose). For standard sensors medium accuracy is met with 3rd, and great accuracy with 4th or 5th order polynomial functions.
Zdravo Avro,
Evo mene u zemlji srbiji.
Google says...
Hi Avro,Here's me u earth Serbia.
I came across the " XlXtrFun plugin for Excel" some years ago. Thanks for reminding me. Their author has just turned 90 years old. Happy birthday Freeman Dyson!
Hi,
I was looking to download the XlXtrFun plugin because i used to work with it on a previous PC. Somehow i cannot get passed the registration form, it gives me an error in return. Did somebody else had problems with that? I already send an email to their support group last night but without a response yet (i am maybe to hasty).
Thanks
Marjolein
Matlab Curve Fit tool, call "CFTool" from the matlab prompt to launch it.
I had been using a modified polyfit.bas program credited to William G. Hood from the June 1987 issue of Byte Magazine for many years until I lost the code some years ago. When I went searching for it, I found a similarily named program offered by Prof Robert Keen of Michigan State. It is not as elaborate as my modified version, but may be of help if you are interested. yell out and I will upload it if needed. It uses the method of least squares.
Cheers,
Ross
Dear avra
Thanks for the info,
But it seems I can not download the tool, no matter if I use my VPN
It says
You don't have permission to access /cgi-bin/formmail/formmail.pl on this server.
.. it seems I can not download the tool...
If you need Delphi code that can calculate polynomial coefficients based on entered data then tell me and I will upload that too.
Have fun!
btw. I really, really hate entering capture every time. Can't it just remember me for at least a few minutes?
Thanks avra, If you could upload the Delphi code too, it would be nice.
Ali!
Is your example in the first post some real data?
If so, then you are quite close to linear.
(There is one drawback of the charting functionality in LibreOffice. It seems you can not have mixed types of data series. Below both your data and the interpolated series are lines. I would have liked your data to be points. It seems Excel wins out here. Hope the diagram is clear enough anyway.)
Is your example in the first post some real data?
A formula for "linear estimation" / interpolation of that data set is
y = 16.875 * x + 501.25
(My screen dump comes from a PC with Swedish locale - we use ',' as decimal delimiter.)
If you have MATLAB it's easy. Just plot the data. In the plot window there's a menu item, "Tools" I think, that will let you fit a curve to the data. You can select anything from a straight line fit to 8th order or so.
Greg
Thanks
Delphi curve fitting code as promised:
http://www.qfpost.com/file/d?g=v...
Circuit Cellar Dec 2013 has curve fitting article with nice Excel graph sheet and some C code:
ftp://ftp.circuitcellar.com/pub/...
Thanks avra
