Purchase Solution

Using Spearman's to Determine if Data is Significant

Not what you're looking for?

Ask Custom Question

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!

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

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.

View More Free Quizzes
Related BrainMass Solutions

  • Spearman's correlation coefficient

    I also need to know if the result is statistically significant. Thanks in advance! Claire Analysis. First, we need to calculate the Spearman's correlation coefficient of the attached data. We can set up the following table.

  • Determining the significance of correlation from a data table.

    Now the variables are interval variables, this is why your Professor recommend you use the Spearman's rho procedure to determine the relationship between the 2 variables.

  • New health care program in the United States

    perform risk analysis of patients to determine the cost of providing care.

  • Regression analysis in SPSS

    Please use SPSS 17 to open the data set and output 1) Enter the following data in an SPSS Data spreadsheet. Be sure to insert your variable labels and names.

  • Spearman's Rank Correlation and other Statistical Concepts

    Null Hypothesis and alternative hypothesis are H0: There is no significant relationship between the two sets of data. H1: There is significant relationship between the two sets of data.

  • What is correlation?

    When the t-statistic is calculated for Spearman's rank-difference correlation coefficient, there must be at least 30 cases before the t-distribution can be used to determine the probability.

  • How is the strength of a correlation determined?

    When the t-statistic is calculated for Spearman's rank-difference correlation coefficient, there must be at least 30 cases before the t-distribution can be used to determine the probability.

  • Significance Levels for baseball data; Spearman's Rank-Order correlation

    388038 Significance Levels for baseball data; Spearman's Rank-Order correlation 1. Refer to the baseball data for 2005 on 30 major league teams (see bottom of page). Use a Contingency Table to analyze the relationship between games won and salary.

  • Linear Regression Model

    (B) If you wished to add the condition of 95% confidence in your 2005 forecast, what would be the range of prediction? (C) Would you expect r2 (r squared) to have been computed using Pearson's or Spearman's mthod? Why?

View More Related Solutions