Business Statistics Project

Introduction

The Royal Challengers Bangalore is

a franchise cricket team based in
Bangalore, Karnataka that competes
in the Indian Premier League, the top
flight of Indian Cricket. Founded in
2008 by United Spirits and named
after Royal Challenge, a liquor brand.
The club’s home ground is at the M.
Chinnaswamy Stadium, with a
capacity to occupy 35000 people.
The team has been led by Virat Kohli,
under the guidance of Coach Simon Katich. The club adopted
their red and golden yellow home shirts in 2008, they have an
alternative kit ( Go green initiative), and in 2021, they
launched another kit in Blue inorder to raise money for
collection of oxygen tanks during crises in India.
Kolkata Knight Riders are a cricket franchise representing the
city of Kolkata in IPL. This team is owned by actor Shah Rukh
Khan, actress Juhi
Chawala and her
husband Jay Mehta. The
Knight Riders have the
longest winning streak in
T20. Their theme is
korbo, lorbo, jeetbo re.
The knight riders brand
value was estimated to
be $104 million in 2018 and in 2019 its value was estimated at
$88 million.The was bought for a price of $75.09 million.
Sourav Ganguly was named the icon player for the team. The
Kolkata knight riders name is a reference to a popular 1980s
American television series named Knight Rider.
RCB and KKR have played 28 matches head to head in which
KKR have won 15 and RCB 13. Both the teams have
performed exceptionally well in the past seasons with KKR’s
Avg Runs 158.4 and RCB’s Avg Runs 151.7. Both teams
have their own fan following which helps the players to cheer
up and perform better.

Royal Challengers Bangalore vs Kolkata Knight Riders

Real Time Data

Team RCB KKR

Won 13 15
Lost 15 13
Draw 0 0
Highest Score 213 222
Lowest Score 49 84
List of Matches Played

Indian Premier League 2020

Oct 22

KKR 8/84 (20) V RCB 2/85 (13.3)

Oct 13

RCB 2/194 (20) V KKR 9/112 (20)

Apr 20

KKR 5/203 (20) V RCB 4/213 (20)

Apr 6

RCB 3/205 (20) V KKR 5/206 (19.1)

Indian Premier League 2018

Apr 30

RCB 4/175 (20) V KKR 4/176 (19.1)

Apr 9

KKR 6/177 (18.5) V RCB 7/176 (20)

Indian Premier League 2017

May 7

RCB 6/158 (20) V KKR 4/159 (15.1)

Apr 24

KKR 131 (19.3) V RCB 49 (9.4)

Indian Premier League 2016

May 16

KKR

5/183 (20) V RCB 1/186 (18.4)

May 2

RCB 7/185 (20) V KKR 5/189 (19.1)

Indian Premier League 2015

May 2

RCB 3/115 (9.4) V KKR 4/111 (10)

Apr 11

KKR 6/177 (20) V RCB 7/179 (19)

Indian Premier League 2014

May 28

KKR 4/195 (20) V RCB 5/165 (20)

Apr 24

RCB 5/148 (20) V KKR 7/150 (20)

Indian Premier League 2013

May 12

KKR 5/116 (19.2) V RCB 9/115 (20)

Apr 11

RCB 2/158 (17.3) V KKR 8/154 (20)

Indian Premier League 2012

Apr 28
KKR 4/190 (20) V RCB 6/143 (20)

Apr 10

RCB 9/123 (20) V KKR 8/165 (20)

Sep 29

RCB 9/169 (20) V KKR 1/171 (17.3)

Indian Premier League 2011

May 14

RCB 6/105 (12.3) V KKR 4/89 (13)

Apr 22

KKR 5/171 (20) V RCB 1/175 (18.1)

Indian Premier League 2009-10

Apr 10

RCB 3/162 (17.1) V KKR 9/160 (20)

Mar 14

KKR 3/136 (19.2) V RCB 7/135 (20)

