Wednesday, February 9, 2011

Wednesday, January 26, 2011

World Cup is in God's Hand

As world cup cricket 2011 is approaching, some interesting cricket jokes are also on the horizon. Here is one -



I am eagerly looking forward to the opening game of 19th February that will be held in my backyard in Dhaka between Bangladesh and India!

Monday, January 3, 2011

Remaining Not Out In Test Innings

One important quality of a batsman is remaining not out in an innings. It's equivalent to getting out after scoring infinite runs. This is the reason why test batting average is calculated for runs scored in career divided by number of innings played where the batsman was out (i.e. excluded not out innings).So today I while I am watching Sachin and Gambhir batting against South Africa after Sehwag and Dravid got out at 28 for 2 wickets, I am preparing this table. With 2 boundaries in Morkel's over Tendulkar just made sure they crossed half century partnership. I want him to stay not out today to bring India out of this yet another crisis.

Please note the column NO (number of not out innings) and the % (total innings played / number of not out innings * 100).
I am happy to see Tendulkar in the top 5 and not surprised to see Steve Waugh on top.
I am surprised to see Gavaskar hardly chipping in the 25th position while Sehwag and Lara are
at the bottom of the table. This is one area where Bradman performs average with a 12.5%
NO innings (10 out of 80 played).


Player Span Mat  Inns  NO    %   Runs   HS  Ave 100  50 0
SR Waugh (Aus) 1985-2004 168 260 46   17.69   10927 200  51.06 32 50  22
AR Border (Aus) 1978-1994 156 265 44 16.60 11174 205 50.56 27 63 11
JH Kallis (ICC/SA) 1995-2011 145 245 37 15.10 11838   201* 56.91 39 54 10
S Chanderpaul (WI) 1994-2010 129 219 34 15.53 9063   203* 48.98 22 55 13
SR Tendulkar (India) 1989-2011 177 288 31 10.76 14532   248* 56.54 50 59 14
R Dravid (ICC/India) 1996-2011 150 258 30 11.63 12032 270 52.77 31 59 8
VVS Laxman (India) 1996-2011 120 196 30 15.31 7856 281 47.32 16 49 12
RT Ponting (Aus) 1995-2010 152 259 28 10.81 12363 257 53.51 39 56 14
GP Thorpe (Eng) 1993-2005 100 179 28 15.64 6744 200* 44.66 16 39 12
DL Haynes (WI) 1978-1994 116 202 25 12.38 7487 184 42.29 18 39 10
MV Boucher (ICC/SA) 1997-2011 139 195 23 11.79 5257 125 30.56 5 33 17
G Boycott (Eng) 1964-1982 108 193 23 11.92 8114 246* 47.72 22 42 10
Inzamam-ul-Haq (Pak) 1992-2007 120 200 22 11.00 8830 329 49.6 25 46 15
Saleem Malik (Pak) 1982-1999 103 154 22 14.29 5768 237 43.69 15 29 12
DB Vengsarkar (India) 1976-1992 116 185 22 11.89 6868 166 42.13 17 35 15
Javed Miandad (Pak) 1976-1993 124 189 21 11.11 8832 280* 52.57 23 43 6
GS Sobers (WI) 1954-1974 93 160 21 13.13 8032 365* 57.78 26 30 12
AJ Stewart (Eng) 1990-2003 133 235 21 8.94 8463 190 39.54 15 45 14
DC Boon (Aus) 1984-1996 107 190 20 10.53 7422 200 43.65 21 32 16
AC Gilchrist (Aus) 1999-2008 96 137 20 14.60 5570 204* 47.6 17 26 14
GS Chappell (Aus) 1970-1984 87 151 19 12.58 7110 247* 53.86 24 31 12
DI Gower (Eng) 1978-1992 117 204 18 8.82 8231 215 44.25 18 39 7
SC Ganguly (India) 1996-2008 113 188 17 9.04 7212 239 42.17 16 35 13
ME Waugh (Aus) 1991-2002 128 209 17 8.13 8029 153* 41.81 20 47 19
SM Gavaskar (India) 1971-1987 125 214 16 7.48 10122 236* 51.12 34 45 12
CG Greenidge (WI) 1974-1991 108 185 16 8.65 7558 226 44.72 19 34 11
WR Hammond (Eng) 1927-1947 85 140 16 11.43 7249 336* 58.45 22 24 4
N Hussain (Eng) 1990-2004 96 171 16 9.36 5764 207 37.18 14 33 14
MS Atapattu (SL) 1990-2007 90 156 15 9.62 5502 249 39.02 16 17 22
KF Barrington (Eng) 1955-1968 82 131 15 11.45 6806 256 58.67 20 35 5
DCS Compton (Eng) 1937-1957 78 131 15 11.45 5807 278 50.06 17 28 10
MC Cowdrey (Eng) 1954-1975 114 188 15 7.98 7624 182 44.06 22 38 9
CL Hooper (WI) 1987-2002 102 173 15 8.67 5762 233 36.46 13 27 13
L Hutton (Eng) 1937-1955 79 138 15 10.87 6971 364 56.67 19 33 5
N Kapil Dev (India) 1978-1994 131 184 15 8.15 5248 163 31.05 8 27 16
G Kirsten (SA) 1993-2004 101 176 15 8.52 7289 275 45.27 21 34 13
ML Hayden (Aus) 1994-2009 103 184 14 7.61 8625 380 50.73 30 29 14
ST Jayasuriya (SL) 1991-2007 110 188 14 7.45 6973 340 40.07 14 31 15
CH Lloyd (WI) 1966-1985 110 175 14 8.00 7515 242* 46.67 19 39 4
KD Walters (Aus) 1965-1981 74 125 14 11.20 5357 250 48.26 15 33 4
D Jayawardene (SL) 1997-2010 116 190 13 6.84 9527 374 53.82 28 38 11
MA Taylor (Aus) 1989-1999 104 186 13 6.99 7525 334* 43.49 19 40 5
JL Langer (Aus) 1993-2007 105 182 12 6.59 7696 250 45.27 23 30 11
WM Lawry (Aus) 1961-1971 67 123 12 9.76 5234 210 47.15 13 27 6
M Yousuf (Pak) 1998-2010 90 156 12 7.69 7530 223 52.29 24 33 11
A Ranatunga (SL) 1982-2000 93 155 12 7.74 5105 135* 35.69 4 38 12
IVA Richards (WI) 1974-1991 121 182 12 6.59 8540 291 50.23 24 45 10
RB Richardson (WI) 1983-1995 86 146 12 8.22 5949 194 44.39 16 27 8
KC Sangakkara (SL) 2000-2010 94 156 12 7.69 8244 287 57.25 24 34 4
MD Crowe (NZ) 1982-1995 77 131 11 8.40 5444 299 45.36 17 18 9
PA de Silva (SL) 1984-2002 93 159 11 6.92 6361 267 42.97 20 22 7
Zaheer Abbas (Pak) 1969-1985 78 124 11 8.87 5062 274 44.79 12 20 10
DG Bradman (Aus) 1928-1948 52 80 10 12.50 6996 334 99.94 29 13 7
IM Chappell (Aus) 1964-1980 75 136 10 7.35 5345 196 42.42 14 26 11
SP Fleming (NZ) 1994-2008 111 189 10 5.29 7172 274* 40.06 9 46 16
RN Harvey (Aus) 1948-1963 79 137 10 7.30 6149 205 48.41 21 24 7
ME Trescothick (Eng) 2000-2006 76 143 10 6.99 5825 219 43.79 14 29 12
GR Viswanath (India) 1969-1983 91 155 10 6.45 6080 222 41.93 14 35 10
M Azharuddin (India) 1984-2000 99 147 9 6.12 6215 199 45.03 22 21 5
JH Edrich (Eng) 1963-1976 77 127 9 7.09 5138 310* 43.54 12 24 6
GC Smith (ICC/SA) 2002-2011 91 158 9 5.70 7428 277 49.85 22 29 10
MP Vaughan (Eng) 1999-2008 82 147 9 6.12 5719 197 41.44 18 18 9
RR Sarwan (WI) 2000-2009 83 146 8 5.48 5759 291 41.73 15 31 10
Younis Khan (Pak) 2000-2010 65 116 8 6.90 5440 313 50.37 17 21 13
MA Atherton (Eng) 1989-2001 115 212 7 3.30 7728 185* 37.69 16 46 20
HH Gibbs (SA) 1996-2008 90 154 7 4.55 6167 228 41.95 14 26 11
JB Hobbs (Eng) 1908-1930 61 102 7 6.86 5410 211 56.94 15 28 4
MJ Slater (Aus) 1993-2001 74 131 7 5.34 5312 219 42.83 14 21 9
JG Wright (NZ) 1978-1993 82 148 7 4.73 5334 185 37.82 12 23 7
IT Botham (Eng) 1977-1992 102 161 6 3.73 5200 208 33.54 14 22 14
CH Gayle (WI) 2000-2010 91 159 6 3.77 6373 333 41.65 13 33 15
GA Gooch (Eng) 1975-1995 118 215 6 2.79 8900 333 42.58 20 46 13
RB Kanhai (WI) 1957-1974 79 137 6 4.38 6227 256 47.53 15 28 7
BC Lara (ICC/WI) 1990-2006 131 232 6 2.59 11953 400* 52.88 34 48 17
KP Pietersen (Eng) 2005-2011 71 122 6 4.92 5630 227 48.53 17 21 7
V Sehwag (ICC/India) 2001-2011 87 149 6 4.03 7683 319 53.72 22 27 12
AJ Strauss (Eng) 2004-2011 82 146 6 4.11 6024 177 43.02 19 23 12

