| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to fit a "ln" function
I am in the process of fitting various data sets to functions. Some of these
data sets fit nicely using the LOGEST function in Excel, but several of the data sets include negative and "zero" values -- LOGEST does not work with such inputs. In charting the data sets with negative and zero values, I can add a logarithmic trendline and get a function that includes the natural logarithm (ln) that appears in the chart itself. Is there a function accessible through Excel/VBA that will fit such a curve (similar to LOGEST)? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Text "comparison" operator for "contains" used in an "IF" Function | Excel Worksheet Functions | |||
| Excel 2003: Conditional Formatting using "MIN" & "MAX" function | Excel Discussion (Misc queries) | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| function to return day in the form "Monday", "Tuesday" etc given . | Excel Worksheet Functions | |||
| inserting a conditional "go to" command on a excel "if" function | Excel Worksheet Functions | |||
Threaded Mode
