Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
copy trendline logarithmic constants to a cell
Is it possible to copy trendline logarithmic constants to a cell for further
calculations. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
copy trendline logarithmic constants to a cell
For my enhancements to Dave Braden's code to do the needful:
http://groups.google.com/group/micro.../msg/0eda30f29 434786d?hl=en& To get the results directly in a worksheet: Trendline Coefficients and Regression Analysis http://www.tushar-mehta.com/excel/ti...efficients.htm -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , says... Is it possible to copy trendline logarithmic constants to a cell for further calculations. |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
copy trendline logarithmic constants to a cell
"Cheetha" wrote in message
... Is it possible to copy trendline logarithmic constants to a cell for further calculations. Can't you use the LOGEST() function? -- David Biddulph |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
copy trendline logarithmic constants to a cell
David -
Excel's logarithmic trendline fits y = c*LN(x) + b. Excel's exponential trendline fits y = c*EXP(b*x). Excel's LOGEST function fits y = b*m^x. The b value corresponds to c in the trendline exponential function, and the m corresponds to EXP(b). So, LOGEST is a worksheet equivalent to exponential trendline, not to logarithmic trendline. - Mike www.mikemiddleton.com "David Biddulph" wrote in message ... "Cheetha" wrote in message ... Is it possible to copy trendline logarithmic constants to a cell for further calculations. Can't you use the LOGEST() function? -- David Biddulph |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
need to Copy or Move to active cell from specified range | Excel Discussion (Misc queries) | |||
AUTOMATIC way to copy the value of a cell in one spreadsheet | Excel Worksheet Functions | |||
How to Copy the value of a cell to any given cell | Excel Discussion (Misc queries) | |||
how to count the number of text frequencies and copy to other cell | Excel Worksheet Functions | |||
hpw do I logic test a cell then copy the row to diff. SS | Excel Worksheet Functions |