Solved – Test for relationship between i) two discrete variables ii) one discrete and one continuous

continuous datadiscrete datahypothesis testing

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.

Best Answer

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.

Related Question