Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trendline Coefficients
Does anyone know if there are functions available in or for Excel that return
the coefficents of logarithmic and polynomial trendlines, analogous to Slope(...) and Intercept(...) for linear trendlines? Thank you. Sprinks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trendline Coefficients
Not only is LINEST a misleading name but the documentation is also
equally misleading. For more on how to get the coeffients for various types of trendlines see Trendline coefficients 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... Does anyone know if there are functions available in or for Excel that return the coefficents of logarithmic and polynomial trendlines, analogous to Slope(...) and Intercept(...) for linear trendlines? Thank you. Sprinks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trendline Coefficients
Thank you for your response, Tushar.
I read the material on your link, and appreciated the discussion regarding values not significantly different from zero, and in overspecifying regression. In your discussion of obtaining the two coefficients for an exponenential trendline, you indicated that =LINEST(y-range, LN(x-range)) will give the required a (slope) and b (intercept) values. I am missing how to enter this as an array value, such that it returns both the slope AND intercept. If I enter the line as a normal formula, it indeed does return the same slope value as the trendline. If you could provide a step-by-step instruction on how to do this correctly, I'd very much appreciate it. Also, your discussion of how to return the three coefficients of a quadratic trendline (the data with which I work never requires higher order polynomials) was over my head. Could you provide a detailed discussion of how to enter the needed formula(e) to return these coefficients? Thank you very much for your assistance. Sprinks "Tushar Mehta" wrote: Not only is LINEST a misleading name but the documentation is also equally misleading. For more on how to get the coeffients for various types of trendlines see Trendline coefficients 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... Does anyone know if there are functions available in or for Excel that return the coefficents of logarithmic and polynomial trendlines, analogous to Slope(...) and Intercept(...) for linear trendlines? Thank you. Sprinks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Extracting Trendline Coefficients | Excel Discussion (Misc queries) | |||
Coefficients of trendline | Excel Programming | |||
How to get polynome (or other type) coefficients of a trendline? | Excel Discussion (Misc queries) | |||
How to get polynome (or other type) coefficients of a trendline? | Excel Discussion (Misc queries) | |||
Trendline coefficients | Charts and Charting in Excel |