My research question is whether aptitude tests are a good indicator on how students will perform on course exams. I have already performed an analysis on total exam score compared with total aptitude score.
I am now wondering whether getting a certain question on the test right or wrong is related to how that student scored on the aptitude test. I have heard that Spearman's Coefficient is the best bet for this, but I'm unsure that's the best methodology.
I'm doing this project in excel and working with 100 columns. Column 1 is student ID, Column 2 is aptitude test score, and 3-100 are individual test question responses (either 1 or 0).
What do you recommend?