View Single Post
  #2  
Old March 18th, 2006, 09:07 PM posted to microsoft.public.excel.misc
external usenet poster
 
Posts: n/a
Default 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.