I used data from pages like this from Baseball Reference: 2011 National League PH/HR/Situ Hitting. It shows how many opportunities each batter in a season had to hit into a DP and their number of DPs. Then I moved it into an Excel file. 
Left handed batters have a * after their names while switch hitters have a # (I did not look at switch hitters). The command I used to separate out the different type of hitters was =ISNUMBER(SEARCH(G2,F2)). It will say if the cell contains * or #. If it does it gives TRUE. If not, FALSE. Then I can sort and separate all of those and then get totals for opportunities and DPs.
The table below shows the rates for each league for all years from 2011-2022 except 2020, the shortened Covid season.
| Year | AL LHB | AL RHB | NL LHB | NL RHB | 
| 2011 | 9.74% | 11.66% | 8.90% | 11.01% | 
| 2012 | 9.85% | 12.56% | 8.85% | 11.78% | 
| 2013 | 9.50% | 12.18% | 9.16% | 12.53% | 
| 2014 | 8.86% | 11.97% | 8.63% | 11.84% | 
| 2015 | 9.09% | 12.18% | 9.98% | 12.10% | 
| 2016 | 10.02% | 12.10% | 9.30% | 11.39% | 
| 2017 | 9.66% | 12.37% | 9.64% | 11.37% | 
| 2018 | 8.26% | 12.00% | 8.28% | 10.65% | 
| 2019 | 8.27% | 11.61% | 8.57% | 11.34% | 
| 2021 | 7.72% | 11.33% | 8.61% | 10.58% | 
| 2022 | 8.17% | 11.43% | 7.99% | 11.47% | 
| 
 | 
 | 
 | 
 | 
 | 
| Total | 9.04% | 11.92% | 8.90% | 11.46% | 
No comments:
Post a Comment