Cross Validated is a question and answer site for people interested in statistics, machine learning, data analysis, data mining, and data visualization. It only takes a minute to sign up.
Sign up to join this community
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.
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.
