Explore BrainMass

Explore BrainMass

    Spearman's correlation coefficient

    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.

    Thanks in advance!

    © BrainMass Inc. brainmass.com March 4, 2021, 5:57 pm ad1c9bdddf
    https://brainmass.com/statistics/correlation/spearmans-correlation-coefficient-20539

    Attachments

    Solution Preview

    Please see attachment.

    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

    ADVERTISEMENT