Saturday, January 1, 2011

Measuring Average Differently: Highest Runs Per Innings Discounting Not Out

Here is another important number in cricket for batsmen with some modifications from me as a new year gift for the readers - highest batting average. The traditional way of measuring batting average is to divide the total career runs scored by the number of innings he played excluding the not out innings. This way we know before getting out, the batsmen scores how many runs on an average. Forget about the Bradman's magical 99.94, then the good batsmen averages around 50 to 60 runs before getting out once. Amongst our current players, Sangakkara, Tendulkar and Kallis are top in this list. You can get a pick of that list from CricInfo in the following URL - http://stats.espncricinfo.com/ci/content/records/282910.html

A few writers tries to say that the high average of Tendulkar is due to his many not out innings and Lara for his reason is in the lower 50s because of only 6 not out innings in his career (and o boy, 3 of them I call recall are 400*, 375* and famous 153*)! Instead they were saying that if you measure runs per test (no matter if the batsmen could play in both innings or one innings) and discount not outs, then Lara is quite ahead. That is a very unfair comparison because Lara played almost in all Tests in both the innings while Tendulkar didn't get a chance to play in the second innings in many Tests. Instead I believe the measurement below I gave (Runs Per Innings) will give the view they wanted to have, how many runs a batsmen score on an average in each innings played without giving any special tribute for remaining not out in any innings. I have taken a minimum of 5000 test runs scored to filter out bolwers and batsmen I am not interested about. Bradman again obviously comes first with 87.45. Apart from him there are only 10 batsmen who are above 50 with the second placed Jack Hobbs at 53.03.

