Thread: Best fit Curve
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
PowerUp321 PowerUp321 is offline
external usenet poster
 
Posts: 1
Default Best fit Curve

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