{"id":201,"date":"2017-10-05T07:47:08","date_gmt":"2017-10-05T14:47:08","guid":{"rendered":"http:\/\/www.ootp.cavebutter.net\/blog\/?p=201"},"modified":"2017-10-05T07:49:22","modified_gmt":"2017-10-05T14:49:22","slug":"batting-stats-9-wraa","status":"publish","type":"post","link":"http:\/\/www.ootp.cavebutter.net\/blog\/archives\/201","title":{"rendered":"Batting Stats 9: wRAA"},"content":{"rendered":"

Weighted Runs Above Average<\/a>\u00a0(wRAA) takes Weighted Runs Created<\/a> (wRC) and puts it in the context of comparing it to the average player. \u00a0Below, we see one of our test subjects, Jorge Acosta.<\/p>\n

\"\"<\/a>In 2015, Acosta accumulated 56.9 wRC. \u00a0Is that good? \u00a0As with all counting stats, it depends. \u00a0Like other counting stats, the number of plate appearances matters. \u00a0(I know I have AB shown here, but bear with me.) A player who racks up 50 RBIs over a full season isn’t terribly impressive. \u00a0One who does it in 200 plate appearances is amazing. \u00a0Same with wRC. \u00a0Fangraphs gives us some general guidelines on what’s good, great, average, etc. over the course of a full season. \u00a0Still, that’s a number that is devoid of any context. \u00a0How does that stack up against other players in the league?<\/p>\n

That’s where wRAA comes in. \u00a0League average wRAA is always 0. \u00a0So, looking at Acosta with his -7.3 wRAA, we see that his 56.9 wRC is not impressive at all: 7% below league average. \u00a0In 2015, Acosta played like a scrub.<\/p>\n

We derive wRAA thusly:
\n(wOBA-lg_woba)\/wOBAscale)*PA<\/code><\/p>\n

It does, and should, look very similar to wRC.<\/p>\n

My testing paramaters are based on the idea that there’s generally around 10 points separating the middle categories of poor to above average. \u00a0In order that my stats stay close to the game’s, I started off with a threshold of 3 points. \u00a0All of my results were within that range, so I tightened up a bit. \u00a0I changed my “good” zone to 1.0. \u00a0Here are my results:<\/p>\n

\"\"<\/a>Again, I’m really happy with how this turned out. \u00a0I don’t think I need to do any tweaking or further investigation. \u00a0Ready to move on!<\/p>\n

Our script with the addition of wRAA:<\/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    , @woba := round((r.wobaBB*(b.bb-b.ibb) + r.wobaHB*b.hp + r.woba1B*(b.h-b.d-b.t-b.hr) +\r\n       r.woba2B*b.d + r.woba3B*b.t + r.wobaHR*b.hr)\r\n       \/(b.ab+b.bb-b.ibb+b.sf+b.hp),3) as woba\r\n    , round(((@woba-r.woba)\/r.wOBAscale)*@PA,1) as wRAA\r\n    , round((((@woba-r.woba)\/r.wOBAscale)+(lro.totr\/lro.totpa))*@PA,1) as wRC\r\n    \/* NOT yet modified for OOTP and MySQL\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      INNER JOIN vLeagueRunsPerOut lro ON b.year=lro.year AND b.league_id=lro.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","protected":false},"excerpt":{"rendered":"
Weighted Runs Above Average\u00a0(wRAA) takes Weighted Runs Created (wRC) and puts it in the context of comparing it to the average player. \u00a0Below, we see one of our test subjects, Jorge Acosta. In 2015, Acosta accumulated 56.9 wRC. \u00a0Is that good? \u00a0As with all counting stats, it depends. \u00a0Like other counting stats, the number of… Continue reading Batting Stats 9: wRAA<\/span> →<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[25],"tags":[14,7,4,22],"class_list":["post-201","post","type-post","status-publish","format-standard","hentry","category-batting","tag-batting","tag-mysql","tag-ootp","tag-players"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t