Weightings for average, strike-rate, wickets per innings et al

[RossTaylorsBox]

Learn Python imo

 

[kyear2]

You're not penalising spin bowlers if you don't include it, you're just not rewarding them excessively.

re. productivity that's definitely a valid point but it circles back to analysing what the purpose of the exercise is. Are you trying to judge quality of the players, or productivity, because they're not exactly the same.

Exactly this, to include it severely inflates the value of spinners who simply aren't as efficient.

 

[srbhkshk]

I realize that one drawback in my system is that an ODI bowler with an E/R of 6 is equivalent to averaging 30 runs per wicket. Both are 1.5 times the figures which give a bowler maximum quality points (4.00 E/R and 20 runs per wicket). In no way should this be the case. So instead of using multiplication and division, perhaps a linear scale would be better, i.e. maximum points for an E/R of 4.00 and zero points for an E/R of 6.00. How can I get excel to calculate this for me?

=IFS(ER >=6 , 0 , ER<=4 , 100 , TRUE , 50 * (2-(ER-4))) , where ER is the cell in which you have your ER and 100 is the max value.

IFS function is available from excel version 2019, if you have an older version you need to use IF instead , the format would be slightly different and you would need to use it twice but it's probably good exercise to figure it out.

 

[Days of Grace]

=IFS(ER >=6 , 0 , ER<=4 , 100 , TRUE , 50 * (2-(ER-4))) , where ER is the cell in which you have your ER and 100 is the max value.

IFS function is available from excel version 2019, if you have an older version you need to use IF instead , the format would be slightly different and you would need to use it twice but it's probably good exercise to figure it out.

That's a great help, thank you. What do the numbers 50, 2 and -4 correspond to: 50 * (2-(ER-4)))? It is just a linear equation from making a scatter chart?

 

[srbhkshk]

That's a great help, thank you. What do the numbers 50, 2 and -4 correspond to: 50 * (2-(ER-4)))? It is just a linear equation from making a scatter chart?

2 is the difference between the worst possible value (6 ER in this case) and the best value (4 ER in this case) , 4 is the best possible value, 50 is the maximum score (which I took as 100) divided by 2 (again the difference between the worst and the best value).

 

[Red_Ink_Squid]

Taking into account RPI and WPM gives you a less accurate measurement of quality, which is the only reason I would disagree with it personally

Average by itself is a better measurement than any combination of average + WPM or average + RPI

So the way I see it you're putting in more steps and more work to get a less accurate result

Depends how you're defining 'quality'. Sounds like you're pretty much equating quality with average. In which case, yeah, average is obviously going to be the best measure.

But scoring more runs for your team each innings/taking more wickets for your team are definite markers of quality imo. You're clearly adding value to your team if you can take more wickets or score more runs, averages being roughly equal.

 

[Days of Grace]

Depends how you're defining 'quality'. Sounds like you're pretty much equating quality with average. In which case, yeah, average is obviously going to be the best measure.

But scoring more runs for your team each innings/taking more wickets for your team are definite markers of quality imo. You're clearly adding value to your team if you can take more wickets or score more runs, averages being roughly equal.

If Player A averages 20 with the ball at 4 wickets per match, and player B averages 25, how many wickets per match would player B have to take to offset the difference of 5 between their averages?

 

[Red_Ink_Squid]

If Player A averages 20 with the ball at 4 wickets per match, and player B averages 25, how many wickets per match would player B have to take to offset the difference of 5 between their averages?

5 is a big difference in average, so in my mind that'd be hard to make up via WPM. Plucking a figure out of the air I'd say the 25 average bowler would have to be taking something ridiculous like 7-8 wickets a match to make it up.

 

[TheJediBrah]

Depends how you're defining 'quality'. Sounds like you're pretty much equating quality with average. In which case, yeah, average is obviously going to be the best measure.

But scoring more runs for your team each innings/taking more wickets for your team are definite markers of quality imo. You're clearly adding value to your team if you can take more wickets or score more runs, averages being roughly equal.

Well yes exactly. All other things being equal (which of course they never are) average is going to be the best measure, if that's what you mean by "equating quality with average" then that's what we are both doing. Obviously average isn't an exact measure, factors like opposition strength and conditions over the course of a career will affect it significantly. However the same factors will affect RPI or WPI in the same way, as well as additional factors like batting order, quality of the players team etc.

And the overall point being that average alone is simply a more accurate measure than any combination of average + RPI or WPI

 

[Days of Grace]

2 is the difference between the worst possible value (6 ER in this case) and the best value (4 ER in this case) , 4 is the best possible value, 50 is the maximum score (which I took as 100) divided by 2 (again the difference between the worst and the best value).

Thank you.

How would you write the formula for batting strike-rate where a S/R of 110 gets 100 points and a S/R of 35 gets zero points?

 

[Prince EWS]

Depends how you're defining 'quality'. Sounds like you're pretty much equating quality with average. In which case, yeah, average is obviously going to be the best measure.

Average being the best measure of average amused me.