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
<colgroup><col width="67" span="7" style="width:50pt"> </colgroup><tbody>
</tbody>
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>