M
marston.gould
I have 9 columns of data that represent candidate 'x' values along
with a column of data that represents the 'y' values.
Without having to create multiple rearrangements of this data, I would
like to determine the output of the linest function for various
scenarios:
=linest (included X columns, Y column, 0, true)
each cell that includes this function should have a different unique
permutation of each of the 9 potential candidates
e.g.
Scenario 1: column A,B,D,E,F,G,H,I; column L, 0, true
Scenario 2: column A,B,C,E,F,G,H,I; column L, 0, true
Scenario 3: column A,C,D,E,F,G,H,I; column L, 0, true
etc.
Any thoughts on how to make this simple.
Thanks in advance
Marston
with a column of data that represents the 'y' values.
Without having to create multiple rearrangements of this data, I would
like to determine the output of the linest function for various
scenarios:
=linest (included X columns, Y column, 0, true)
each cell that includes this function should have a different unique
permutation of each of the 9 potential candidates
e.g.
Scenario 1: column A,B,D,E,F,G,H,I; column L, 0, true
Scenario 2: column A,B,C,E,F,G,H,I; column L, 0, true
Scenario 3: column A,C,D,E,F,G,H,I; column L, 0, true
etc.
Any thoughts on how to make this simple.
Thanks in advance
Marston