Explore BrainMass

Explore BrainMass

    Using Spearman's to Determine if Data is Significant

    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!

    Hi there,
    I used excel to analyze my data with spearmans rank order co efficient test and came up with the attached table.

    I have a query about finding out whether my correlation coefficient - 0.420- is statistically significant. This is what i understand (not much!)

    - take the t value and compare it to the critical value (my hypothesis is 1-tailed, my confidence level is .05) so i compare 1.308 and 1.860

    - if the critical is equal to or less than t, it is significant (which it's not)

    But i'm a bit confused because i read in a stats book that you have to compare your coefficient to a critical table of coefficients to find out if it is significant. The book had the table in there and the coefficient for N=10 didn't match anything i have on the data table that exel came up with. has excel already done this for me?

    also, i know i have to compare one of these numbers to my p value (.05) but don't know which one. what is a p value and how is it different from confidence levels?

    As you can see, i am very confused and basically need help interpreting my data and also in explaining it accurately in my project. i need it explained in very simple terms tho!

    © BrainMass Inc. brainmass.com March 4, 2021, 5:57 pm ad1c9bdddf


    Solution Preview

    ----------------------------------------------------------------------We can use rs(the correlation coefficient) as an hypothesis testing statistic. Every time you use this test your null hypothesis will be:
    <br>"There is no correlation between the two sets of data".
    <br>To accept or reject this hypothesis you must compare your value ...