If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
logarithmic trendline equation
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? |
#2
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Logarithmic Trendline - Please Help | Chantay Thomas | Charts and Charting | 1 | April 22nd, 2004 01:35 PM |
Trendline Equation Accuracy | Jerry W. Lewis | Charts and Charting | 0 | March 5th, 2004 12:56 PM |
Trendline Not The Same as Equation Displayed | Dan | Charts and Charting | 2 | January 28th, 2004 02:00 AM |
Logarithmic trendline unavailable | Kevin Becker | Charts and Charting | 2 | January 16th, 2004 01:08 AM |