Inferential Statistics

profileJames00712212
Spearmanrscalculator.xls
Home>Information Systems homework help>Inferential Statistics

Blank Spearman rs

This spreadsheet performs Spearman rank correlation on up to 1000 observations.
If you have fewer than 11 observations, the P values from the equation are inaccurate.
In that case, the P-values are looked up in a table of critical values, and you should use this "P-value from table" instead.
df 0.1 0.05 0.025 0.01 0.005 0.001
Variable 1 Variable 2 rank of x rank of y 3 0.8 0.9 1 1 1.01 1.01
Spearman's rho: 0.000 4 0.657 0.829 0.886 0.943 1 1.01
degrees of freedom: -2 5 0.571 0.714 0.786 0.893 0.929 1
P-value from equation: 0.00E+0 6 0.524 0.643 0.738 0.833 0.881 0.952
P-value from table: 0 7 0.483 0.6 0.7 0.783 0.833 0.917
8 0.455 0.564 0.648 0.745 0.794 0.879
0
3 0 0 0 0 0 0
4 0 0 0 0 0 0
5 0 0 0 0 0 0
6 0 0 0 0 0 0
7 0 0 0 0 0 0
8 0 0 0 0 0 0
0
3 0 0 0 0 0 0
4 0 0 0 0 0 0
5 0 0 0 0 0 0
6 0 0 0 0 0 0
7 0 0 0 0 0 0
8 0 0 0 0 0 0
0
0
0
&F
Page &P

Blank Spearman rs
Variable 1
Variable 2

statspearman.xls

This spreadsheet performs Spearman rank correlation on up to 1000 observations.
If you have fewer than 11 observations, the P values from the equation are inaccurate.
In that case, the P-values are looked up in a table of critical values, and you should use this "P-value from table" instead.
df 0.1 0.05 0.025 0.01 0.005 0.001
Variable 1 Variable 2 rank of x rank of y 3 0.8 0.9 1 1 1.01 1.01
7 8 4 3 Spearman's rho: 0.891 4 0.657 0.829 0.886 0.943 1 1.01
10 10 1 1 degrees of freedom: 8 5 0.571 0.714 0.786 0.893 0.929 1
3 5 8 6 P-value from equation: 0.000542 6 0.524 0.643 0.738 0.833 0.881 0.952
9 9 2 2 P-value from table: P<0.001 7 0.483 0.6 0.7 0.783 0.833 0.917
1 1 10 10 8 0.455 0.564 0.648 0.745 0.794 0.879
8 7 3 4
5 3 6 8 0
2 4 9 7 3 0 0 0 0 0 0
6 6 5 5 4 0 0 0 0 0 0
4 2 7 9 5 0 0 0 0 0 0
6 0 0 0 0 0 0
7 0 0 0 0 0 0
8 0 0 0 0 0 0
0.001
3 0 0 0 0 0 0
4 0 0 0 0 0 0
5 0 0 0 0 0 0
6 0 0 0 0 0 0
7 0 0 0 0 0 0
8 0.1 0.05 0.025 0.01 0.005 0.001
0
0
P<0.001
&F
Page &P

statspearman.xls
Variable 1
Variable 2