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? <
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