# Using Spearman's to Determine if Data is Significant

Not what you're looking for?

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!

##### Purchase this Solution

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

##### Purchase this Solution

##### Free BrainMass Quizzes

##### Measures of Central Tendency

This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.

##### Measures of Central Tendency

Tests knowledge of the three main measures of central tendency, including some simple calculation questions.

##### Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

##### Know Your Statistical Concepts

Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.