Subject: Business Statistics
The most accurate method for determining the correlation between variables that have rank or order is using Sparkman's rank correlation coefficient.
Ranks are the orders or priorities that are given in accordance with their importance or position. When the data are statistically measured, Karl Pearson's correlation coefficient is particularly helpful. Some characteristics, such as beauty, wisdom, intelligence, honesty, etc., cannot be accurately quantified. Rankings or other types of ratings can be used to quantify these aspects. The degree of association between the two sets of ranks is then referred to as the rank correlation. There is a method that may be used in these circumstances to study the link between these features. The rank correlation coefficient is the name of it. Charles Edward Sparkman, a British psychologist, created this technique in 1904.
Rank correlation is the degree of association between two variables when data are arranged in order or in ranks.
The Sparkman rank correlation coefficient is a measure of rank correlation created by Sparkman. Rs is typically used to indicate it. The formula for the Sparkman's rank correlation coefficient, which measures the strength of the association between different ranks or grades of two characteristics, is as follows:
rs = 1 - \{\frac{6.∑d2}{n(n2 – 1)}\}
where,
d= R1 – R2 = difference of rank between paired items
R1= rank of first attribute
R2= rank of second attribute
n= number of paired observations.
Properties of Rank Correlation Coefficient
For example,
R1 |
R2 |
d=R1-R2 |
d2 |
1 |
1 |
0 |
0 |
2 |
2 |
0 |
0 |
3 |
3 |
0 |
0 |
4 |
4 |
0 |
0 |
5 |
5 |
0 |
0 |
∑d=0 |
∑d2=0 |
rs = 1 - \{\frac{6.∑d2}{n(n2 – 1)}\}
rs = 1 - \{\frac{6.0}{5(25 – 1)}\}
=1-0
=1
R1 |
R2 |
d=R1-R2 |
d2 |
1 |
5 |
-4 |
16 |
2 |
4 |
-2 |
4 |
3 |
3 |
0 |
0 |
4 |
2 |
2 |
4 |
5 |
1 |
4 |
16 |
∑d=0 |
∑d2=40 |
rs = 1 - \{\frac{6.∑d2}{n(n2 – 1)}\}
=1 - \{\frac{6.40}{5(25 – 1)}\}
=1-2
=-1
When determining Sparkman's rank correlation coefficient, there are three scenarios to consider:
Case(I): when actual ranks are given
The following measures must be taken after the actual ranks are announced:
rs = 1 - \{\frac{6.∑d2}{n(n2 – 1)}\}
Example:
Following is a ranking of the top ten industries in one state based on profit and working capital for the year:
Industry: |
A |
B |
C |
D |
E |
F |
G |
H |
I |
J |
Profit rank: |
1 |
2 |
3 |
4 |
5 |
6 |
7 |
8 |
9 |
10 |
Working capital rank |
3 |
2 |
5 |
1 |
4 |
6 |
9 |
10 |
8 |
7 |
Solution:
Ranks are assigned here. We can calculate rank correlation coefficient using Sparkman's rank correlation coefficient formula, which is as follows:
rs = 1 - \{\frac{6.∑d2}{n(n2 – 1)}\}
Computation of Rank Correlation Coefficient
Industry |
Profit rank (R1) |
Working capital rank (R2) |
d=R1 - R2 |
d2 |
A |
1 |
3 |
-2 |
4 |
B |
2 |
2 |
0 |
0 |
C |
3 |
5 |
-2 |
4 |
D |
4 |
1 |
3 |
9 |
E |
5 |
4 |
1 |
1 |
F |
6 |
6 |
0 |
0 |
G |
7 |
9 |
-2 |
4 |
H |
8 |
10 |
-2 |
4 |
I |
9 |
8 |
1 |
1 |
J |
10 |
7 |
3 |
9 |
n=10 |
n=10 |
∑d=0 |
∑d2=36 |
The rank correlation coefficient is calculated using:
rs = 1 - \{\frac{6.∑d2}{n(n2 – 1)}\}
= 1 - \{\frac{6.36}{10(100 – 1)}\}
=1- \{\frac{216}{990}\}
=1- 0.2182
=0.782
Case(II): when ranks are not given
It will be necessary to assign the ranks when the real data for the variables but not the rankings are provided. The formula for computing the rank correlation coefficient, which is given by Sparkman, can be used to assign ranks by taking either the highest value as 1, the second highest value as 2, and so on, or the lowest value as 1, the lowest value as 2, and so on.
rs = 1 - \{\frac{6.∑d2}{n(n2 – 1)}\}
Example:
Using the data below, determine the Sparkman's rank correlation coefficient between the cost of advertising (in thousand rupees) and sales (in lakh rupees).
Advertisement cost (in thousand Rs.) |
39 |
65 |
62 |
90 |
82 |
75 |
25 |
98 |
36 |
78 |
Sales (in lakhs Rs.) |
47 |
53 |
58 |
86 |
62 |
68 |
60 |
91 |
51 |
84 |
Solution:
The problem does not assign ranks. In all scenarios, we must give ranks beginning with the smaller or larger amount. Let's order from highest value to lowest. Let X and Y represent, respectively, the advertising expense (in thousands of rupees) and the sales (in lakhs of rupees).
Table for calculation of rank correlation coefficient
X |
Y |
Rank of X (R1) |
rank of Y (R2) |
d=R1 – R2 |
d2 |
39 |
47 |
8 |
10 |
-2 |
4 |
65 |
53 |
6 |
8 |
-2 |
4 |
62 |
58 |
7 |
7 |
0 |
0 |
90 |
86 |
2 |
2 |
0 |
0 |
82 |
62 |
3 |
5 |
-2 |
0 |
75 |
68 |
5 |
4 |
1 |
1 |
25 |
60 |
10 |
6 |
4 |
16 |
98 |
91 |
1 |
1 |
0 |
0 |
36 |
51 |
9 |
9 |
0 |
0 |
78 |
84 |
4 |
3 |
1 |
1 |
n = 10 |
∑d=0 |
∑d2=30 |
Now ,
rs = 1 - \{\frac{6.∑d2}{n(n2 – 1)}\}
= 1 - \{\frac{6.30}{10(100 – 1)}\}
=0.82
Case(III): when the ranks are repeated(tied)
A common rank is assigned to all such repeated items when more than one item in a series has the same value for r. The next item will receive the rank immediately after them. These common ranks are the arithmetic means of the ranks that these objects would have received if they were different from one another. For instance, if the third and fourth items are equal in value, the third and fourth items' ranks are each 3.5, and the next item's rank is 5. By adding a tie correlation factor, frac(m(m2-1)12), to d2, the general formula (described above) for computing rank correlation coefficient is modified for this situation. When many items have the same value, the formula for computing the Sparkman rank correlation coefficient is as follows:
rs=1- \{\frac{6[∑d2 + \{\frac{m1(m12-1)}{12}\} + \{\frac{m2(m22-1)}{12}\} +………}{n(n2-1}\}
Where, m1,m2,……etc. be the number of times that an item is repeated.
Example:
Ten candidates were examined by a company. based on the applicants' scores in the statistics and accounting exams. Do the rank correlation coefficient calculation.
Applicants: |
A |
B |
C |
D |
E |
F |
G |
H |
I |
J |
Marks in statistics |
38 |
41 |
68 |
41 |
38 |
55 |
85 |
81 |
28 |
41 |
Marks in accountancy |
48 |
39 |
38 |
36 |
58 |
61 |
72 |
83 |
61 |
82 |
Solution:
Let R1 stand for the statistics grade rank and R2 for the accounting grade rank.
Computation of rank correlation coefficient
Marks in statistics |
Marks in accountancy |
R1 |
R2 |
d=R1 – R2 |
d2 |
38 |
48 |
8.5 |
7 |
1.5 |
2.25 |
41 |
39 |
6 |
8 |
-2 |
4 |
68 |
38 |
3 |
9 |
-6 |
36 |
41 |
36 |
6 |
10 |
-4 |
16 |
38 |
58 |
8.5 |
6 |
2.5 |
6.25 |
55 |
61 |
4 |
4.5 |
0.5 |
0.25 |
85 |
72 |
1 |
3 |
-2 |
4 |
81 |
83 |
2 |
1 |
1 |
1 |
28 |
61 |
10 |
4.5 |
5.5 |
30.25 |
41 |
82 |
6 |
2 |
4 |
16 |
∑d=0 |
∑d2=83.00 |
Here, n= 10, m1= 3, m2=2, m3=2
Rank correlation coefficient
rs=1- \{\frac{6[∑d2 + \{\frac{m1(m12-1)}{12}\} + \{\frac{m2(m22-1)}{12}\} +………}{n(n2-1}\}
=1- \{\frac{6[83 + \{\frac{3(32-1)}{12}\} + \{\frac{2(22-1)}{12}\} + \{\frac{3(32-1)}{12}\} }{10(102-1}\}
=1- \{\frac{6*30}{990}\}
=1-0.1818
=0.82
Refrence
Chaudary, A.K. (2061).Business statistics. kathmandu:Bhundipuran Prakshan
Dhakal Bashanta (2014).Business Statistics,Buddha academic publisher
Sthapit, Azaya Bikram(2006),Business Statistics,Asmita publication
© 2021 Saralmind. All Rights Reserved.