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
|
|||
|
|||
common log trendline
Is there anyway to get a common log trendline for an EXCEL graph. I know how
to get the natural (ln) log trendline but I need a common log trendline/line equation in order to properly analyze my ELISA experiment. |
#2
|
|||
|
|||
common log trendline
Hello:
There are a number of options. You just can convert the cofficients you have to the common logs see http://www.purplemath.com/modules/logrules3.htm for the process. You can also calculate the cofficients yourself using linest(), the Regression Wizard in the analysis toolpak, or the slope(), intercept() etc functions. Before you apply one of these convert your observations to a log value by using the log() function. Then run the above regression on the converted values. Pieter Vandenberg Greg wrote: : Is there anyway to get a common log trendline for an EXCEL graph. I know how : to get the natural (ln) log trendline but I need a common log trendline/line : equation in order to properly analyze my ELISA experiment. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Trendline Extract | Phil Hageman | Charts and Charting | 5 | July 6th, 2005 02:27 AM |
How do I get the trendline equation from Excel to script? | Mattias | Charts and Charting | 1 | December 7th, 2004 12:21 PM |
Trendline and its referencing / linking to a cell | MikeG | Charts and Charting | 0 | February 5th, 2004 03:17 PM |
Trendline Not The Same as Equation Displayed | Dan | Charts and Charting | 2 | January 28th, 2004 01:00 AM |
trendline equations | kathy | Charts and Charting | 5 | October 2nd, 2003 10:12 PM |