What test(s) should I perform to analyse whether a relationship exists between

i) two discrete variables (e.g. variables that take only the values 0, 25, 50, 75, 100)

ii) one discrete and one continuous variable

Since I have a large set of data, I have inputted it into Excel. How to do these tests there would be most helpful.


1 Answer 1


Although without further information I can't be sure, but I assume these variables (the ones with the values 0, 25, ...) are in reality nominal (categorical) variables, although they are coded with numbers. (Or at most they seems to be ordinal.) So based on this assumption I would say the answer for your questions:

i) Test of independence (and instructions to carry out in Excel)

ii) One way ANOVA (and instructions to carry out in Excel)

Again, the answer is based on my assumptions above. You can find a nice summary for testing relationship between different kind of variables (nominal, ordinal, interval, ratio scale) here.


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.