Hello.
I have 26 dependent variables, all numeric data in separate columns on one sheet.
I want to get the r-squared for every single 16 member combination of these dependent variables against a single independent variable which is also wholly numeric and in a separate column in the same sheet.
I've seen the other posts about just simply programming LINEST into a loop. More what I'm after is a means for all 5 million plus combinations to be automatically generated and then have their r-squareds displayed in a third row that i could then order ascendingly to isolate the so-called "best combination"
Does that make sense? Thank you for all your help in advance.
I have 26 dependent variables, all numeric data in separate columns on one sheet.
I want to get the r-squared for every single 16 member combination of these dependent variables against a single independent variable which is also wholly numeric and in a separate column in the same sheet.
I've seen the other posts about just simply programming LINEST into a loop. More what I'm after is a means for all 5 million plus combinations to be automatically generated and then have their r-squareds displayed in a third row that i could then order ascendingly to isolate the so-called "best combination"
Does that make sense? Thank you for all your help in advance.
