Sample Workbook to Calculate Spearman Correla
The workbook shows how to calculate the Spearman rank correlation coefficient in Excel by using the CORREL function a
Author
Last update
Tutorial URL
Examples:
• Calculate Spearman correlation coefficient with CORREL function
• Find Spearman correlation coefficient with traditional formula
• Do Spearman correlation using a graph
mple Workbook to Calculate Spearman Correlation in Exc
rkbook shows how to calculate the Spearman rank correlation coefficient in Excel by using the CORREL function and traditional formula.
Ablebits.com
19-Dec-18
How to do Spearman correlation in Excel
e Spearman correlation coefficient with CORREL function
earman correlation coefficient with traditional formula
arman correlation using a graph
Physical activity Blood presure Physical activity Blood presure
Name (min) (mm Hg) (rank) (rank)
Alan 60 118 1 9
Carl 55 117 2 10
David 25 120 8 7
Don 50 121 3 6
John 40 119 5 8
Matt 45 122 4 5
Mike 35 123 6 4
Neal 10 124 10 3
Rick 30 125 7 2
Rob 20 126 9 1
Spearman correlation -0.757575757576
Physical activity Blood presure Physical activity Blood presure
d d2
Name (min) (mm Hg) (rank) (rank)
Alan 60 118 1 9 -8 64
Carl 55 117 2 10 -8 64
David 25 120 8 7 1 1
Don 50 121 3 6 -3 9
John 40 119 5 8 -3 9
Matt 45 122 4 5 -1 1
Mike 35 123 6 4 2 4
Neal 10 124 10 3 7 49
Rick 30 125 7 2 5 25
Rob 20 126 9 1 8 64
290
Spearman correlation -0.757575757576
Physical activity Blood presure Physical activity Blood presure
Name (min) (mm Hg) (rank) (rank)
Alan 60 118 1 9
Carl 55 117 2 10
David 25 120 8 7
Don 50 121 3 6
John 40 119 5 8
Matt 45 122 4 5
Mike 35 123 6 4
Neal 10 124 10 3
Rick 30 125 7 2
Rob 20 126 9 1
Spearman correlation 0.757575757598
Correlation chart
12
10
8 R² = 0.573921028466483
0
0 2 4 6 8 10 12
