Correlation with complex Arrays [Closed]

Report
-
Hello,

I understand how to do a basic correlation. But, if I have thousands of student data and want to run correlations of student test scores it gets more difficult.

So, this is what I wondering how to do = )

If "Arabic B" is stated in column 2, then I would like to use the corresponding values in the last two columns to run the correlation. So, the first row would be the values 4 and 6. The third row's values would be ommitted, as would be the fourth and fifth. In the future, I would to add more conditions. So, it would be something like if "Arabic B" is stated in column 2 AND "HL" is stated in column 3, then I would like to use the corresponding values in the last two columns to run the calcuation.

2013 Arabic B HL 0 4 630
2013 Arabic B HL 0 3 540
2013 Arabic B HL 0 6 520
2013 Econ HL 1 5 610
2013 Econ SL 0 6 470
2013 Geo SL 0 6 730
2013 Arabic B SL 1 5 460
2013 Arabic B SL 0 6 650

Any advice?

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!