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?

  • $\begingroup$ Spearman's rank correlation seems appropriate (as probably any other rank correlation). $\endgroup$ – Michael M Nov 20 '13 at 19:31

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.