BatCons.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R
1	Batsmen Consistency: Composite of Values
2
3	Batsman		Cty	Mats	Inns	Runs	ConsIdx	ConsIndex-Comps			RpI	SD	CoV	5TB	5TPts	5T-Idx	EffI	Eff-Idx
4							****	CoV	5TBlks	EffInns			***			*****		*****
5
6	Mark Richardson	L	Nz	38	65	2776	8.65	3.70	3.61	1.32	42.7	35.1	0.82	8	7.2	90.5%	43	66.2%
7	Herbert Sutcliffe		Eng	54	84	4555	8.49	3.66	3.33	1.50	54.2	45.2	0.83	11	9.2	83.4%	63	75.0%
8	Mohammad Rizwan		Pak	41	69	2399	8.47	3.49	3.67	1.30	34.8	30.4	0.88	8	7.4	91.9%	45	65.2%
9	Jack Hobbs		Eng	61	102	5410	8.45	3.47	3.56	1.41	53.0	46.7	0.88	12	10.7	89.1%	72	70.6%
10	Trevor Goddard	L	Sa	41	78	2516	8.28	3.63	3.59	1.05	32.3	27.1	0.84	8	7.2	90.0%	41	52.6%
11	Jeffrey Stollmeyer		Wi	32	56	2159	8.24	3.45	3.61	1.17	38.6	34.2	0.89	6	5.4	90.3%	33	58.9%
12	Chris Rogers	L	Aus	25	48	2015	8.23	3.27	3.79	1.16	42.0	39.1	0.93	5	4.8	95.0%	28	58.3%
13	Ian Redpath		Aus	66	120	4737	8.22	3.46	3.46	1.29	39.5	34.9	0.88	13	11.2	86.5%	78	65.0%
14	Don Bradman		Aus	52	80	6996	8.12	3.03	3.66	1.42	87.5	86.7	0.99	10	9.2	91.7%	57	71.2%
15	Roy Fredericks	L	Wi	59	109	4334	8.11	3.27	3.66	1.17	39.8	37.0	0.93	12	11	91.7%	64	58.7%
16	Arjuna Ranatunga	L	Sl	93	155	5105	8.07	3.42	3.45	1.18	32.9	29.4	0.89	19	16.4	86.5%	92	59.4%
17	Ramiz Raja		Pak	57	94	2833	8.06	3.38	3.54	1.12	30.1	27.2	0.90	11	9.8	88.6%	53	56.4%
18	Angelo Mathews		Sl	119	212	8214	8.03	3.15	3.60	1.27	38.7	37.2	0.96	24	21.6	90.1%	135	63.7%
19	Imran Farhat	L	Pak	40	77	2400	8.03	3.46	3.58	0.98	31.2	27.6	0.88	8	7.2	89.7%	38	49.4%
20	Rishab Pant		Ind	49	86	3476	8.03	3.27	3.54	1.20	40.4	37.6	0.93	10	8.9	88.6%	52	60.5%
21	N Dickwella		Sl	54	96	2757	8.02	3.57	3.51	0.93	28.7	24.6	0.86	11	9.7	87.8%	45	46.9%
22	Chetan Chauhan		Ind	40	68	2084	8.02	3.40	3.65	0.97	30.6	27.6	0.90	8	7.3	91.4%	33	48.5%
23	Simon Katich	L	Aus	56	99	4188	8.02	3.42	3.40	1.19	42.3	37.8	0.89	11	9.3	85.0%	59	59.6%
24	Misbah-ul-Haq		Pak	75	132	5222	8.00	3.38	3.39	1.22	39.6	35.8	0.90	15	12.7	84.9%	81	61.4%
25	Mohinder Amarnath		Ind	69	113	4378	7.99	3.29	3.45	1.23	38.7	35.8	0.93	14	12.1	86.4%	70	61.9%
26	Colin McDonald		Aus	47	83	3107	7.98	3.22	3.52	1.22	37.4	35.3	0.94	9	7.9	88.2%	51	61.4%
27	Peter Richardson	L	Eng	34	56	2061	7.98	3.42	3.41	1.14	36.8	32.9	0.89	7	6	85.4%	32	57.1%
28	Sarfaraz Ahmed		Pak	54	95	3031	7.98	3.28	3.62	1.07	31.9	29.6	0.93	11	10	90.7%	51	53.7%
29	Dave Nourse	L	Sa	45	83	2234	7.97	3.41	3.60	0.96	26.9	24.1	0.90	9	8.1	90.0%	40	48.2%
30	Ken Barrington		Eng	82	131	6806	7.94	3.35	3.29	1.29	52.0	47.4	0.91	16	13.2	82.4%	85	64.9%
31	Dwayne Bravo		Wi	40	71	2200	7.94	3.34	3.58	1.01	31.0	28.3	0.91	8	7.2	89.7%	36	50.7%
32	Allan Border	L	Aus	156	265	11174	7.93	3.15	3.50	1.26	42.2	40.5	0.96	31	27.2	87.7%	168	63.4%
33	Norman O'Neill		Aus	42	69	2779	7.93	3.13	3.54	1.24	40.3	38.9	0.97	8	7.1	88.7%	43	62.3%
34	Robin Smith		Eng	62	112	4236	7.91	3.03	3.68	1.19	37.8	37.5	0.99	12	11.1	92.1%	67	59.8%
35	Basil D'Oliveira		Eng	44	70	2484	7.90	3.17	3.53	1.20	35.5	33.9	0.96	9	8	88.3%	42	60.0%
36	Geoff Marsh		Aus	50	93	2854	7.90	3.09	3.64	1.16	30.7	29.9	0.98	10	9.1	91.2%	54	58.1%
37	Michael Hussey	L	Aus	79	137	6235	7.89	3.14	3.48	1.27	45.5	43.9	0.96	16	13.9	87.0%	87	63.5%
38	Farokh Engineer		Ind	46	87	2611	7.88	3.31	3.65	0.91	30.0	27.7	0.92	9	8.2	91.3%	40	46.0%
39	Tembe Bavuma		Sa	66	115	3810	7.86	3.30	3.41	1.14	33.1	30.6	0.92	13	11.1	85.3%	66	57.4%
40	AB de Villiers		Sa	114	191	8765	7.86	2.98	3.59	1.28	45.9	46.1	1.00	23	20.7	89.8%	123	64.4%
41	Shiv Chanderpaul	L	Wi	164	280	11867	7.86	3.21	3.42	1.22	42.4	40.1	0.95	33	28.2	85.5%	172	61.4%
42	Cyril Washbrook		Eng	37	66	2569	7.83	3.08	3.48	1.27	38.9	38.1	0.98	7	6.1	87.0%	42	63.6%
43	Bill Woodfull		Aus	35	54	2300	7.83	3.09	3.52	1.22	42.6	41.6	0.98	7	6.2	88.1%	33	61.1%
44	Ted Dexter		Eng	62	102	4502	7.83	2.99	3.56	1.27	44.1	44.2	1.00	12	10.7	89.1%	65	63.7%
45	Rohan Kanhai		Wi	79	137	6227	7.82	3.03	3.53	1.25	45.5	45.1	0.99	16	14.1	88.4%	86	62.8%
46	Litton Das		Ban	52	90	3117	7.82	3.22	3.51	1.08	34.6	32.7	0.94	10	8.8	87.8%	49	54.4%
47	Saeed Ahmed		Pak	41	78	2991	7.81	3.16	3.55	1.10	38.3	36.8	0.96	8	7.1	88.9%	43	55.1%
48	Clive Lloyd	L	Wi	110	175	7515	7.80	3.17	3.43	1.18	42.9	41.0	0.96	22	18.9	85.8%	104	59.4%
49	Damien Martyn		Aus	67	109	4406	7.80	3.08	3.50	1.21	40.4	39.5	0.98	13	11.4	87.7%	66	60.6%
50	Bruce Mitchell		Sa	42	80	3471	7.80	3.17	3.52	1.10	43.4	41.5	0.96	8	7.1	88.2%	44	55.0%
51	Tony Greig		Eng	58	93	3599	7.79	3.32	3.30	1.16	38.7	35.6	0.92	12	9.9	82.6%	54	58.1%
52	DJ Mitchell		Nz	35	55	2175	7.79	3.26	3.44	1.09	39.5	36.9	0.93	7	6	86.0%	30	54.5%
53	Geoff Boycott		Eng	108	193	8114	7.78	3.04	3.47	1.26	42.0	41.6	0.99	22	19.1	86.8%	122	63.2%
54	Eddie Barlow		Sa	30	57	2516	7.78	3.30	3.38	1.08	44.1	40.7	0.92	6	5.1	84.7%	31	54.4%
55	Patsy Hendren		Eng	51	83	3525	7.77	3.03	3.56	1.18	42.5	42.1	0.99	10	8.9	89.1%	49	59.0%
56	Basil Butcher		Wi	44	78	3104	7.77	3.19	3.41	1.15	39.8	37.8	0.95	9	7.7	85.4%	45	57.7%
57	Dudley Nourse		Sa	34	62	2960	7.77	2.98	3.37	1.41	47.7	47.9	1.00	7	5.9	84.3%	44	71.0%
58	Alex Carey		Aus	48	73	2333	7.77	3.21	3.55	1.01	32.0	30.3	0.95	10	8.9	88.9%	37	50.7%
59	Everton Weekes		Wi	48	81	4455	7.76	3.05	3.37	1.33	55.0	54.2	0.99	10	8.4	84.4%	54	66.7%
60	Clyde Walcott		Wi	44	74	3798	7.74	3.18	3.34	1.21	51.3	49.0	0.95	9	7.5	83.7%	45	60.8%
61	Graham Thorpe	L	Eng	100	179	6744	7.74	3.04	3.52	1.17	37.7	37.2	0.99	20	17.6	88.2%	105	58.7%
62	John Wright	L	Nz	82	148	5334	7.73	3.04	3.46	1.21	36.0	35.6	0.99	16	13.9	86.6%	90	60.8%
63	David Gower	L	Eng	117	204	8231	7.72	3.03	3.54	1.14	40.3	40.0	0.99	23	20.4	88.7%	117	57.4%
64	Mark Waugh		Aus	128	209	8029	7.72	3.17	3.39	1.14	38.4	36.7	0.96	26	22.1	84.9%	120	57.4%
65	Bill Lawry	L	Aus	67	123	5234	7.69	2.91	3.58	1.18	42.6	43.4	1.02	13	11.7	89.7%	73	59.3%
66	JC Buttler		Eng	57	100	2907	7.69	3.11	3.57	1.00	29.1	28.2	0.97	11	9.8	89.5%	50	50.0%
67	Asad Shafiq		Pak	77	128	4660	7.67	3.03	3.61	1.03	36.4	36.1	0.99	15	13.5	90.3%	66	51.6%
68	Hansie Cronje		Sa	68	111	3714	7.65	3.14	3.38	1.11	33.5	32.2	0.96	14	11.9	84.7%	62	55.9%
69	Tamim Iqbal	L	Ban	70	134	5134	7.65	3.16	3.38	1.10	38.3	36.8	0.96	14	11.9	84.7%	74	55.2%
70	Asanka Gurusinha	L	Sl	41	70	2452	7.64	3.00	3.47	1.17	35.0	35.0	1.00	8	6.9	86.8%	41	58.6%
71	Shane Watson		Aus	59	109	3731	7.64	3.25	3.28	1.10	34.2	32.0	0.94	12	9.9	82.2%	60	55.0%
72	Rahul Dravid		Ind	164	286	13288	7.63	2.86	3.42	1.34	46.5	48.0	1.03	33	28.2	85.5%	193	67.5%
73	Lindsay Hassett		Aus	43	69	3073	7.63	3.00	3.44	1.18	44.5	44.5	1.00	9	7.8	86.2%	41	59.4%
74	Alec Stewart		Eng	133	235	8465	7.62	2.99	3.46	1.15	36.0	36.0	1.00	27	23.4	86.6%	136	57.9%
75	Saeed Anwar	L	Pak	55	91	4052	7.62	2.94	3.60	1.07	44.5	45.1	1.01	11	9.9	90.1%	49	53.8%
76	Colin Cowdrey		Eng	114	188	7624	7.62	2.96	3.53	1.12	40.6	40.9	1.01	23	20.3	88.3%	106	56.4%
77	Navjot Sidhu		Ind	51	78	3202	7.62	2.94	3.51	1.15	41.1	41.6	1.01	10	8.8	88.0%	45	57.7%
78	Jonty Rhodes		Sa	52	80	2532	7.62	3.25	3.37	1.00	31.6	29.6	0.94	10	8.4	84.3%	40	50.0%
79	Harry Brook		Eng	35	60	3178	7.62	2.65	3.66	1.29	53.0	57.5	1.09	7	6.4	91.6%	39	65.0%
80	Jacques Kallis		Sa	166	280	13289	7.61	3.00	3.33	1.27	47.5	47.4	1.00	33	27.5	83.4%	178	63.6%
81	Sourav Ganguly	L	Ind	113	188	7212	7.60	2.98	3.43	1.18	38.4	38.5	1.00	23	19.8	85.9%	111	59.0%
82	Peter May		Eng	66	106	4537	7.59	2.86	3.55	1.16	42.8	44.2	1.03	13	11.6	88.9%	62	58.5%
83	Maurice Leyland	L	Eng	41	65	2764	7.58	2.88	3.50	1.20	42.5	43.7	1.03	8	7	87.5%	39	60.0%
84	Dinesh Chandimal		Sl	90	161	6361	7.57	2.92	3.53	1.11	39.5	40.2	1.02	18	15.9	88.3%	90	55.9%
85	Q de Kock		Sa	54	91	3300	7.56	3.09	3.38	1.07	36.3	35.4	0.98	11	9.3	84.7%	49	53.8%
86	Alvin Kallicharran	L	Wi	66	109	4399	7.56	3.02	3.40	1.13	40.4	40.1	0.99	13	11.1	85.1%	62	56.9%
87	Andrew Jones		Nz	39	74	2922	7.55	2.81	3.52	1.21	39.5	41.3	1.05	8	7	88.1%	45	60.8%
88	Greg Chappell		Aus	87	151	7110	7.54	2.69	3.55	1.29	47.1	50.7	1.08	17	15.1	88.9%	98	64.9%
89	Richie Richardson		Wi	86	146	5949	7.54	2.85	3.44	1.24	40.7	42.2	1.04	17	14.7	86.2%	91	62.3%
90	Andrew Strauss	L	Eng	100	178	7037	7.53	2.86	3.50	1.15	39.5	40.8	1.03	20	17.5	87.6%	103	57.9%
91	Shakib Al Hasan	L	Ban	71	130	4609	7.53	3.00	3.48	1.04	35.5	35.4	1.00	14	12.2	87.2%	68	52.3%
92	Herbie Taylor		Sa	42	76	2936	7.53	3.09	3.36	1.07	38.6	37.7	0.98	8	6.7	84.1%	41	53.9%
93	J Blackwood		Wi	56	102	2898	7.52	3.10	3.52	0.90	28.4	27.7	0.97	11	9.7	88.2%	46	45.1%
94	Gus Logie		Wi	52	78	2470	7.51	3.10	3.40	1.00	31.7	30.8	0.97	10	8.5	85.2%	39	50.0%
95	Kevin Pietersen		Eng	104	181	8181	7.51	2.77	3.59	1.14	45.2	47.7	1.06	21	18.9	89.8%	104	57.5%
96	David Boon		Aus	107	190	7422	7.51	2.90	3.46	1.14	39.1	40.0	1.02	21	18.2	86.7%	109	57.4%
97	Mike Smith		Eng	50	78	2278	7.50	2.86	3.57	1.07	29.2	30.2	1.03	10	8.9	89.3%	42	53.8%
98	Mark Burgess		Nz	50	92	2684	7.50	2.91	3.63	0.95	29.2	29.8	1.02	10	9.1	90.8%	44	47.8%
99	Shaun Pollock		Sa	108	156	3781	7.49	3.18	3.24	1.06	24.2	23.1	0.95	22	17.9	81.2%	83	53.2%
100	Doug Walters		Aus	74	125	5357	7.49	2.84	3.45	1.20	42.9	44.5	1.04	15	12.9	86.3%	75	60.0%