logarithmic trendline equation

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Using Excel 2000. Created chart and added logarithmic trendline to get the
equation. Is there a function in Excel that will create this equation
without creating a chart?
 
merryhaz -
Using Excel 2000. Created chart and added logarithmic trendline to get
the equation. Is there a function in Excel that will create this
equation without creating a chart? <
Click to expand...

The log trendline uses the equation Y = c*Ln(X)+b.

c = SLOPE(Yrange,LN(Xrange))
b = INTERCEPT(Yrange,LN(Xrange))

- Mike

www.mikemiddleton.com
 
Back
Top