Name: Janees Sara Buttar
Reg no# : 50972
Subject: Business Analytics
Submitted to: Sir Monis Ahmed Thakur
Q1. Use the following data set of 6 observations relating to 6 variables to construct a similarity
matrix by:
⦁ Matching Coefficient method.
⦁ Jaccard’s Coefficient method.
Observation A B C D E F
1 1 1 0 0 1 0
2 1 1 1 1 0 0
3 1 0 1 0 0 0
4 0 1 0 0 1 1
5 0 0 0 1 1 1
6 0 0 0 1 0 1
Answer (A)
Matching Coefficient method.
For Row 1 and Row 2
M00=1
M11=2
M01=2
M10=1
SMC= 1+2 / 1+2+1+2= 3/6 = 0.5
Now,
For Row 1 and Row 3
M00=2
M11=1
M01=1
M10=2
SMC= 2+1/ 2+1+2+1= 3/6 = 0.5
Now,
For Row 1 and Row 4
M00=2
M11=2
M01=1
M10=1
SMC= 2+2/ 2+1+1+2= 4/6 = 0.66
Now,
For Row 1 and Row 5
M00=1
M11=1
M01=2
M10=2
SMC= 1+1/ 1+2+2+1= 2/6 = 0.3
Now,
For Row 1 and Row 6
M00=1
M11=0
M01=2
M10=3
SMC= 1+0/ 1+2+3+0 = 1/6 = 0.16
Now,
For Row 2 and Row 3
M00=2
M11=2
M01=0
M10=2
SMC= 2+2/ 2+0+2+2 = 4/6 = 0.66
Now,
For Row 2 and Row 4
M00=0
M11=1
M01=2
M10=3
SMC=0+1 / 2+3+1+ = 1/6 = 0.16
Now,
For Row 2 and Row 5
M00=0
M11=1
M01=2
M10=3
SMC=0+1 / 2+3+1+ = 1/6 = 0.16
Now,
For Row 2 and Row 6
M00=1
M11=1
M01=1
M10=3
SMC=1 +1 /1+1+3+1 = 2/6 = 0.33
Now,
For Row 3 and Row 4
M00=1
M11=0
M01=3
M10=2
SMC=1 +0 /1+3+2+0 = 1/6 = 0.16
Now,
For Row 3 and Row 5
M00=1
M11=0
M01=3
M10=2
SMC=1 +0 /1+3+2+0 = 1/6 = 0.16
Now,
For Row 3 and Row 6
M00=2
M11=0
M01=2
M10=2
SMC=2 +0 /2+2+2+0 = 2/6 = 0.33
Now,
For Row 4 and Row 5
M00=2
M11=2
M01=1
M10=1
SMC=2 +2 /2+1+1+2 = 4/6 = 0.66
Now,
For Row 4 and Row 6
M00=2
M11=1
M01=1
M10=2
SMC=2 +1 /2+1+2+1 = 3/6 = 0.5
Now,
For Row 5 and Row 6
M00=3
M11=2
M01=0
M10=1
SMC=3+2 /3+0+1+2 = 0.8
SMC
1 2 3 4 5 6
1 1 0.5 0.5 0.6 0.3 0.16
2 0.5 1 0.66 0.16 0.16 0.33
3 0.5 0.66 1 0.16 0.16 0.33
4 0.6 0.16 0.16 1 0.66 0.5
5 0.3 0.16 0.16 0.66 1 0.8
6 0.16 0.33 0.33 0.5 0.8 1
Answer (B)
Jaccard’s Coefficient method.
For Row 1 and 2
Total No. of variables = 6
Matching Non- zero values = 2
Matching zero values = 1
=Matching non zero values/(Total no of Variable)- (Matching zero Values)
=2/6-1
=⅖ = 0.4
For Row 1 and 3
Total No. of variables = 6
Matching Non- zero values = 1
Matching zero values = 2
=1/6 -2
=1/4 = 0.25
For Row 1 and 4
Total No. of variables = 6
Matching Non- zero values = 2
Matching zero values = 2
=2/6 -2
=2/4 = 0.5
For Row 1 and 5
Total No. of variables = 6
Matching Non- zero values = 1
Matching zero values = 1
=1/ 6-1
=1/5 = 0.2
For Row 1 and 6
Total No. of variables = 6
Matching Non- zero values = 0
Matching zero values = 1
=0/6 -1
=0
For Row 2 and 3
Total No. of variables = 6
Matching Non- zero values = 2
Matching zero values =2
=2/6 -2
=2/4 = 0.5
For Row 2 and 4
Total No. of variables = 6
Matching Non- zero values = 1
Matching zero values = 0
=1/6 -0
=1/6 = 0.16
For Row 2 and 5
Total No. of variables = 6
Matching Non- zero values = 1
Matching zero values = 0
=1/6 -0
=1/6 = 0.16
For Row 2 and 6
Total No. of variables = 6
Matching Non- zero values = 1
Matching zero values = 1
=1/6-1
=1/5= 0.2
For Row 3 and 4
Total No. of variables =6
Matching Non- zero values = 0
Matching zero values = 1
=0/6 -1
=0
For Row 3 and 5
Total No. of variables = 6
Matching Non- zero values = 0
Matching zero values = 1
=0/6 -1
=0
For Row 3 and 6
Total No. of variables = 6
Matching Non- zero values = 0
Matching zero values = 2
=0/6 -2
=0
For Row 4 and 5
Total No. of variables = 6
Matching Non- zero values = 2
Matching zero values = 2
=2/6 -2
=2/ 4= 0.5
For Row 4 and 6
Total No. of variables = 6
Matching Non- zero values = 1
Matching zero values = 2
=1/6 -2
=1/4 = 0.25
For Row 5 and 6
Total No. of variables = 6
Matching Non- zero values = 2
Matching zero values = 3
=2/ 6-3
=2/3 = 0.66
Jaccard’s Coefficient
1 2 3 4 5 6
1 1 0.4 0.25 0.5 0.2 0
2 0.4 1 0.5 0.16 0.16 0.2
3 0.25 0.5 1 0 0 0
4 0.5 0.16 0 1 0.5 0.25
5 0.2 0.16 0 0.5 1 0.66
6 0 0.2 0 0.25 0.66 1
