| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Return the logarithm stats for a line of best fit
Hi,
I wish to return the logarithm stats based on the log line of best fit. I can do this for linear and poly entered as an array formula as follows; For linear =LINEST(C58:C69,B58:B69,,1) For 2nd order poly (quadratic) =LINEST(C58:C69,B58:B69^{1,2},,1) How do i modify this for a logarithm? Bruce |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| WHY WON'T MY ENTER KEY RETURN TO THE NEXT LINE? | Excel Discussion (Misc queries) | |||
| WHY WON'T MY ENTER KEY RETURN TO THE NEXT LINE? | Excel Discussion (Misc queries) | |||
| anti logarithm function for base 10 | Excel Worksheet Functions | |||
| Logarithm equation in charts | Excel Discussion (Misc queries) | |||
| Logarithm scaling for charts | Charts and Charting in Excel | |||
Threaded Mode
