Using Spearman's to Determine if Data is Significant
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!
----------------------------------------------------------------------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 ...
... a mathematical formula that can be used for predictive ... Then you can use that formula to predict ...Using the regression equation, the dependent variable may be ...
... tables can be used to determine signifi- 4,513 to ... nature of the might be to use percentile scoring ...Using the percentile grow provider markets produced great ...
... As such one cannot use a relationship statistical ... When attempting to determine, through a statistical process ... The Spearman rho differs from the Pearson r ...
... Please use the same data that I sent in the ... First, Spearman's Correlation Analysis can be used for variables ... is a useful alternative to Spearman's for datasets ...
... The following assignment might be used to assess how ... words answer the following questions use the Rank ... will obtain your numerical answer using Excel and ...
... mean (using counts) Weighted mean (using categories) Questions ... level of measurement = Alternate statistic used if there ... in dataset = Do not use statistic for ...
... or the individual(s) who are to make use of the ... Test is used to determine whether a sequence of ... This data could be analyzed using non-parametric statistics (ie ...
... the Statdisk, and observe the effect on the spearman rank correlation ...Use a 0.05 significance level ... First visit: Regular tips Using the bill amounts and the tip ...
... For ordinal variables Spearman rank correlation is suitable. ... (hint: use the Bivariate Correlation procedure). ... Thus ACT can be used to predict the College GPA. ...