G Guest Apr 26, 2006 #1 Is it possible to copy trendline logarithmic constants to a cell for further calculations.
T Tushar Mehta Apr 26, 2006 #2 For my enhancements to Dave Braden's code to do the needful: http://groups.google.com/group/microsoft.public.excel.charting/msg/0eda30f29 434786d?hl=en& To get the results directly in a worksheet: Trendline Coefficients and Regression Analysis http://www.tushar-mehta.com/excel/tips/trendline_coefficients.htm -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions
For my enhancements to Dave Braden's code to do the needful: http://groups.google.com/group/microsoft.public.excel.charting/msg/0eda30f29 434786d?hl=en& To get the results directly in a worksheet: Trendline Coefficients and Regression Analysis http://www.tushar-mehta.com/excel/tips/trendline_coefficients.htm -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions
D David Biddulph Apr 26, 2006 #3 Cheetha said: Is it possible to copy trendline logarithmic constants to a cell for further calculations. Click to expand... Can't you use the LOGEST() function?
Cheetha said: Is it possible to copy trendline logarithmic constants to a cell for further calculations. Click to expand... Can't you use the LOGEST() function?
M Mike Middleton Apr 26, 2006 #4 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 - 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
