{"id":177,"date":"2017-10-03T15:53:00","date_gmt":"2017-10-03T22:53:00","guid":{"rendered":"http:\/\/www.ootp.cavebutter.net\/blog\/?p=177"},"modified":"2017-10-03T15:53:00","modified_gmt":"2017-10-03T22:53:00","slug":"batting-stats-6-follow-up-on-woba","status":"publish","type":"post","link":"http:\/\/www.ootp.cavebutter.net\/blog\/archives\/177","title":{"rendered":"Batting Stats 6: Follow-up on wOBA"},"content":{"rendered":"

I wasn’t totally comfortable with the testing results for wOBA. \u00a0I didn’t change the calculation, but I did change my testing methodology. \u00a0The first time around was totally un-scientific: \u00a0I typed random player_id’s into a query, looked for stats that felt ‘good’ (whatever that means), grabbed their names and searched for the stats in the game.<\/p>\n

I revisited my method several times. \u00a0Since my biggest misses in the last test were with small sample sizes and, since I don’t really care about stats with small sample sizes, I limited my sample to player-years with at least 200 AB’s. \u00a0Perhaps redundantly, I removed pitchers from the sample as well. \u00a0Thinking that there would be an easy way to grab the stats from OOTP, I limited the sample to the last two game years. (There’s not, really.) \u00a0Finally, rather than cherry picking records that passed some indefinable sniff-test, I assigned a random number to each record, sorted my results by that random number, and limited the result set to 30. \u00a0Then, I went into the game and looked up the stats for those player-years.<\/p>\n

Here’s the query that did that:<\/p>\n

SELECT rand() as sorted\r\n  , p.player_id\r\n  , concat(first_name, \" \", last_name) as player\r\n  , b.year\r\n  , l.abbr \r\n  , b.ab\r\n  , b.woba\r\nFROM players p\r\n  INNER JOIN CalcBatting b ON p.player_id=b.player_id\r\n  INNER JOIN leagues l ON b.league_id=l.league_id\r\nWHERE p.position<>1 AND b.year>=2014 AND b.ab>200\r\nORDER BY sorted\r\nLIMIT 30;<\/code><\/pre>\n
I am much more comfortable with this result set:<\/p>\n
\"\"<\/a>77% were within range and 3 of the 5 that were medium were within 3 points of being good. \u00a0The two bad ones were really bad, though. \u00a0I will take a look at those particular seasons to see if I can find any stats that are out of normal range. \u00a0My thought is that somehow I am weighting a less-common stat (such as hit by pitch) incorrectly. \u00a0For a normal season, if HBP is weighted wrong but only occurs 5 times in 600 plate appearances, no big deal. \u00a0But if a guy got plunked 50 times or something, it could really throw off the calculation. \u00a0That’s my working theory going in at least. \u00a0If I find something weird, I will report back. \u00a0Otherwise, I’m going to move on.<\/p>\n","protected":false},"excerpt":{"rendered":"
I wasn’t totally comfortable with the testing results for wOBA. \u00a0I didn’t change the calculation, but I did change my testing methodology. \u00a0The first time around was totally un-scientific: \u00a0I typed random player_id’s into a query, looked for stats that felt ‘good’ (whatever that means), grabbed their names and searched for the stats in the… Continue reading Batting Stats 6: Follow-up on wOBA<\/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":[],"class_list":["post-177","post","type-post","status-publish","format-standard","hentry","category-batting"],"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