Dear forum,

When doing a polynomial regression with =LINEST for two independent variables, one should use an array after the input-variables to indicate the degree of the polynomial intended for that variable. I do not get how one should use this array. The array I am talking about is for example ^{2,1,0,0} in the expression =LINEST(E2:E16,A2:A16^{2,1,0,0}*B2:B16^{0,0,1,2} (link to a related thread)

What I would like to do is making a regression for two variables, one probably linearly and one second order related to Y. What I tried to do is:

=LINEST(X1, X2^{1,2},TRUE,TRUE)

for the intended model Y = A*X1 + B*X2^2 + C*X2 + D*X1*X2 + b

I thought that this would work, but the resulting LINEST-array gives me #value errors.

How would I use the ^{1,2,3,etc} array?

Thanks a lot!