Indian Premier League 2009

May 12

RCB 4/176 (19.2) V KKR 4/173 (20)

Apr 29

RCB 5/143 (19.5) V KKR 6/139 (20)

Indian Premier League 2007-08

May 8

KKR 7/129 (16) V RCB 4/124 (16)

Apr 18

RCB 82 (15.1) V KKR 3/222 (20)

 DATA ANALYSIS AND CALCULATIONS FOR
MEASURES OF VARIABILITY

MEAN -
KKR

Class Frequency

84 - 107 3

107- 130 4

130- 153 6

153 - 176 5

176 - 199 7
199 - 222 3

CLAS FREQ MID D= F *d cf

S UENC VALU x-a/h
Y (f) E (x) =

x-164.
5/23

84 - 3 95.5 -3 -9 3
107

107- 4 118.5 -2 -8 7
130

130- 6 141.5 -1 -6 13
153

153 - 5 164.5 0 0 18
176

176 - 7 187.5 1 7 25
199

199 - 3 210.5 2 6 28
222

RCB

Class Frequency

49 – 72 3

72-95 4

95-119 6

119-143 5

143-166 7

166-189 3

189- 213 2
CLASS FREQUEN MID D = x-a/h F *d Cf
CY VALUE =
(x)

x-130.5/2
3

49 – 72 3 60.5 -3 -9 3

72-95 4 83.5 -2 -8 7

95-119 6 106.5 -1 -6 13

119-143 5 130.5 0 0 18

143-166 7 154.5 1 7 25

166-189 3 177.5 2 6 28

189- 213 2 200.5 3 6 30

MEDIAN:
RCB

The median class is = 157 -172

Lower boundary point of median class = 157
Total frequency = 29
Cumulative frequency = 13
Frequency of the median class = 9
Class length of median class = 15
Median = 157 + 14.5-13 / 9 x 15
= 157 +1.5/9 x 15
= 157 +2.5
= 159.5
KKR
The median class is = 154 - 169
Lower boundary point of median class = 154
Total frequency = 29
Cumulative frequency = 12
Frequency of the median class = -9
Class length of median class = -15
Median = 154 + 14.5-12 / 9 x 15
= 157 +2.5/9 x 15
= 157 +4.1667
= 158.1667
MODE:
RCB
HIGHEST FREQUENCY – 9
The mode class is 157 – 172
Lower boundary point = 157
Frequency of mode class = 9
Frequency of preceding class = 8
Frequency of succeeding class = 4
Class length of mode class = 15
Z = 157 (9-8/2.9-8-4).15
= 157+(1/6).15
= 157+2.5
 =159.5

KKR
HIGHEST FREQUENCY – 9
The mode class is 154 – 169
Lower boundary point = 154
Frequency of mode class = 9
Frequency of preceding class = 5
Frequency of succeeding cla
ss = 5
Class length of mode class = 15
Z = 154 (9-5/2.9-5-5).15
= 154+(4/8).15
= 154+7.5
 =161.5

STANDARD DEVIATION-

ROYAL CHALLENGERS BANGALORE

Class Intervals id-point Frequency x̄ x-x̄ 2 2

(x-x̄) f(x-x̄)
∑fx)
x f

120 115 2 158.7 -43.7 1917.5 3835.1

130 125 0 158.7 -33.7 1141.7 0

140 135 2 158.7 -23.7 565.9 1131.9

150 145 8 158.7 -13.7 190.1 1521.3

160 155 4 158.7 -3.7 14.3 57.4

170 165 4 158.7 6.2 38.5 154.2

180 175 4 158.7 16.2 262.7 1051

190 185 3 158.7 26.2 686.1 2060.8

200 195 0 158.7 36.2 1311.1 0

210 205 2 158.7 46.2 2135.3 4270.7

TAL 29 14082.7

Standard Deviation, σ = √∑ f(x-x̄)2/N

