Tags: coefficients, difficulty, excel, linest, microsoft, msdn, multivariable, order, outputed, regression, reverse, software

How do I reverse the linest coefficients?

On Microsoft » Microsoft Excel

1,286 words with 1 Comments; publish: Wed, 04 Jun 2008 12:34:00 GMT; (30678.13, « »)

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

All Comments

Leave a comment...

  • 1 Comments
    • 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

      #1; Wed, 04 Jun 2008 12:35:00 GMT