Is there a way to have Linest return the coefficient and intercept in the same column? (i.e., so that the coefficient is in the cell above the intercept instead of to the left of it?)
I know I can do this using VBA, but before I resort to that solution I wanted to know if any array whizes out there have a suggestion that uses worksheet functions.
many thanks
p.s. having linest return the information in its normal layout and then reordering the cells is also not an option for me... I have many columns with predictor variables and I want to see the coefficient and intersect for each one independently and in its own column (without having to add a blank column between each variable)
I know I can do this using VBA, but before I resort to that solution I wanted to know if any array whizes out there have a suggestion that uses worksheet functions.
many thanks
p.s. having linest return the information in its normal layout and then reordering the cells is also not an option for me... I have many columns with predictor variables and I want to see the coefficient and intersect for each one independently and in its own column (without having to add a blank column between each variable)