Cricket query

Least consistent batters

The average (mean) is one way of summarising a batter's career. Another is the median, which shows the score that they exceed half the time, and fail to reach half the time. If a genuine batter (defined here as averaging at least 25 with at least 1,000 runs) has a low ratio of median to average, then that suggests they were inconsistent and relied on big scores when they did get in. The shorter the format, the less relevant this is, and the higher the ratio will be. Change ASC to DESC in the SQL to see the most consistent batters by this measure.

SQL

Format:

Gender:

(Help)

Men's Test

player_id player median average total ratio
p6943 MJ North 10 35.48 1,171 0.28
p19445 RT Robinson 12 36.39 1,601 0.33
p8535 DL Amiss 16 46.31 3,612 0.35
p30009 VG Kambli 19 54.20 1,084 0.35
p698189 PWA Mulder 14 38.43 1,153 0.36
p40250 Fawad Alam 14.50 38.88 1,011 0.37
p50809 MG Vandort 14 36.90 1,144 0.38
p922941 Abdullah Shafique 15 38.56 1,504 0.39
p326632 JA Burns 14.50 36.97 1,442 0.39
p5124 R Edwards 16 40.38 1,171 0.40
p40551 Ijaz Ahmed 15 37.67 3,315 0.40
p30045 KD Karthik 10 25 1,025 0.40
p49623 RS Madugalle 12 29.40 1,029 0.41
p52941 OG Smith 13 31.69 1,331 0.41
p38246 JF Reid 19 46.29 1,296 0.41
p398438 MA Agarwal 17 41.33 1,488 0.41
p45039 GA Faulkner 17 40.79 1,754 0.42
p8532 LEG Ames 17 40.57 2,434 0.42
p4242 JW Burke 14.50 34.59 1,280 0.42
p48124 MS Atapattu 16.50 39.02 5,502 0.42

213ms

Women's Test

player_id player median average total ratio
p53715 SC Taylor 18 41.20 1,030 0.44
p53913 S Agarwal 24 50.45 1,110 0.48
p53458 KL Rolton 27 55.67 1,002 0.49
p54298 DA Hockley 33 52.04 1,301 0.63
p53696 CM Edwards 28 44.11 1,676 0.63
p53785 CA Hodges 27 40.14 1,164 0.67
p53891 JA Brittin 35 49.62 1,935 0.71
p53887 R Heyhoe-Flint 33.50 45.54 1,594 0.74
p53731 E Bakewell 45 59.89 1,078 0.75
p53885 ME Maclagan 34 41.96 1,007 0.81

12ms

Men's ODI

player_id player median average total ratio
p45797 JM Kemp 11 31.50 1,512 0.35
p974087 Rahmanullah Gurbaz 14 37.19 1,785 0.38
p270484 JP Faulkner 13 34.40 1,032 0.38
p461281 PL Mommsen 12 30.97 1,115 0.39
p6995 SP O'Donnell 10 25.35 1,242 0.39
p52347 AL Logie 12 28.96 2,809 0.41
p39013 Asif Mujtaba 11 26.05 1,068 0.42
p25430 NFI McCallum 12 27.83 1,002 0.43
p921509 Ibrahim Zadran 22 50.18 1,656 0.44
p290716 KM Jadhav 18.50 42.09 1,389 0.44
p52917 D Ramdin 11 25 2,200 0.44
p315232 Asif Khan 17 38.48 1,270 0.44
p24249 EC Joyce 17 38 2,622 0.45
p20286 VS Solanki 12 26.76 1,097 0.45
p819429 Azmatullah Omarzai 22 48.95 1,028 0.45
p23797 A Bagai 17 37.77 1,964 0.45
p303423 A Balbirnie 14.50 32 3,264 0.45
p46774 SM Pollock 12 26.46 3,519 0.45
p9187 G Boycott 16.50 36.07 1,082 0.46
p45821 L Klusener 19 41.10 3,576 0.46

238ms

Women's ODI

