We’ll look at one last easy stat before the hard stuff.<\/p>\n
BABIP is a very interesting stat because it acts as a kind of sanity check on all of the other stats a player produces. \u00a0It shows Batting Average on Balls in Play and average in most professional leagues is around .300. \u00a0A player with a career average well above that generally hits the ball hard. \u00a0A player with a career BABIP well below that mark often makes weak contact. \u00a0That’s an OK measure in itself, but it serves a much better purpose. If, during the course of a season, a player is putting up exceptional numbers, checking his BABIP against his career average will give you a sense of whether he’s getting lucky and likely to regress or if he’s turned a corner and upped his game.<\/p>\n
The formula for BABIP is pretty straightforward: The whole Megillah up to this point, then, is:<\/p>\n <\/p>\n","protected":false},"excerpt":{"rendered":" We’ll look at one last easy stat before the hard stuff. BABIP is a very interesting stat because it acts as a kind of sanity check on all of the other stats a player produces. \u00a0It shows Batting Average on Balls in Play and average in most professional leagues is around .300. \u00a0A player with… Continue reading Batting Stats 4: BABIP<\/span>
\n(H - HR) \/ (AB - K - HR + SF)<\/code><\/p>\n#Calculated batting stats for OOTP\r\n DROP TABLE IF EXISTS CalcBatting;\r\n CREATE TABLE IF NOT EXISTS CalcBatting AS\r\n\r\n SELECT b.year\r\n , b.league_id\r\n , b.player_id\r\n , b.stint #We can eventually move this down the list\r\n , b.split_id #We can eventually remove\r\n , b.team_id #We can eventually move this down the list\r\n , l.abbr as Lg\r\n , t.abbr as Team\r\n , b.g\r\n , b.ab\r\n , @PA := b.ab+b.bb+b.sh+b.sf+b.hp AS PA\r\n , b.r \r\n , b.h\r\n , b.d\r\n , b.t\r\n , b.hr\r\n , b.rbi\r\n , b.sb\r\n , b.cs\r\n , b.bb\r\n , b.k\r\n , b.ibb\r\n , b.hp\r\n , b.sh\r\n , b.sf\r\n , b.gdp\r\n , b.ci\r\n , @BA := round(b.h\/b.ab,3) AS ba\r\n , round(b.k\/@PA,3) as krate\r\n , round((b.bb)\/@PA,3) as bbrate\r\n , @OBP := round((b.h + b.bb + b.hp)\/(@PA-b.sh-b.ci),3) AS obp\r\n , round(100*(@OBP\/r.woba),0) as OBPplus\r\n , @SLG := round((b.h+b.d+2*b.t+3*b.hr)\/b.ab,3) as slg\r\n , round(@OBP+@SLG,3) as ops\r\n , round(@SLG-@BA,3) as iso\r\n , round((b.h-b.hr)\/(b.ab-b.k-b.hr+b.sf),3) as babip\r\n \/* NOT yet modified for OOTP and MySQL\r\n , round((r.wobaBB*nz(b.bb,0) + r.wobahb*nz(b.hbp,0) + r.woba1b*(b.h-b.[2b]-b.[3b]-b.hr) + r.woba2b*b.[2b] + r.woba3b*b.[3b] + r.wobahr*b.hr)\/(b.ab+nz(b.bb,0)-nz(b.ibb,0)+nz(b.sf,0)+nz(b.hbp,0)),3) as woba\r\n , round((([woba]-r.lgwoba)\/r.wobascale)*[PA],1) as wRAA\r\n , round(((([woba]-r.lgwoba)\/r.wobascale)+(l.totr\/l.totpa))*[PA],0) as wRC\r\n , ((([wRAA]\/[PA] + l.RperPA) + (l.RperPA - t.bpf*l.RperPA))\/(lb.wRC\/lb.PA))*100 AS [wRC+]\r\n *\/\r\n FROM \r\n players_career_batting_stats b \r\n INNER JOIN leagues l ON b.league_id=l.league_id \r\n INNER JOIN teams t ON b.team_id=t.team_id\r\n INNER JOIN tblRunValues2 r ON b.year=r.year AND b.league_id=r.league_id\r\n WHERE b.ab<>0 AND b.split_id=1\r\n ORDER BY b.player_id, b.year<\/code><\/pre>\n