Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I reverse an entire column of names that have the last nam. | Excel Discussion (Misc queries) | |||
How 2 reverse order of columns | Excel Discussion (Misc queries) | |||
Excluding 0s and blanks from a LINEST function | Excel Worksheet Functions | |||
I typed a column in reverse order, how do I flip it (upside down). | Charts and Charting in Excel | |||
how to paste the values in reverse order in workbook | Excel Discussion (Misc queries) |