logarithmic trendline equation

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

Michael R Middleton

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Logarithmic trendlines 1
Logarithmic Trendline 2
Excel What does E represent in Microsoft Excel?? 1
how do i extract the formula from a trendline in Excel? 1
Capturing Equations From Charts 1
Function for Logarithmic Trendline 9
Ploynomial Trendline Equation Changes After Copy Paste 11
Logarithmic Trendline Equation 2

Top