Player  Span  Mat  Inns  NO  Runs  HS  Ave  Runs Per Innings 100 50 0
DG Bradman (Aus)  1928-1948  52 80 10 6996  334 99.94 87.45 29 13 7
JB Hobbs (Eng)  1908-1930  61 102 7 5410  211 56.94 53.03921569 15 28 4
KC Sangakkara (SL)  2000-2010  94 156 12 8244  287 57.25 52.84615385 24 34 4
KF Barrington (Eng)  1955-1968  82 131 15 6806  256 58.67 51.95419847 20 35 5
V Sehwag (ICC/India)  2001-2010  86 148 6 7670  319 54.01 51.82432432 22 27 12
WR Hammond (Eng)  1927-1947  85 140 16 7249  336*  58.45 51.77857143 22 24 4
BC Lara (ICC/WI)  1990-2006  131 232 6 11953  400*  52.88 51.52155172 34 48 17
L Hutton (Eng)  1937-1955  79 138 15 6971   364 56.67 50.51449275 19 33 5
SR Tendulkar (India)  1989-2010  176 288 31 14532  248*  56.54 50.45833333 50 59 14
GS Sobers (WI)  1954-1974  93 160 21 8032  365*  57.78 50.2 26 30 12
DPMD Jayawardene (SL)  1997-2010  116 190 13 9527  374 53.82 50.14210526 28 38 11
Mohammad Yousuf (Pak)  1998-2010  90 156 12 7530  223 52.29 48.26923077 24 33 11
JH Kallis (ICC/SA)  1995-2010  144 244 37 11677  201*  56.41 47.85655738 38 54 10
RT Ponting (Aus)  1995-2010  152 259 28 12363  257 53.51 47.73359073 39 56 14
SM Gavaskar (India)  1971-1987  125 214 16 10122  236*  51.12 47.29906542 34 45 12
GC Smith (ICC/SA)  2002-2010  90 157 9 7422  277 50.14 47.27388535 22 29 10
GS Chappell (Aus)  1970-1984  87 151 19 7110  247*  53.86 47.08609272 24 31 12
IVA Richards (WI)  1974-1991  121 182 12 8540  291 50.23 46.92307692 24 45 10
Younis Khan (Pak)  2000-2010  65 116 8 5440  313 50.37 46.89655172 17 21 13
ML Hayden (Aus)  1994-2009  103 184 14 8625  380 50.73 46.875 30 29 14
R Dravid (ICC/India)  1996-2010  149 257 29 12027  270 52.75 46.79766537 31 59 8
Javed Miandad (Pak)  1976-1993  124 189 21 8832  280*  52.57 46.73015873 23 43 6
KP Pietersen (Eng)  2005-2010  70 122 6 5630  227 48.53 46.14754098 17 21 7
RB Kanhai (WI)  1957-1974  79 137 6 6227  256 47.53 45.45255474 15 28 7
RN Harvey (Aus)  1948-1963  79 137 10 6149  205 48.41 44.88321168 21 24 7
DCS Compton (Eng)  1937-1957  78 131 15 5807  278 50.06 44.32824427 17 28 10
Inzamam-ul-Haq (ICC/Pak)  1992-2007  120 200 22 8830  329 49.6 44.15 25 46 15
CH Lloyd (WI)  1966-1985  110 175 14 7515  242*  46.67 42.94285714 19 39 4
KD Walters (Aus)  1965-1981  74 125 14 5357  250 48.26 42.856 15 33 4
WM Lawry (Aus)  1961-1971  67 123 12 5234  210 47.15 42.55284553 13 27 6
JL Langer (Aus)  1993-2007  105 182 12 7696  250 45.27 42.28571429 23 30 11
M Azharuddin (India)  1984-2000  99 147 9 6215  199 45.03 42.27891156 22 21 5
AR Border (Aus)  1978-1994  156 265 44 11174  205 50.56 42.16603774 27 63 11
G Boycott (Eng)  1964-1982  108 193 23 8114  246*  47.72 42.04145078 22 42 10
SR Waugh (Aus)  1985-2004  168 260 46 10927  200 51.06 42.02692308 32 50 22
MD Crowe (NZ)  1982-1995  77 131 11 5444  299 45.36 41.55725191 17 18 9
G Kirsten (SA)  1993-2004  101 176 15 7289  275 45.27 41.41477273 21 34 13
GA Gooch (Eng)  1975-1995  118 215 6 8900  333 42.58 41.39534884 20 46 13
S Chanderpaul (WI)  1994-2010  129 219 34 9063  203*  48.98 41.38356164 22 55 13
AJ Strauss (Eng)  2004-2010  81 146 6 6024  177 43.02 41.26027397 19 23 12
CG Greenidge (WI)  1974-1991  108 185 16 7558  226 44.72 40.85405405 19 34 11
Zaheer Abbas (Pak)  1969-1985  78 124 11 5062  274 44.79 40.82258065 12 20 10
RB Richardson (WI)  1983-1995  86 146 12 5949  194 44.39 40.74657534 16 27 8
ME Trescothick (Eng)  2000-2006  76 143 10 5825    219 43.79 40.73426573 14 29 12
AC Gilchrist (Aus)  1999-2008  96 137 20 5570  204*  47.6 40.65693431 17 26 14
MC Cowdrey (Eng)  1954-1975  114 188 15 7624  182 44.06 40.55319149 22 38 9
MJ Slater (Aus)  1993-2001  74 131 7 5312  219 42.83 40.54961832 14 21 9
MA Taylor (Aus)  1989-1999  104 186 13 7525  334*  43.49 40.45698925 19 40 5
JH Edrich (Eng)  1963-1976  77 127 9 5138  310*  43.54 40.45669291 12 24 6
DI Gower (Eng)  1978-1992  117 204 18 8231  215 44.25 40.34803922 18 39 7
CH Gayle (WI)  2000-2010  91 159 6 6373    333 41.65 40.08176101 13 33 15
VVS Laxman (India)  1996-2010  119 196 30 7856    281 47.32 40.08163265 16 49 12
HH Gibbs (SA)  1996-2008  90 154 7 6167  228 41.95 40.04545455 14 26 11
PA de Silva (SL)  1984-2002  93 159 11 6361  267 42.97 40.00628931 20 22 7
RR Sarwan (WI)  2000-2009  83 146 8 5759  291 41.73 39.44520548 15 31 10
IM Chappell (Aus)  1964-1980  75 136 10 5345  196 42.42 39.30147059 14 26 11
GR Viswanath (India)  1969-1983  91 155 10 6080  222 41.93 39.22580645 14 35 10
DC Boon (Aus)  1984-1996  107 190 20 7422  200 43.65 39.06315789 21 32 16
MP Vaughan (Eng)  1999-2008  82 147 9 5719  197 41.44 38.9047619 18 18 9
ME Waugh (Aus)  1991-2002  128 209 17 8029  153*  41.81 38.41626794 20 47 19
SC Ganguly (India)  1996-2008  113 188 17 7212  239 42.17 38.36170213 16 35 13
SP Fleming (NZ)  1994-2008  111 189 10 7172  274*  40.06 37.94708995 9 46 16
GP Thorpe (Eng)  1993-2005  100 179 28 6744  200*  44.66 37.67597765 16 39 12
Saleem Malik (Pak)  1982-1999  103 154 22 5768  237 43.69 37.45454545 15 29 12
DB Vengsarkar (India)  1976-1992  116 185 22 6868  166 42.13 37.12432432 17 35 15
ST Jayasuriya (SL)  1991-2007  110 188 14 6973  340 40.07 37.09042553 14 31 15
DL Haynes (WI)  1978-1994  116 202 25 7487  184 42.29 37.06435644 18 39 10
MA Atherton (Eng)  1989-2001  115 212 7 7728  185*  37.69 36.45283019 16 46 20
JG Wright (NZ)  1978-1993  82 148 7 5334  185 37.82 36.04054054 12 23 7
AJ Stewart (Eng)  1990-2003  133 235 21 8463  190 39.54 36.01276596 15 45 14
MS Atapattu (SL)  1990-2007  90 156 15 5502  249 39.02 35.26923077 16 17 22
N Hussain (Eng)  1990-2004  96 171 16 5764  207 37.18 33.70760234 14 33 14
CL Hooper (WI)  1987-2002  102 173 15 5762  233 36.46 33.30635838 13 27 13
A Ranatunga (SL)  1982-2000  93 155 12 5105  135*  35.69 32.93548387 4 38 12
IT Botham (Eng)  1977-1992  102 161 6 5200  208 33.54 32.29813665 14 22 14
N Kapil Dev (India)  1978-1994  131 184 15 5248  163 31.05 28.52173913 8 27 16
MV Boucher (ICC/SA)  1997-2010  138 194 23 5257  125 30.74 27.09793814 5 33 16

