Share
Explore BrainMass

# Spearman's correlation coefficient

Hello,

I need to find out the Spearman's correlation coefficient of the attached data, I have analysed it using an Excel macro and come up with a different result from when I worked it out manually, using forumlas I found on the web.

I'm having trouble deciding which method is the right one, so I'd like someone to take my data and work out the correlation coefficient with the method they know to be correct (like I do not!).

The p value is .05 (1-tailed)

I am not very confident with statistics so if you could provide an easy-to-understand explanation to the figures and the steps used to get them it would be greatly appreciated!

I also need to know if the result is statistically significant.

#### Solution Summary

Using Spearman's correlation coefficient, I'd like someone to take my data and work out the correlation coefficient with the method they know to be correct (like I do not!).

The p value is .05 (1-tailed)

Child Test A Results Test B Results
1 7 18
2 4 9
3 4 6
4 3 24
5 4 14
6 7 39
7 12 20
8 5 18
9 4 13
10 4 10

\$2.19