LINEST on specific non-adjacent columns

[smeador]

Hey guys,

So I am running a daily fantasy regression analysis and I need some help. I have found that certain criteria is better suited for predicting some player's performances than others. So I want to run a solver that will pick which criteria to use to maximize the R squared value.

I listed an example of what it might look like below. I will run binary cells along to top of each column, and I wish to include the columns that come up with a 1 on the top and ignore the columns that come up with a 0 on top. There will be parameters in place to avoid unreal R squared values, but that is not my current concern.

I cannot think of a formula, or a method to use LINEST with the left most column (Actual) as the Y variables and then use each column with a 1 over the top of it as the X variables. Again, columns that show up with a zero above them should not be used in the LINEST.

Thanks a lot,
Shawn

​

	0	1	1	1	0	1
Actual	BaseV	Average	CompV	Ease	MPG	Rest
44.1	41.73376	41.35643	35.95	-0.35	36.7	1
23.8	41.16518	40.94199	38.67	0.25	36.2	1
27.4	41.16518	42.50528	34.95	-0.38872	36.2	1
35	40.5966	42.50218	33.44	-0.08	35.7	1
47.8	40.5966	41.69813	33.7	0.6	35.7	0
46.3	40.5966	41.88781	35.71	-0.26	35.7	1
36.9	41.16518	44.80577	37.04	0.6	36.2	0
37.8	41.73376	39.543	37.02222	-0.10181	36.7	4
38.8	41.39261	44.93608	37.1	0.066058	36.4	3
40.8	40.74429	39.32746	37.2	-0.6	37.35	1
49.7	34.57	39.10413	37.55	0.77	30.4	0
33.8	40.05	37.25455	38.48	-0.19	35.4	1
39	43.62	39.58	39.93	-0.17	36.4	1

<colgroup><col width="67" span="7" style="width:50pt"> </colgroup><tbody>
</tbody>

 

[smeador]

If there would be any other way to approach this I'd also appreciate that.