Thursday, December 30, 2010

Percentage of Innings Played Before Scoring Half Century (Out)

I was trying to use CricInfo StatsGuru to find out which batsmen in test cricket history have frequently failed to score significant runs before getting out. This will be slightly more interesting as it will not depend on the batsman's career average rather will calculate the percentage of his under-performing innings compared to his career average. For this I have made the following assumptions -

1. The innings where the batsmen scored 0 to 49 (less than a half century) will be considered as not-so-significant contribution to the team total. While it's subjective and not true (probably 0 to 39 makes more sense), I wanted to count half century as an achievement for that particular batsman in an innings irrespective of where his team stands.

2. I am counting only innings where he was out. So if a player remain o not out or 1 not out, that innings should not be counted as a under performing innings while even if he got out scoring 49 runs in a team total of 88, this method will count that innings as an under performing one.

3. I wanted to exclude bowlers who will have lots of scores (in fact most scores) within this range. For this, I believe a bar of setting at least 2000 test runs scored in career will work as a good filter.

4. The percentage will be calculated as, count of (under performing innings / total number of innings played in career) * 100.

5. I wanted to also mention the number of times the batsman got out scoring a duck.

With the assumptions above in mind, I could only reach to an imperfect table below and would like to have your help on figuring this out. I could not figure out a way to put career runs scored and I had to manually enter the career innings numbers from CricInfo. MS Excel helped me do the percentage calculation automatically though but I would like to limit it till 2 digits after decimal. The table below shows players who have at least played enough number of matches that generated at least 90 matches where he under performed. This criteria I set as I couldn't apply option#3 for filtering the results.

Player -           Innings - Career Innings - Percentage - 0 / duck
SK Warne (Aus)        173         199         86.93467337 34
A Kumble (India)      137         173         79.19075145 17
IA Healy (Aus)         140         182         76.92307692 18
N Kapil Dev (India)     140         184         76.08695652 16
MV Boucher (ICC/SA)     138         194         71.13402062 16
MA Atherton (Eng)      149         212         70.28301887 20
AJ Stewart (Eng)      163         235         69.36170213 14
ST Jayasuriya (SL)     130         188         69.14893617 15
GA Gooch (Eng)         145         215         67.44186047 13
DI Gower (Eng)         137         204         67.15686275 7
CA Walsh (WI)         124         185         67.02702703 43
ME Waugh (Aus)         134         209         64.11483254 19
BC Lara (ICC/WI)        147         232         63.36206897 17
SR Waugh (Aus)          159         260         61.15384615 22
S Chanderpaul (WI)      133         219         60.73059361 13
AR Border (Aus)        160         265         60.37735849 11
SM Gavaskar (India)     129         214         60.28037383 12
R Dravid (ICC/India)    151         257         58.75486381 8
SR Tendulkar (India)      168         288         58.33333333 14
RT Ponting (Aus)      151         259         58.3011583 14
JH Kallis (ICC/SA)      140         244         57.37704918 10

So I gave a post in Cricket Fan Forums where I know there are several expert cricket statisticians who can help me. And I got help within a few hours here - http://cricketfansforum.net/showthread.php?p=391099#post391099 from pappubahry. His list is sorted by failure rate (from lower rate to higher) for players with at least 3000 test run. I can now follow the process he mentioned and prepare separate tables for failure rate between 0-9, 0-19, 0-24 and 0-39. Or even 50-99, 100-149, 150-199 etc.

