Quote:
Originally Posted by artdutra04
You can do this in Excel...
|
In excel there are functions called SLOPE and INT that will calculate the best fit linear equation values (y=SLOPE*x+INT) from an x & y array of values. There are also formulas for exponential distributions.
Additionally, if you are still looking for the which best fit eqn to use try plotting the arrays on an XY graph. From the graph select a point from the dataset, right click and select the trendline option. This will allow you select from a variety of eqn forms (polynomial, log, exp...) and well as display the equation for the best fit curve and the R^2 value. You can use the equation for secondary processing, but it does introduce a minor amount of manual processing.