- #1
Brad_Ad23
- 502
- 1
I'm wondering if there is a program that can do this, and if so which one and how.
What I need is a program in which I can make columns with data in it. One column should have its rows be the sum of the corresponding rows in the other columns. Then I need to calculate the correlation of each column to the column that contains the sums. Excel can do this fine, but the next part is not so easy. I need to have it generate all the possible combinations of 53 numbers taken 6 at a time. When one combination is generated, it should add one to each corresponding row in the last column (that is to say, row 34 in the last column would be say 5, then when a 34 was generated along with 5 other numbers, it would become 6 and likewise the other rows would have their number increase by 1). Once this is simulated, the correlation for the column in question should be checked against a range that is set. So if I set it at between 0.35 and 0.36 and after one combination is run through it is 0.35555 the program would keep the combination generated and then return the cells to the original value and continue running through the remaining combinations. If you need me to clarify something just ask and I will try.
edit: I put this here because it deals with a probability forecasting model I'm working on and my computer programming skills are not that strong.
What I need is a program in which I can make columns with data in it. One column should have its rows be the sum of the corresponding rows in the other columns. Then I need to calculate the correlation of each column to the column that contains the sums. Excel can do this fine, but the next part is not so easy. I need to have it generate all the possible combinations of 53 numbers taken 6 at a time. When one combination is generated, it should add one to each corresponding row in the last column (that is to say, row 34 in the last column would be say 5, then when a 34 was generated along with 5 other numbers, it would become 6 and likewise the other rows would have their number increase by 1). Once this is simulated, the correlation for the column in question should be checked against a range that is set. So if I set it at between 0.35 and 0.36 and after one combination is run through it is 0.35555 the program would keep the combination generated and then return the cells to the original value and continue running through the remaining combinations. If you need me to clarify something just ask and I will try.
edit: I put this here because it deals with a probability forecasting model I'm working on and my computer programming skills are not that strong.