You Are Here > Baseball-Reference.com > Blog >

SITE NEWS: We are moving all of our site and company news into a single blog for Sports-Reference.com. We'll tag all B-R content, so you can quickly and easily find the content you want.

Also, our existing B-R blog rss feed will be redirected to the new site's feed.

Baseball-Reference.com ยป Sports Reference

For more from Andy and the gang, check out their new site High Heat Stats.

New PI arithmetic function

Posted by Andy on November 11, 2009

One of the additions to the PI (rolled out this morning by Sean) is a neat arithmetic function that allows comparison of two stats as one of the search criteria for batting or pitching seasons. I've been hoping for something like this for a while.

Here are some of the neat things you can do with it.

First, go to the Batting Season Finder.

In the criteria selection area (the white area in the lower right), you'll see that the fifth line down contains an equation. I've highlighted it for you:

This entry allows the user to compare one stat to another stat, and optionally to add in a multiplying factor.

Here's an example. Let's take a look at guys who have driven in a lot of runs per plate appearance. In the box I've highlighted red above, I'm choosing RBI on the left and PA on the right. I'm also changing the multiplying factor from the default of 1.0 to a value of 0.2. Finally, I'm changing the sign from the default of "=" to a ">" sign. This, then, looks for seasons in which the players RBI total is greater than 20% of his plate appearance total.

I changed the years to search just in 2009 and here are the results:

Rk Player PA RBI Tm
1 Ryan Howard 703 141 PHI
2 Carlos Delgado 112 23 NYM
3 David Freese 34 7 STL
4 Juan Francisco 25 7 CIN
5 Jamie Hoffmann 24 7 LAD
6 Billy Buckner 23 6 ARI
7 Matt Carson 22 5 OAK
8 Wilkin Ramirez 13 3 DET
9 Jonathan Van Ever 13 3 BOS
10 Juan Miranda 9 3 NYY
11 Chin-Lung Hu 6 2 LAD
12 Rick Porcello 5 2 DET
13 Dusty Brown 4 1 BOS
14 C.C. Sabathia 4 1 NYY
15 Guillermo Mota 4 1 LAD
16 Paul Hoover 4 1 PHI
17 Will Ohman 3 1 LAD
18 Wilkin Castillo 3 1 CIN
19 Chris Denorfia 2 1 OAK
20 Mariano Rivera 2 1 NYY
21 Osiris Matos 1 1 SFG
22 Adam Eaton 1 1 COL
Provided by Baseball-Reference.com: View Original Table
Generated 11/11/2009.



I've sorted the results by plate appearance. So, again, this shows guys who batted in a run at least, on average, once every 5 plate appearances. It's not such an easy thing to do. One note is that the search uses a greater-than sign, and not a greater-than-or-equals sign. This means that guys with an RBI total that is exactly 20% of their PA total don't show up. There's an easy fix to this, and that's changing the multiplying factor from 0.2 to 0.1999. Here is the new list in that case:

Rk Player PA RBI Tm
1 Ryan Howard 703 141 PHI
2 Carlos Delgado 112 23 NYM
3 David Freese 34 7 STL
4 Juan Francisco 25 7 CIN
5 Jamie Hoffmann 24 7 LAD
6 Billy Buckner 23 6 ARI
7 Matt Carson 22 5 OAK
8 Ryan Rohlinger 20 4 SFG
9 Jonathan Van Ever 13 3 BOS
10 Wilkin Ramirez 13 3 DET
11 Juan Miranda 9 3 NYY
12 Chin-Lung Hu 6 2 LAD
13 Franklin Morales 5 1 COL
14 Rick Porcello 5 2 DET
15 Brian Sanches 5 1 FLA
16 Brian Bannister 5 1 KCR
17 Jered Weaver 5 1 LAA
18 Josh Beckett 5 1 BOS
19 Scott Elbert 5 1 LAD
20 Mark Buehrle 5 1 CHW
21 Dusty Brown 4 1 BOS
22 C.C. Sabathia 4 1 NYY
23 Paul Hoover 4 1 PHI
24 Guillermo Mota 4 1 LAD
25 Will Ohman 3 1 LAD
Rk Player PA RBI Tm
26 Wilkin Castillo 3 1 CIN
27 Chris Denorfia 2 1 OAK
28 Mariano Rivera 2 1 NYY
29 Adam Eaton 1 1 COL
30 Osiris Matos 1 1 SFG
Provided by Baseball-Reference.com: View Play Index Tool Used
Generated 11/11/2009.



This adds a bunch of players with exactly 5 times the PA as RBI, headed by new #8 Ryan Rohlinger.

I think we can all agree that many of these players are irrelevant for this particular search, so let's make two more changes. Let's limit the plate appearances to 100 or more and let's expand the search to the last 10 seasons:

