common log trendline

[Guest]

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.

 

[vandenberg p]

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

: 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.