= √14082.7/29

= 22.03

KOLKATA KNIGHT RIDERS

Class Mid- Frequen ȳ y-ȳ (y-ȳ)2 f(y-ȳ)2

Interval point cy
s
 y f (∑f
y)

70-80 75 1 152. -77. 5966 5966

2 2

80-90 85 0 152. -67. 4521.2 0

2 2

90-100 95 0 152. -57. 3276.4 0

2 2

100-110 105 1 152. -47. 2231.6 2231.6

2 2

110-120 115 2 152. -37. 1386.8 2773.6

2 2

120-130 125 1 152. -27. 742 742

2 2

130-140 135 3 152. -17. 297.2 891.6

2 2

140-150 145 3 152. -7.2 52.4 157.2

2 4

150-160 155 5 152. 2.7 7.6 38

2

160-170 165 7 152. 12.7 162.8 1139.7

2
 170-180 175 2 152. 22.7 518 1036
2

180-190 185 3 152. 32.7 1073.2 3219.6

2

190-200 195 0 152. 42.7 1828.4 0

2

TOTAL 29 20979.3

Standard Deviation, σ = √∑ f(y-ȳ)2/N

= √20979.3/29

= 26.8

CORRELATION-
Let runs scored by RCB be denoted by ‘x’ and runs scored by KKR denoted by ‘y’

x y = x-x̄ = x- y = y-ȳ = dx2 dy2 dxdy

158.6 y-152.7

116 166 -42.6 13.2 1819 176.3 -566.3

162 114 3.3 -38.7 11.2 1499.2 -129.7

170 133 11.3 -19.7 128.8 388.8 -223.8

155 109 -3.6 -43.7 13.3 1911.4 159.5

132 148 -26.6 -4.7 710.2 22.2 125.7

149 131 -9.6 -21.7 93.1 471.7 209.5

165 169 6.3 16.2 40.3 265 103.3

170 169 11.3 16.2 128.8 265 184.7

183 189 24.3 36.2 592.9 1316.2 883.4

159 158 0.3 5.2 0.12 27.8 1.8

187 162 28.3 9.2 803.7 86.1 263

202 142 43.3 -10.7 1879.2 114.9 -464.7

141 160 -17.6 7.2 311.5 52.9 -128.4

157 176 -1.6 23.2 2.7 541.9 -38.4

173 125 14.3 -27.7 205.9 768.3 -397.7

148 79 -10.6 -73.7 113.4 5434.6 785.1

139 139 -19.6 -13.7 386.1 188.2 269.5

144 173 -14.6 20.2 214.6 411.2 -297.1

148 187 -10.6 34.2 113.4 1175.1 -365

 115 112 -43.6 -40.7 1905.3 1658.1 1777.4

174 156 15.3 3.2 235.6 10.7 50.3

149 158 -9.6 5.2 93.1 27.8 -50.9

164 168 5.3 15.2 28.6 233.4 81.7

181 165 22.3 12.2 499.5 150.7 274.4

165 180 6.3 27.2 40.3 744.1 173.2

146 146 -12.6 -6.7 160 45.1 85

147 151 -11.6 -1.7 135.7 2.9 20

202 208 43.3 55.2 1879.2 3055.8 2396.3

158 156 -0.6 3.2 0.42 10.7584 -2.1

= 4601 ∑y=4429 ∑dx=0.15 ∑dy=0.12 ∑dx2=12546.5 ∑dy2=21057.7 ∑dxdy=5180.2

x̄= ∑x/n = 4601/29= 158.6

ȳ= ∑y/n = 4429/29= 152.7r = ∑dxdy/√(∑dx2*∑dy2) = 5180.2/16254.3 = 0.318

Data analysis:
 THANK YOU!
Group Members:

Mihir Kumar - 1348

Twesh Raj Sharma 1386

Dibrujission P Hazarika - 1331

Bhavyam Dutt - 1325