You'd probably have to write up a macro to do that.

That said, i know what you mean, since i have to do that a lot as well.
Although from a statistics point of view, it's not the most ideal thing to do
since chasing R squared isn't how most modelling is done.

I'd be interested in any solution as well. I know that you can write a macro
to do this, by using the ML solutions as the formulas for most of the
equation types to then choose the best one.


"PowerUp321" wrote:

Is there a program that will take data in rows and columns and return the
trendline equation? What I have in mind is similar to LINEST but would go
though all the possilbe curves (power, exponential, poly, etc) automatically
and return the best fit based on the highest R squared value. Currently, I
have to manually plot the data add a trendline and determine which is the
best fit.
Thanks,
Nick