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.

**Contents**hide

#### 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.

### Similar Posts:

- Solved – Measure of Association between two Ordinal Variables
- Solved – Exploring the relationships between discrete and categorical data
- Solved – SPSS twostep cluster analysis to use with ordinal variables
- Solved – Nominal/Ordinal and scale in SPSS OLS regression
- Solved – What level of measurement is a factor score