Player                  Mat    Inns      NO    Runs   Ave     ducks    0-49   failure rate  
DG Bradman               52      80      10    6996   99.94       7      36   45.0%
H Sutcliffe              54      84       9    4555   60.73       2      40   47.6%
TT Samaraweera           63      98      17    4395   54.25       7      51   52.0%
KF Barrington            82     131      15    6806   58.67       5      69   52.7%
JB Hobbs                 61     102       7    5410   56.94       4      55   53.9%
KD Walters               74     125      14    5357   48.26       4      69   55.2%
CL Walcott               44      74       7    3798   56.68       1      41   55.4%
ED Weekes                48      81       5    4455   58.61       6      45   55.6%
GS Chappell              87     151      19    7110   53.86      12      85   56.3%
L Hutton                 79     138      15    6971   56.67       5      79   57.2%
JH Kallis               144     244      37   11677   56.41      10     140   57.4%
MEK Hussey               58     101      12    4605   51.74       9      58   57.4%
B Mitchell               42      80       9    3471   48.88       3      46   57.5%
G Gambhir                37      66       5    3077   50.44       4      38   57.6%
DCS Compton              78     131      15    5807   50.06      10      76   58.0%
RT Ponting              152     259      28   12363   53.51      14     151   58.3%
SR Tendulkar            176     288      31   14532   56.54      14     168   58.3%
R Dravid                149     257      29   12027   52.75       8     151   58.8%
A Flower                 63     112      19    4794   51.54       5      66   58.9%
KC Sangakkara            94     156      12    8244   57.25       4      93   59.6%
DR Martyn                67     109      14    4406   46.37       7      65   59.6%
IVA Richards            121     182      12    8540   50.23      10     109   59.9%
GS Sobers                93     160      21    8032   57.78      12      96   60.0%
EH Hendren               51      83       9    3525   47.63       4      50   60.2%
SM Gavaskar             125     214      16   10122   51.12      12     129   60.3%
Javed Miandad           124     189      21    8832   52.57       6     114   60.3%
GP Thorpe               100     179      28    6744   44.66      12     108   60.3%
AR Border               156     265      44   11174   50.56      11     160   60.4%
Saeed Anwar              55      91       2    4052   45.52       8      55   60.4%
SM Katich                56      99       6    4188   45.03       4      60   60.6%
VVS Laxman              119     196      30    7856   47.32      12     119   60.7%
RA Smith                 62     112      15    4236   43.67       8      68   60.7%
S Chanderpaul           129     219      34    9063   48.98      13     133   60.7%
ER Dexter                62     102       8    4502   47.89       6      62   60.8%
Mohammad Yousuf          90     156      12    7530   52.29      11      95   60.9%
IR Bell                  61     105      11    4077   43.37       7      64   61.0%
WM Lawry                 67     123      12    5234   47.15       6      75   61.0%
DPMD Jayawardene        116     190      13    9527   53.82      11     116   61.1%
SR Waugh                168     260      46   10927   51.06      22     159   61.2%
RB Simpson               62     111       7    4869   46.81       8      68   61.3%
Inzamam-ul-Haq          120     200      22    8830    49.6      15     123   61.5%
RN Harvey                79     137      10    6149   48.41       7      85   62.0%
AC Gilchrist             96     137      20    5570    47.6      14      85   62.0%
G Boycott               108     193      23    8114   47.72      10     120   62.2%
IR Redpath               66     120      11    4737   43.45       9      75   62.5%
CH Lloyd                110     175      14    7515   46.67       4     110   62.9%
ML Hayden               103     184      14    8625   50.73      14     116   63.0%
AB de Villiers           65     111      13    4702   47.97       2      70   63.1%
AN Cook                  64     114       7    4941   46.17       3      72   63.2%
PBH May                  66     106       9    4537   46.77       8      67   63.2%
FMM Worrell              51      87       9    3860   49.48      11      55   63.2%
AI Kallicharran          66     109      10    4399   44.43      10      69   63.3%
BC Lara                 131     232       6   11953   52.88      17     147   63.4%
DL Haynes               116     202      25    7487   42.29      10     128   63.4%
MJ Clarke                68     112      12    4697   46.97       5      71   63.4%
WR Hammond               85     140      16    7249   58.45       4      89   63.6%
G Kirsten               101     176      15    7289   45.27      13     112   63.6%
MC Cowdrey              114     188      15    7624   44.06       9     120   63.8%
ME Waugh                128     209      17    8029   41.81      19     134   64.1%
Saleem Malik            103     154      22    5768   43.69      12      99   64.3%
GC Smith                 90     157       9    7422   50.14      10     101   64.3%
DJ Cullinan              70     115      12    4554   44.21      10      74   64.3%
M Amarnath               69     113      10    4378    42.5      12      73   64.6%
IM Chappell              75     136      10    5345   42.42      11      88   64.7%
HM Amla                  50      88       7    3836   47.35       6      57   64.8%
V Sehwag                 86     148       6    7670   54.01      12      96   64.9%
HP Tillakaratne          83     131      25    4545   42.87       9      85   64.9%
RB Kanhai                79     137       6    6227   47.53       7      89   65.0%
ME Trescothick           76     143      10    5825   43.79      12      93   65.0%
MA Taylor               104     186      13    7525   43.49       5     121   65.1%
RB Richardson            86     146      12    5949   44.39       8      95   65.1%
RC Fredericks            59     109       7    4334   42.49       7      71   65.1%
Younis Khan              65     116       8    5440   50.37      13      76   65.5%
RR Sarwan                83     146       8    5759   41.73      10      96   65.8%
GR Viswanath             91     155      10    6080   41.93      10     102   65.8%
TW Graveney              79     123      13    4882   44.38       8      81   65.9%
CG Greenidge            108     185      16    7558   44.72      11     122   65.9%
DB Vengsarkar           116     185      22    6868   42.13      15     122   65.9%
Mushtaq Mohammad         57     100       7    3643   39.17       4      66   66.0%
DM Jones                 52      89      11    3631   46.55      11      59   66.3%
MD Crowe                 77     131      11    5444   45.36       9      87   66.4%
N Hussain                96     171      16    5764   37.18      14     114   66.7%
PD Collingwood           67     114      10    4246   40.82       6      76   66.7%
KWR Fletcher             59      96      14    3272    39.9       6      64   66.7%
NS Sidhu                 51      78       2    3202   42.13       9      52   66.7%
BF Butcher               44      78       6    3104   43.11       3      52   66.7%
AL Hassett               43      69       3    3073   46.56       1      46   66.7%
CD McMillan              55      91      10    3116   38.46       7      61   67.0%
A Ranatunga              93     155      12    5105   35.69      12     104   67.1%
DI Gower                117     204      18    8231   44.25       7     137   67.2%
KP Pietersen             70     122       6    5630   48.53       7      82   67.2%
DC Boon                 107     190      20    7422   43.65      16     128   67.4%
GA Gooch                118     215       6    8900   42.58      13     145   67.4%
TM Dilshan               66     105      11    3990   42.44      11      71   67.6%
Zaheer Abbas             78     124      11    5062   44.79      10      84   67.7%
AW Greig                 58      93       4    3599   40.43       5      63   67.7%
PR Umrigar               59      94       8    3631   42.22       5      64   68.1%
JL Langer               105     182      12    7696   45.27      11     124   68.1%
DL Amiss                 50      88      10    3612    46.3      10      60   68.2%
AJ Strauss               81     146       6    6024   43.02      12     100   68.5%
JH Edrich                77     127       9    5138   43.54       6      87   68.5%
SC Ganguly              113     188      17    7212   42.17      13     129   68.6%
MJ Slater                74     131       7    5312   42.83       9      90   68.7%
M Azharuddin             99     147       9    6215   45.03       5     101   68.7%
AG Prince                61      96      16    3487   43.58       6      66   68.8%
JC Adams                 54      90      17    3012   41.26       7      62   68.9%
Imran Khan               88     126      25    3807   37.69       8      87   69.0%
Hanif Mohammad           55      97       8    3915   43.98       5      67   69.1%
CG Borde                 55      97      11    3061   35.59      13      67   69.1%
ST Jayasuriya           110     188      14    6973   40.07      15     130   69.1%
PA de Silva              93     159      11    6361   42.97       7     110   69.2%
CC Hunte                 44      78       6    3245   45.06       5      54   69.2%
HA Gomes                 60      91      11    3171   39.63       5      63   69.2%
AJ Stewart              133     235      21    8463   39.54      14     163   69.4%
WJ Cronje                68     111       9    3714   36.41      11      77   69.4%
FE Woolley               64      98       7    3283   36.07      13      68   69.4%
VL Manjrekar             55      92      10    3208   39.12      11      64   69.6%
AR Morris                46      79       3    3533   46.48       4      55   69.6%
C Hill                   49      89       2    3412   39.21       9      62   69.7%
CH Gayle                 91     159       6    6373   41.65      15     111   69.8%
SP Fleming              111     189      10    7172   40.06      16     132   69.8%
SM Pollock              108     156      39    3781   32.31       9     109   69.9%
CC McDonald              47      83       4    3107   39.32       2      58   69.9%
BB McCullum              55      93       6    3232   37.14       8      65   69.9%
DL Vettori              103     157      23    4053   30.24      17     110   70.1%
CL Cairns                62     104       5    3320   33.53       7      73   70.2%
RJ Shastri               80     121      14    3830   35.79       9      85   70.2%
MA Atherton             115     212       7    7728   37.69      20     149   70.3%
Ijaz Ahmed               60      92       4    3315   37.67       7      65   70.7%
A Flintoff               79     130       9    3845   31.77      17      92   70.8%
HH Gibbs                 90     154       7    6167   41.95      11     109   70.8%
NJ Astle                 81     137      10    4702   37.02      11      97   70.8%
MW Gatting               79     138      14    4409   35.55      16      98   71.0%
MV Boucher              138     194      23    5257   30.74      16     138   71.1%
APE Knott                95     149      15    4389   32.75       8     106   71.1%
MP Vaughan               82     147       9    5719   41.44       9     105   71.4%
MA Butcher               71     131       7    4288   34.58      10      94   71.8%
VT Trumper               48      89       8    3163   39.04       7      64   71.9%
JR Reid                  58     108       5    3428   33.28       5      78   72.2%
ND McKenzie              58      94       7    3253   37.39       9      68   72.3%
Mudassar Nazar           76     116       8    4114   38.09       7      84   72.4%
MS Atapattu              90     156      15    5502   39.02      22     113   72.4%
KJ Hughes                70     124       6    4415   37.41      10      90   72.6%
Majid Khan               63     106       5    3931   38.92       9      77   72.6%
Habibul Bashar           50      99       1    3026   30.87       7      72   72.7%
JG Wright                82     148       7    5334   37.82       7     108   73.0%
AJ Lamb                  79     139      10    4656   36.09       9     102   73.4%
CL Hooper               102     173      15    5762   36.46      13     127   73.4%
Asif Iqbal               58      99       7    3575   38.85       9      73   73.7%
PJL Dujon                81     115      11    3322   31.94       8      85   73.9%
WPUJC Vaas              111     162      35    3089   24.32      12     120   74.1%
BE Congdon               61     114       7    3448   32.22       9      86   75.4%
GM Wood                  59     112       6    3374   31.83       9      85   75.9%
N Kapil Dev             131     184      15    5248   31.05      16     140   76.1%
IT Botham               102     161       6    5200   33.54      14     123   76.4%
Sir RJ Hadlee            86     134      19    3124   27.16      12     103   76.9%
IA Healy                119     182      23    4356   27.39      18     140   76.9%
GA Hick                  65     114       6    3383   31.32      11      88   77.2%
RW Marsh                 96     150      13    3633   26.51      12     120   80.0%
GW Flower                67     123       6    3457   29.54      16      99   80.5%
SK Warne                145     199      17    3154   17.32      34     173   86.9%


