I am trying to use the LINEST function to get a "n" degree polynomial regression. The problem appears when i have more than 1 independant variables. I can't seem to list x1 to the power of a polynomial, in conjunction with x2, nor can i list x1 and x2 to the power of a polynomial.
I have tried these formulas:
=linest(y range,(x1,x2)^column(a1:c1),,true) or
=linest(y range,[x1^column(a1:c1),x2],,true)
Does someone know how i can make it work with n degree polynomial, and 2 independent variables? HELP!
Bookmarks