player_id player median average total ratio
p362356 Sidra Ameen 12 29.09 1,978 0.41
p53633 LJ Poulton 11 25.20 1,033 0.44
p274958 KT Perkins 13 27.23 1,198 0.48
p231305 RH Priest 14 28.23 1,694 0.50
p53477 DA Annetts 21 41.70 1,126 0.50
p1026403 L Paul 13 25.80 1,161 0.50
p351836 M Kapp 17.50 34.22 3,182 0.51
p803971 AC Kerr 22 42.49 2,167 0.52
p453370 CL Tryon 14 26.73 2,112 0.52
p53437 LM Keightley 21 39.85 2,630 0.53
p275487 EA Perry 26 48.69 4,187 0.53
p231740 SFM Devine 17 31.67 3,990 0.54
p53426 ZJ Goss 16 29.70 1,099 0.54
p597811 DB Sharma 20 36.80 2,392 0.54
p53696 CM Edwards 21 38.17 5,992 0.55
p54634 C Brits 16 28.96 1,622 0.55
p54000 J Sharma 17 30.75 2,091 0.55
p54504 NJ Browne 15.50 27.05 2,002 0.57
p276681 T Chetty 16 27.87 2,703 0.57
p515905 Nat Sciver-Brunt 27 46.50 4,092 0.58

71ms

Men's T20I

player_id player median average total ratio
p1217288 Usman Patel 9 25.84 1,111 0.35
p49289 DPMD Jayawardene 13 31.77 1,493 0.41
p1143528 Fiaz Ahmed 16 38.91 1,245 0.41
p28081 MS Dhoni 16 37.60 1,617 0.43
p49764 AD Mathews 12 27.76 1,416 0.43
p48472 TM Dilshan 13 28.19 1,889 0.46
p823339 Ahmer Bin 12 25.83 1,059 0.46
p51880 CH Gayle 13 27.93 1,899 0.47
p34102 RG Sharma 15 32.05 4,231 0.47
p524049 Najibullah Zadran 14 29.52 1,830 0.47
p964521 Sohail Ahmed 21 43.80 1,533 0.48
p267455 RR Patel 14.50 29.90 1,764 0.48
p297433 JM Bairstow 14.50 29.84 1,671 0.49
p519070 MG Erasmus 16 32.31 1,583 0.50
p325012 MP Stoinis 16 31.92 1,245 0.50
p1203898 H Lakov 18 35.23 1,092 0.51
p315232 Asif Khan 15.50 30.21 1,178 0.51
p230559 KA Pollard 13 25.31 1,569 0.51
p230193 MS Wade 13.50 26.13 1,202 0.52
p24598 EJG Morgan 15 28.58 2,458 0.52

131ms

Women's T20I

player_id player median average total ratio
p877469 R Rijke 8 25.58 1,637 0.31
p275487 EA Perry 13.50 30.13 2,109 0.45
p275486 AJ Healy 12 25.45 3,054 0.47
p877473 B de Leede 12 25.36 1,851 0.47
p1116776 NPAN Sakarini 17 35.45 1,028 0.48
p381311 TM McGrath 20 41.63 1,124 0.48
p914677 SJ Bryce 14.50 28.67 1,290 0.51
p944285 N Koncharoenkai 18 35.32 2,543 0.51
p746839 CM Gough 21 40.71 1,262 0.52
p1119581 FO Kibasu 17 31.93 1,405 0.53
p381258 BL Mooney 22 41.22 3,215 0.53
p600731 T Brits 16.50 30.58 1,621 0.54
p486942 N Chantham 18 33.14 2,154 0.54
p358259 HC Knight 14 25.52 2,169 0.55
p515905 Nat Sciver-Brunt 16 28.55 2,826 0.56
p275442 EJ Villani 16 28.52 1,369 0.56
p1126416 ER Oza 18 31.18 2,588 0.58
p355349 DJS Dottin 15.50 26.84 3,624 0.58
p343129 M Hill 15 25.66 1,668 0.58
p803971 AC Kerr 15 25.55 1,252 0.59

83ms

By Sean McGivern