Tuesday, December 28, 2010

Part of Winning and Loosing Team - Most Number Of Times

While reading the article on Ponting, I became curious to know who are the people that were part of a winning team most of the times. And naturally with that comes the opposite question as well. So I opened CricInfo StatsGuru and figured it out quite easily. Here are the 2 tables.

Most Number Of Participations In A Winning Team

RT Ponting 1 1995-2010 99 99 0 0 0 - 46.77 3.60 735 120 investigate this query
SK Warne 1 1992-2007 92 92 0 0 0 - 44.39 3.43 653 108 investigate this query
SR Waugh 1 1987-2003 86 86 0 0 0 - 46.17 3.31 735 108 investigate this query
GD McGrath 1 1993-2007 84 84 0 0 0 - 44.57 3.49 652 108 investigate this query
AC Gilchrist 1 1999-2008 73 73 0 0 0 - 47.36 3.73 735 120 investigate this query
ME Waugh 1 1991-2002 72 72 0 0 0 - 43.24 3.26 653 108 investigate this query
ML Hayden 1 1997-2009 71 71 0 0 0 - 47.32 3.71 735 108 investigate this query
MV Boucher 1 1998-2010 70 70 0 0 0 - 44.83 3.29 682 167 investigate this query
JL Langer 1 1993-2007 70 70 0 0 0 - 45.07 3.61 735 120 investigate this query
JH Kallis 1 1996-2010 69 69 0 0 0 - 43.78 3.26 658 167 investigate this query
IVA Richards 1 1974-1991 63 63 0 0 0 - 39.71 3.40 687 127 investigate this query
DL Haynes 1 1978-1994 60 60 0 0 0 - 36.70 3.38 606 127 investigate this query
SR Tendulkar 1 1990-2010 60 60 0 0 0 - 45.01 3.38 726 104 investigate this query
CG Greenidge 1 1974-1991 57 57 0 0 0 - 39.51 3.41 687 127 investigate this query
IA Healy 1 1989-1999 55 55 0 0 0 - 43.81 3.03 653 108 investigate this query
B Lee 1 1999-2008 54 54 0 0 0 - 48.05 3.75 735 127 investigate this query
M Muralitharan 1 1992-2010 54 54 0 0 0 - 46.04 3.42 756 150 investigate this query
R Dravid 1 1996-2010 52 52 0 0 0 - 43.21 3.38 726 104 investigate this query
MA Taylor 1 1989-1999 52 52 0 0 0 - 44.74 3.05 653 108 investigate this query
CA Walsh 1 1984-2001 52 52 0 0 0 - 35.33 3.18 660 127 investigate this query
AR Border 1 1978-1994 50 50 0 0 0 - 41.82 2.92 653 145 investigate this query
M Ntini 1 1998-2009 50 50 0 0 0 - 46.40 3.38 682 167 investigate this query
Inzamam-ul-Haq 1 1992-2007 49 49 0 0 0 - 39.18 3.26 643 170 investigate this query
DPMD Jayawardene 1 1998-2010 49 49 0 0 0 - 47.01 3.54 756 150 investigate this query
SM Pollock 1 1996-2008 49 49 0 0 0 - 41.62 3.24 682 176 investigate this query
G Kirsten 1 1994-2004 48 48 0 0 0 - 40.12 3.13 682 167 investigate this query
JN Gillespie 1 1996-2006 47 47 0 0 0 - 46.01 3.64 735 108 investigate this query
GC Smith 1 2002-2010 45 45 0 0 0 - 48.76 3.45 682 167 investigate this query
CEL Ambrose 1 1988-2000 44 44 0 0 0 - 34.70 3.21 660 127 investigate this query
PJL Dujon 1 1982-1991 44 44 0 0 0 - 38.26 3.34 606 127 investigate this query
HH Gibbs 1 1996-2008 44 44 0 0 0 - 46.53 3.32 682 167 investigate this query
DR Martyn 1 1992-2006 44 44 0 0 0 - 43.96 3.68 735 120 investigate this query
MJ Slater 1 1993-2001 44 44 0 0 0 - 44.00 3.26 653 184 investigate this query
MC Cowdrey 1 1954-1975 43 43 0 0 0 - 38.31 2.61 562 150 investigate this query
A Kumble 1 1993-2008 43 43 0 0 0 - 42.55 3.24 675 104 investigate this query
VVS Laxman 1 1996-2010 43 43 0 0 0 - 43.18 3.44 726 104 investigate this query
CH Lloyd 1 1966-1984 43 43 0 0 0 - 41.05 3.39 687 190 investigate this query
MD Marshall 1 1980-1991 43 43 0 0 0 - 37.33 3.33 606 149 investigate this query
RB Richardson 1 1984-1995 43 43 0 0 0 - 36.44 3.37 569 127 investigate this query
WPUJC Vaas 1 1995-2009 43 43 0 0 0 - 44.32 3.34 713 150 investigate this query
KC Sangakkara 1 2000-2010 42 42 0 0 0 - 50.52 3.63 756 150 investigate this query
DC Boon 1 1984-1996 41 41 0 0 0 - 45.72 3.01 653 145 investigate this query
RN Harvey 1 1948-1963 41 41 0 0 0 - 37.38 2.62 758 75 investigate this query
Wasim Akram 1 1985-2002 41 41 0 0 0 - 35.35 3.12 600 116 investigate this query
MJ Clarke 1 2004-2010 40 40 0 0 0 - 46.16 3.65 602 127 investigate this query
ST Jayasuriya 1 1993-2007 40 40 0 0 0 - 45.02 3.41 756 150 investigate this query
Javed Miandad 1 1976-1993 39 39 0 0 0 - 39.47 3.15 652 102 investigate this query
Saleem Malik 1 1982-1999 39 39 0 0 0 - 34.52 3.13 652 102 investigate this query
AJ Stewart 1 1990-2003 39 39 0 0 0 - 35.93 3.08 604 118 investigate this query

