How do I reverse the linest coefficients?
 

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)) to fill in dataspace (or use
Sum(inputs*ouput coefficients) ).

Any suggestions on a way reverse the order?

Thanks in advance
cseeton

Answered under your separate post to microsoft.public.excel.misc

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)) to fill in dataspace (or use
Sum(inputs*ouput coefficients) ).

Any suggestions on a way reverse the order?

Thanks in advance
cseeton