With some tricks you canĪlso perform LS on polynomes using Excel. Y=a.x+b, y-a.exp(b.x), y=a.x^b and etcetera. Fitting simple linear equationsĮxcel provides us with a couple of tools to perform Least SquaresĬalculations, but they are all centered around the simpler functions:
Method here, just read up on the matter by clicking that link to Perhaps you did some measurements with results like this:Ī well known way to fit data to an equation is by using the
If you're a properĮngineer, you also have some idea what type of equation should Way to fit your measurement results with a curve. Have probably done your bit of experimenting. If you're an engineer (like I used to be in a previous life), you Fitting curves to your data using least squares Introduction
0 kommentar(er)
