Explore BrainMass

# Spearman's correlation coefficient

Not what you're looking for? Search our solutions OR ask your own Custom question.

This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

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.

https://brainmass.com/statistics/correlation/spearmans-correlation-coefficient-20539

#### Solution Preview

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

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