Rk Player PA RBI Year Tm
1 Miguel Tejada 725 150 2004 BAL
2 Mike Sweeney 717 144 2000 KCR
3 David Ortiz 713 148 2005 BOS
4 Sammy Sosa 711 160 2001 CHC
5 Alex Rodriguez 708 156 2007 NYY
6 Frank Thomas 707 143 2000 CHW
7 Carlos Delgado 705 145 2003 TOR
8 Ryan Howard 704 149 2006 PHI
9 Ryan Howard 703 141 2009 PHI
10 Ryan Howard 700 146 2008 PHI
11 Todd Helton 697 147 2000 COL
12 Todd Helton 696 146 2001 COL
13 Bret Boone 690 141 2001 SEA
14 Magglio Ordonez 678 139 2007 DET
15 David Ortiz 669 139 2004 BOS
16 Edgar Martinez 665 145 2000 SEA
17 Barry Bonds 664 137 2001 SFG
18 Jason Giambi 664 137 2000 OAK
19 Preston Wilson 661 141 2003 COL
20 Magglio Ordonez 653 135 2002 CHW
21 Manny Ramirez 650 144 2005 BOS
22 Ryan Howard 648 136 2007 PHI
23 Vinny Castilla 648 131 2004 COL
24 Lance Berkman 646 136 2006 HOU
25 Albert Pujols 634 137 2006 STL
Rk Player PA RBI Year Tm
26 Phil Nevin 624 126 2001 SDP
27 Manny Ramirez 620 125 2001 BOS
28 Larry Walker 601 123 2001 COL
29 Juan Gonzalez 595 140 2001 CLE
30 Scott Rolen 593 124 2004 STL
31 Travis Hafner 563 117 2006 CLE
32 Frank Thomas 559 114 2006 OAK
33 Mike Piazza 545 113 2000 NYM
34 Manny Ramirez 532 122 2000 CLE
35 Manny Ramirez 518 107 2002 BOS
36 Moises Alou 517 114 2000 HOU
37 Jeffrey Hammonds 511 106 2000 COL
38 Javy Lopez 495 109 2003 ATL
39 Carlos Lee 481 100 2008 HOU
40 John Vander Wal 461 94 2000 PIT
41 Ellis Burks 458 96 2000 SFG
42 Sammy Sosa 454 92 2007 TEX
43 Tony Clark 393 87 2005 ARI
44 Ivan Rodriguez 389 83 2000 TEX
45 Juan Gonzalez 346 70 2003 TEX
46 Mark McGwire 321 73 2000 STL
47 Josh Phelps 287 58 2002 TOR
48 Chris Truby 279 59 2000 HOU
49 Alex Ochoa 275 58 2000 CIN
50 Tony Clark 245 51 2007 ARI
Rk Player PA RBI Year Tm
51 Karim Garcia 210 52 2002 TOT
52 Ryan Garko 209 45 2006 CLE
53 Olmedo Saenz 204 48 2006 LAD
54 Rick Ankiel 190 39 2007 STL
55 Jason Wood 127 26 2007 FLA
56 Frank Thomas 124 26 2005 CHW
57 Julio Zuleta 118 24 2001 CHC
58 Carlos Delgado 112 23 2009 NYM
59 Mike Jacobs 112 23 2005 NYM
60 Victor Diaz 108 25 2007 TEX
61 Marlon Anderson 106 27 2007 TOT
62 Richie Sexson 104 23 2004 ARI
Provided by Baseball-Reference.com: View Play Index Tool Used
Generated 11/11/2009.



Pretty neat, huh? While there are a lot of expected seasons in there (mainly big-HR total seasons such as Ortiz in 2005 and Sosa in 2001) we find a lot of hidden gems. How about Alex Ochoa in 2000 (#49)?He batted in 58 runs with just 275 plate appearances. A lot of us probably remember Tony Clark in 2005, who batted in 87 runs in just 393 plate appearances. Even more memorable is Clark's 2007, where he got 51 RBI in just 245 PAs. Once upon a time, Mike Jacobs looked pretty promising too, when he batted in 25 runs in just 112 plate appearances.

We can't yet sort the list by the arithmetic criteria, but this new feature does let us discover lots of new interesting things. I will be featuring lots of searches using the arithmetic function over the next week or so.

This entry was posted on Wednesday, November 11th, 2009 at 9:23 am and is filed under Season Finders. You can follow any responses to this entry through the RSS 2.0 feed. Both comments and pings are currently closed.

One Response to “New PI arithmetic function”

  1. [...] You Are Here > Baseball-Reference.com > Blog > Baseball Stats and Analysis B-R Blog & Stat of the Day Numbers, News, and Notes « New PI arithmetic function [...]