Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I reverse the linest coefficients? | Excel Worksheet Functions | |||
LINEST maximum number of predictor variables | Excel Worksheet Functions | |||
Excluding 0s and blanks from a LINEST function | Excel Worksheet Functions | |||
how can i fill a table with values from repeated regressions | Excel Worksheet Functions | |||
Trend Lines (or Linest?) | Excel Worksheet Functions |