LINEST with r2 = -1.18 ???
Hi all
this is funny. Missing values are a problem with LINEST However, the very Excel that does not allow for missing values, ignores them when plotting a polynomial function Since I exactly need the regression parameters from a polynomial regression of the fomr y=a*X^3+b*X^2+c*X+d, then the question becomes, how I can *automatically* get out the parameters from the equation in the plot into a set of cells. I would also need t-test and significance but that can be solved later Thank you! |
All times are GMT +1. The time now is 12:11 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com