| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Log trendline function?
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Log trendline function?
There is a simple relationship between Ln(X) and Log(X)
If Y = aLn(X) then Y = 2.303*a*Log(X) The value 2.303 is more exaclty given by =1/LOG(EXP(1)) see also http://www.stfx.ca/people/bliengme/E...&%20LOGEST.htm http://www.stfx.ca/people/bliengme/E...Polynomial.htm -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Greg" wrote in message ... 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VBA | Excel Worksheet Functions | |||
| Date & Time | New Users to Excel | |||
| Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
| Conversion | Excel Worksheet Functions | |||
| HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions | |||
Linear Mode
