Linest

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
 
Top