Ponting is in the top with 99 wins followed by all Australians that you can remember on top of your head! Kidding. But top 10 is almost exclusively taken by them, Boucher and Kallis somehow chipping in at the last moment. Tendulkar is just outside the top 10 list with 60 wins but I hope he will make into that elite group by next year.


Most Number Of Participations In A Loosing Team

BC Lara 2 1992-2006 63 0 63 0 0 0.00 23.11 2.94 448 47 investigate this query
S Chanderpaul 1 1994-2010 61 0 61 0 0 0.00 23.25 2.98 416 47 investigate this query
AJ Stewart 1 1990-2003 54 0 54 0 0 0.00 22.64 2.65 445 46 investigate this query
AR Border 1 1979-1994 46 0 46 0 0 0.00 22.50 2.58 429 76 investigate this query
Mohammad Ashraful 1 2001-2010 46 0 46 0 0 0.00 20.49 3.10 427 62 investigate this query
SR Tendulkar 1 1990-2010 46 0 46 0 0 0.00 23.83 3.03 532 66 investigate this query
MA Atherton 1 1989-2001 44 0 44 0 0 0.00 21.93 2.63 432 46 investigate this query
Habibul Bashar 1 2000-2008 44 0 44 0 0 0.00 19.57 2.98 427 62 investigate this query
CH Gayle 1 2001-2010 43 0 43 0 0 0.00 24.36 3.03 448 47 investigate this query
RR Sarwan 1 2000-2009 43 0 43 0 0 0.00 24.29 3.02 448 47 investigate this query
CA Walsh 1 1984-2001 43 0 43 0 0 0.00 20.87 2.83 391 51 investigate this query
SP Fleming 1 1994-2008 42 0 42 0 0 0.00 22.82 2.78 451 73 investigate this query
GA Gooch 1 1975-1995 42 0 42 0 0 0.00 21.45 2.57 430 92 investigate this query
DI Gower 1 1978-1992 42 0 42 0 0 0.00 21.65 2.64 430 82 investigate this query
M Muralitharan 2 1993-2009 42 0 42 0 0 0.00 23.23 3.02 410 73 investigate this query
R Dravid 2 1996-2010 41 0 41 0 0 0.00 23.35 2.99 532 66 investigate this query
DL Vettori 2 1997-2010 40 0 40 0 0 0.00 23.15 2.95 451 73 investigate this query
Inzamam-ul-Haq 2 1992-2007 39 0 39 0 0 0.00 22.95 3.00 538 72 investigate this query
CL Hooper 1 1988-2002 38 0 38 0 0 0.00 22.40 2.84 448 107 investigate this query
JH Kallis 2 1997-2010 38 0 38 0 0 0.00 25.49 2.89 484 84 investigate this query
Khaled Mashud 1 2000-2007 38 0 38 0 0 0.00 19.76 3.00 427 86 investigate this query
GW Flower 1 1992-2003 37 0 37 0 0 0.00 21.56 2.45 422 63 investigate this query
HH Streak 1 1993-2005 37 0 37 0 0 0.00 21.58 2.51 422 54 investigate this query
PA de Silva 1 1985-2002 36 0 36 0 0 0.00 22.07 2.81 547 71 investigate this query
RD Jacobs 1 1998-2004 36 0 36 0 0 0.00 22.06 2.87 448 47 investigate this query
SR Waugh 1 1986-2003 36 0 36 0 0 0.00 23.53 2.92 556 103 investigate this query
SC Ganguly 1 1996-2008 35 0 35 0 0 0.00 23.31 2.95 532 66 investigate this query
Javed Omar 1 2001-2007 35 0 35 0 0 0.00 19.97 2.99 427 62 investigate this query
ST Jayasuriya 1 1991-2007 35 0 35 0 0 0.00 22.96 3.04 410 73 investigate this query
A Ranatunga 1 1982-2000 35 0 35 0 0 0.00 21.58 2.81 547 71 investigate this query
MV Boucher 2 1998-2009 34 0 34 0 0 0.00 26.14 2.95 484 84 investigate this query
A Flower 1 1992-2002 34 0 34 0 0 0.00 21.80 2.43 422 63 investigate this query
SM Gavaskar 1 1972-1987 34 0 34 0 0 0.00 23.41 2.80 465 42 investigate this query
DPMD Jayawardene 1 1998-2010 34 0 34 0 0 0.00 23.86 3.03 425 73 investigate this query
WPUJC Vaas 1 1994-2008 34 0 34 0 0 0.00 23.30 3.00 407 71 investigate this query
DB Vengsarkar 1 1976-1992 34 0 34 0 0 0.00 24.36 2.89 465 75 investigate this query
N Hussain 1 1990-2003 33 0 33 0 0 0.00 22.84 2.73 432 79 investigate this query
A Kumble 1 1992-2008 33 0 33 0 0 0.00 23.92 3.02 532 66 investigate this query
VVS Laxman 1 1996-2010 33 0 33 0 0 0.00 24.06 3.09 532 76 investigate this query
Mohammad Yousuf 1 1998-2010 33 0 33 0 0 0.00 24.06 3.09 538 72 investigate this query
MS Atapattu 1 1990-2007 32 0 32 0 0 0.00 23.84 2.92 547 81 investigate this query
IT Botham 1 1978-1992 32 0 32 0 0 0.00 21.06 2.62 315 64 investigate this query
ADR Campbell 1 1992-2002 32 0 32 0 0 0.00 22.00 2.45 422 63 investigate this query
AJ Lamb 1 1982-1992 32 0 32 0 0 0.00 21.84 2.73 430 82 investigate this query
JR Reid 1 1951-1965 32 0 32 0 0 0.00 18.25 1.91 413 26 investigate this query
N Kapil Dev 1 1978-1992 31 0 31 0 0 0.00 23.63 2.93 465 75 investigate this query
AC Parore 1 1990-2002 31 0 31 0 0 0.00 21.64 2.57 451 93 investigate this query
D Ganga 1 1998-2008 30 0 30 0 0 0.00 24.31 2.98 448 82 investigate this query
CS Martin 1 2000-2010 30 0 30 0 0 0.00 24.24 3.02 433 73 investigate this query
Mashrafe Mortaza 1 2001-2009 30 0 30 0 0 0.00 19.92 2.98 427 62 investigate this query

Guess what, Brian Lara is in the top of that list with 63 losses while Tendulkar in joint fourth position along with our famous Ashraful and Australian Allan Border.