A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

common log trendline



 
 
Thread Tools Display Modes
  #1  
Old March 18th, 2006, 09:55 PM posted to microsoft.public.excel.misc
external usenet poster
 
Posts: n/a
Default 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  
Old March 18th, 2006, 10: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.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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 01:21 PM
Trendline and its referencing / linking to a cell MikeG Charts and Charting 0 February 5th, 2004 04:17 PM
Trendline Not The Same as Equation Displayed Dan Charts and Charting 2 January 28th, 2004 02:00 AM
trendline equations kathy Charts and Charting 5 October 2nd, 2003 10:12 PM


All times are GMT +1. The time now is 06:17 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.