You could use the INDEX() function to reverse the coefficients, as in
=INDEX(LINEST(B1:B6,A1:A6),1,{2,1})
My guess as to why LINEST works this way, is that if you are doing model
selection (such as testing whether a quadratic term is a significant
improvement over a linear fit), you can do the test without displaying
all the columns of LINEST output. Yes, that's pretty weak, and I would
have preseverd the order of input columns, but I didn't write it ...
Jerry
cseeton wrote:
> I am having difficulty with the order of the coefficients outputed by linest
> when doing a multivariable regression. My problem is that the order is
> reversed from the input x variables. While for displaying the coefficients I
> do not have a problem, the problem is that my sheet is setup so that the
> column order is x1,x2,x3,x4... and I would like to use
> mmult(inputs,transpose(output coefficient)) or Sum(inputs*ouput
> coefficients) ) to fill in dataspace in other operations.
>
> Any suggestions on a way reverse the order so that I can use it with matrix
> operations without creating new columns in reverse order (involves reverse
> thinking on my part).
>
> Thanks in advance
> cseeton
