I have trouble finding an answer to my question even though I believe it should not be too hard to answer.

I want to calculate a Spearman coefficient between a fixed variable X (e.g weight) and a variable collected 5 times Y (e.g. jump height). Let's say I have 3 participants. How should I do this in SPSS or Excel?

Subject Var1 Var2

1 1 2

1 4

2 2 4

2 6

3 3 6

3 8

1. Calculate the mean for variable Y and then do the correlation

1 1 3

2 2 5

3 3 7

2. Compute the correlation coefficient with the columns like this:

1 1 2

1 1 4

2 2 4

2 2 6

3 3 6

3 3 8

I know it is a basic question, but I can't find the answer and it changes the results.

Thanks,

Gabriel Moisan