LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
cseeton
 
Posts: n/a
Default Linest - Why did they do that?

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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I reverse the linest coefficients? cseeton Excel Worksheet Functions 1 March 11th 05 01:09 PM
LINEST maximum number of predictor variables Peter N Excel Worksheet Functions 7 February 17th 05 10:14 AM
Excluding 0s and blanks from a LINEST function Disco Excel Worksheet Functions 4 February 4th 05 04:54 AM
how can i fill a table with values from repeated regressions buragotch Excel Worksheet Functions 4 January 1st 05 01:25 PM
Trend Lines (or Linest?) Martinaire Excel Worksheet Functions 2 November 26th 04 06:08 PM


All times are GMT +1. The time now is 02:19 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"