How valuable is that wicket!

[ankitj]

Added Bumrah, Cummins, Anderson and Rabada (and refreshed Steyn because he played well past the date I last updated this)

#	Bowler	Wickets	Bowling Avg	Avg value of wicket	Discount Factor
1​	Jasprit Bumrah	215​	19.49​	30.41	64.1%​
2​	Sydney Barnes	189​	16.43​	25.02	65.7%​
3​	George Lohman	112​	10.75​	15.92	67.5%​
4​	Alan Davidson	170​	20.53​	30.04	68.3%​
5​	M Marshall	376​	20.94​	30.48	68.7%​
6​	Curtly Ambrose	405​	20.99​	30.23	69.4%​
7​	Glenn McGrath	563​	21.64​	31.02	69.8%​
8​	Dale Steyn	439​	22.95​	32.27	71.1%​
9​	Jim Laker	193​	21.24​	29.83	71.2%​
10​	Pat Cummins	307​	22.16​	31.03	71.4%​
11​	Bill O'Reilly	144​	22.59​	31.56	71.6%​
12​	Keith Miller	170​	22.97​	31.17	73.7%​
13​	Kagiso Rabada	336​	21.74​	29.20	74.5%​
14​	Fred Trueman	307​	21.57​	28.90	74.6%​
15​	Allan Donald	330​	22.25​	29.71	74.9%​
16​	Richard Hadlee	431​	22.29​	29.54	75.4%​
17​	Imran Khan	362​	22.81​	29.91	76.3%​
18​	Dennis Lillee	355​	23.92​	31.27	76.5%​
19​	Shaun Pollock	421​	23.11​	30.16	76.6%​
20​	Joel Garner	259​	20.97​	27.15	77.2%​
21​	Ray Lindwall	228​	23.03​	29.59	77.8%​
22​	Hedley Verity	144​	24.37​	31.23	78.0%​
23​	Michael Holding	249​	23.68​	30.14	78.6%​
24​	M Muralitharan	800​	22.72​	28.51	79.7%​
25​	Courtney Walsh	519​	24.44​	29.74	82.2%​
26​	C Grimmett	216​	24.21​	28.99	83.5%​
27​	James Anderson	704​	26.45​	31.47	84.0%​
28​	Bob Willis	325​	25.20​	29.95	84.2%​
29​	Waqar Younis	373​	23.56​	27.65	85.2%​
30​	Shane Warne	708​	25.41​	29.32	86.7%​
31​	Jason Gillespie	259​	26.13​	29.97	87.2%​
32​	Andy Roberts	202​	25.61​	29.01	88.3%​
33​	Wasim Akram	414​	23.62​	26.50	89.1%​
34​	Mkhaya Ntini	390​	28.82​	31.47	91.6%​
35​	Fred Spofforth	94​	18.41​	20.01	92.0%​
36​	Lance Gibbs	309​	29.09​	30.44	95.6%​
37​	Chaminda Vaas	355​	29.58​	30.74	96.2%​
38​	Ian Botham	383​	28.40​	29.30	96.9%​
39​	Anil Kumble	619​	29.65​	30.25	98.0%​
40​	Brett Lee	310​	30.81​	31.24	98.6%​
41​	Kapil Dev	434​	29.64​	29.80	99.5%​
42​	Jacques Kallis	266​	31.59​	31.25	101.1%​
43​	Harbhajan Singh	368​	31.66​	30.47	103.9%​
44​	Gary Sobers	235​	34.03​	30.93	110.0%​
45​	Daniel Vettori	325​	33.86​	29.44	115.0%​

Edit: Anderson too.

 

[ankitj]

Should have done this after conclusion of India-England series but I was too excited to see where Bumrah will rank and on the weekend had free time.

 

[ankitj]

Here's the sheet if anyone is interested. Feel free to make a copy.

https://docs.google.com/spreadsheets/d/0Bx5DR4ap92mFQW1tTUlqeW9TZzJ2LXZHNVFudEs3dw/

 

[honestbharani]

Is Ashwin and Jadeja there in your list?

 

[ankitj]

Is Ashwin and Jadeja there in your list?

No. Herath, Lyon, Haze, Broad should be added too.

 

[honestbharani]

No. Herath, Lyon, Haze, Broad should be added too.

Can u redo adding them?

 

[Thala_0710]

Bowler Discount Factors

docs.google.com

I've done it for all test bowlers with 50 test wkts... There are 4 tabs in the sheet for min 50, 100, 150 and 200 wicket filters

 

[ankitj]

Can u redo adding them?

Pay me.

 

[Thala_0710]

Bowler Discount Factors

docs.google.com

I've done it for all test bowlers with 50 test wkts... There are 4 tabs in the sheet for min 50, 100, 150 and 200 wicket filters

Hazlewood surprisingly high. Kumble surprisingly low. Akram a bit lower and Philander quite high (but understandable).
The cream always rises to the top though.

 

[Thala_0710]

Hazlewood surprisingly high. Kumble surprisingly low. Akram a bit lower and Philander quite high (but understandable).
The cream always rises to the top though.

And Sreesanth having the highest avg wkt quality of all time is a fun stat as well. Asif makes the top 10 of that list, as expected.

 

[Ali TT]

Interesting analysis, especially to see Big Vern so high up. Intrigued what his home v away/neutral disconut factory might be.

 

[ankitj]

Bowler Discount Factors

docs.google.com

I've done it for all test bowlers with 50 test wkts... There are 4 tabs in the sheet for min 50, 100, 150 and 200 wicket filters

Can you freeze the 1st row and column?

 

[Thala_0710]

Can you freeze the 1st row and column?

Done

 

[Thala_0710]

Bowler Discount Factors Away

docs.google.com

This is the sheet for away games only. One of the best metrics I've come across (thanks to @ankitj). If you look at the min 100 wkt filter list, that is basically the list of guys we have in our top 20s in not too dissimilar in order (compared to other standard metrics).
Away discount factor works probably even better than overall!

 

[Thala_0710]

As expected most spinners have slid down a bit, but Grimmett and Underwood stand out. Philander's high rank earlier is gone too.
And the min 125 wkts filter, gives a top 10 of Bumrah, Ambrose, McGrath, Marshall, Garner, Barnes, Hadlee, Donald, Steyn and Holding which is pretty damn good!

 

[the big bambino]

Gillespie just pipping Starc. Might have to reconsider.

 

[centurymaker]

Hazlewood surprisingly high. Kumble surprisingly low. Akram a bit lower and Philander quite high (but understandable).
The cream always rises to the top though.

Kumble & Akram -- more tailend wickets.

Philander benefiting from playing so much at home.

 

[capt_Luffy]

As expected most spinners have slid down a bit, but Grimmett and Underwood stand out. Philander's high rank earlier is gone too.
And the min 125 wkts filter, gives a top 10 of Bumrah, Ambrose, McGrath, Marshall, Garner, Barnes, Hadlee, Donald, Steyn and Holding which is pretty damn good!

Surprised by how low Murali turns

 

[the big bambino]

So if I'm getting this the higher the average wicket quality the better but the lower the discount factor the better? Is that right?

 

[Thala_0710]

So if I'm getting this the higher the average wicket quality the better but the lower the discount factor the better? Is that right?

Yes. Avg_wkt_quality just in itself wouldn't be a great metric though, definitely use it only for discount factor calculation