{"id":1046,"date":"2018-04-28T11:13:44","date_gmt":"2018-04-28T10:13:44","guid":{"rendered":"https:\/\/marriott-stats.com\/nigels-blog\/?p=1046"},"modified":"2018-04-28T11:14:53","modified_gmt":"2018-04-28T10:14:53","slug":"epl-2017-18-1-my-prediction-of-the-final-league-table-latest","status":"publish","type":"post","link":"https:\/\/marriott-stats.com\/nigels-blog\/epl-2017-18-1-my-prediction-of-the-final-league-table-latest\/","title":{"rendered":"EPL 2017\/18 #5 &#8211; My Prediction of the Final League Table &#8211; Round 36"},"content":{"rendered":"<p>With only 3 or 4 games to go for the teams of the Premier League, most of the season&#8217;s excitement has dissipated.\u00a0 Man City have wrapped up the title, the top 7 who will be playing in Europe next season is more or less settled and the former 10-team dogfight for relegation has resolved itself with a 4 point gap between the bottom 3 and the rest.\u00a0 Probably, the only remaining uncertainties are who will take 4th place (Spurs or Chelsea) and will Southampton escape relegation at the expense of Swansea?<\/p>\n<p><!--more--><\/p>\n<p>I use a statistical approach known as Poisson Regression which<a href=\"https:\/\/marriott-stats.com\/nigels-blog\/epl-2017-18-2-my-prediction-of-the-final-league-table-latest-round-29\/\" target=\"_blank\" rel=\"noopener\"> I described in depth for round 29 of matches<\/a>.\u00a0 If this is the first time you have seen my predictions then I strongly encourage you to click on that link to familiarise yourself with my terminology.\u00a0 My predictions all start with the latest form guide as shown below which I use to calculate two numbers for each team playing this weekend:<\/p>\n<ul>\n<li><span style=\"color: #008000\"><strong>eGS<\/strong> <\/span>&#8211; the expected number of goals that a team will score.<\/li>\n<li><span style=\"color: #008000\"><strong>ePts<\/strong><\/span> &#8211; the expected number of points that a team will receive.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-1050 alignnone\" src=\"https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2018\/04\/EPL18-w36-Poisson1-300x218.png\" alt=\"\" width=\"601\" height=\"437\" srcset=\"https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2018\/04\/EPL18-w36-Poisson1-300x218.png 300w, https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2018\/04\/EPL18-w36-Poisson1-450x328.png 450w, https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2018\/04\/EPL18-w36-Poisson1.png 713w\" sizes=\"auto, (max-width: 601px) 100vw, 601px\" \/><\/p>\n<p>For round 36 this weekend, I have used my calculations of eGS &amp; ePts (shown in the table below) to make 4 separate predictions of the scorelines for each match.\u00a0 The highlighted team in each match is the one with the higher eGS value but that doesn&#8217;t necessarily mean they will win.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-1053 alignnone\" src=\"https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2018\/04\/EPL18-w36-Pred3-300x114.png\" alt=\"\" width=\"608\" height=\"231\" srcset=\"https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2018\/04\/EPL18-w36-Pred3-300x114.png 300w, https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2018\/04\/EPL18-w36-Pred3-450x171.png 450w, https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2018\/04\/EPL18-w36-Pred3.png 581w\" sizes=\"auto, (max-width: 608px) 100vw, 608px\" \/><\/p>\n<p>The 4 scoreline prediction methods (ML, Med, Rdd &amp; Int) work as follows:<\/p>\n<ul>\n<li><span style=\"color: #008000\"><strong>ML &#8211; Maximum Likelihood<\/strong><\/span> is the scoreline with the highest probability from <a href=\"https:\/\/marriott-stats.com\/nigels-blog\/epl-2017-18-2-my-prediction-of-the-final-league-table-latest-round-29\/\" target=\"_blank\" rel=\"noopener\">the Scoreline Matrix as explained in step 3 of my post for round 29<\/a>.<\/li>\n<li><span style=\"color: #008000\"><strong>Med &#8211; Median<\/strong><\/span> is derived from the median number of goals that each team is expected to score.\u00a0 <a href=\"https:\/\/marriott-stats.com\/nigels-blog\/epl-2017-18-2-my-prediction-of-the-final-league-table-latest-round-29\/\" target=\"_blank\" rel=\"noopener\">See step 6 of my post for round 29 for a fuller explanation.<\/a><\/li>\n<li><span style=\"color: #008000\"><strong>Rdd &#8211; Rounded<\/strong><\/span> is a simpler predictor which just involves each teams eGS being rounded to the nearest whole number.\u00a0 So 1.8 for Chelsea rounds to 2 goals and 0.4 for Crystal Palace rounds to 0 goals, hence the 2-0 prediction.<\/li>\n<li><span style=\"color: #008000\"><strong>Int &#8211; Integer<\/strong><\/span> is simply the integer part of eGS which is equivalent to rounding down.\u00a0 Int is considered because whilst Rdd is better at predicting higher scorelines, it is very poor at predicting goalless teams whereas is more likely to predict this.<\/li>\n<\/ul>\n<p>On reason I publish four predictions is that they are all plausible methods of converting both teams&#8217; eGS into a scoreline and whilst as yet I am unable to say definitively <img loading=\"lazy\" decoding=\"async\" class=\"alignright wp-image-1048\" src=\"https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2018\/04\/EPL18-w36-accuracy2-300x76.png\" alt=\"\" width=\"367\" height=\"93\" srcset=\"https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2018\/04\/EPL18-w36-accuracy2-300x76.png 300w, https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2018\/04\/EPL18-w36-accuracy2.png 321w\" sizes=\"auto, (max-width: 367px) 100vw, 367px\" \/>which is the better option, it does appear rounds 29 to 32 that MED is edging ahead as shown in the table below.\u00a0 For each match prediction, I have scored them in one of three ways;<\/p>\n<ol>\n<li>Right Score i.e. I predicted the actual scoreline<\/li>\n<li>Right Result, Wrong Score i.e. I predicted the right outcome (win, draw or loss) but not the right score.<\/li>\n<li>Wrong Result i.e. I predicted the wrong outcome.<\/li>\n<\/ol>\n<p>The table shows that Med is most accurate so far both in terms of the match outcomes (62% correct) and scorelines (16% correct).\u00a0 Is this a good prediction model?\u00a0 One way to evaluate is use a dumb model instead (see my post on what makes a good forecaster).\u00a0 Suppose 1 in 7 (14%) of matches result in a 2-1 win for the home team.\u00a0 If I predicted every match to be a 2-1 home win, I would be correct 14% of the time and the difference between this and my Med model would not be that great.\u00a0 I should say, I don&#8217;t know what the underlying distribution of scorelines is but I would like to find out.\u00a0 I can say that since round 29, 8 out of the 64 matches played have ended in 1-1 draw.\u00a0 If this was my dumb model, I would have 8 Right Scores, 8 Right Results and 48 wrong results.\u00a0 If my dumb model had been 2-1 home win, then I would have 7 right scores, 20 right results and 37 wrong results.\u00a0 So it does appear that the Med model is doing better than dumb models whilst the other 3 models may be doing better than dumb models.<\/p>\n<p>To arrive at a final league table, I need to repeat this process for rounds 36 to 38 and then combine the predictions into a predicted final table.\u00a0 As I explained in round 29, I am making two separate predictions of the final table and I will demonstrate with my team Newcastle United by showing the predictions for all their remaining games.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-1049 alignnone\" src=\"https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2018\/04\/EPL18-w36-nufc-300x114.png\" alt=\"\" width=\"566\" height=\"215\" srcset=\"https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2018\/04\/EPL18-w36-nufc-300x114.png 300w, https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2018\/04\/EPL18-w36-nufc-450x171.png 450w, https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2018\/04\/EPL18-w36-nufc.png 581w\" sizes=\"auto, (max-width: 566px) 100vw, 566px\" \/><\/p>\n<p>My preferred method of estimating the final table is to total up the ePts values for all remaining games.\u00a0 Newcastle are currently on 41 points and if you total up the ePts, y<img loading=\"lazy\" decoding=\"async\" class=\"alignright wp-image-1051\" src=\"https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2018\/04\/EPL18-w36-Pred1-240x300.png\" alt=\"\" width=\"312\" height=\"390\" srcset=\"https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2018\/04\/EPL18-w36-Pred1-240x300.png 240w, https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2018\/04\/EPL18-w36-Pred1-280x350.png 280w, https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2018\/04\/EPL18-w36-Pred1.png 386w\" sizes=\"auto, (max-width: 312px) 100vw, 312px\" \/>ou find I am expecting them to get another 4.6 points which when rounded comes out at 46 points.\u00a0 Repeating this for all teams and you get the final table shown here which has Man City winning the league with a new record points tally, Newcastle in 10th and Southampton, Stoke &amp; WBA relegated.\u00a0 After many weeks of a relegation dogfight involving up to 10 teams, Newcastle are now projected to be 13 points above Southampton and even when you take the margin of error into account (as shown by the LCI &amp; UCI columns) it is clear they are safe.<\/p>\n<p>However, with only 3 or 4 games to go, my preferred league table prediction will result in impossible point totals.\u00a0 For example, Man City have 90 points and with 4 games to go, it is impossible for them to get 101 points.\u00a0 So it is now time to ignore this prediction and focus on my second method of estimating the final league table.\u00a0 To do this, I use the 4 scoreline prediction methods described earlier.\u00a0 For each method, I work out the <img loading=\"lazy\" decoding=\"async\" class=\" wp-image-1052 alignleft\" src=\"https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2018\/04\/EPL18-w36-Pred2-212x300.png\" alt=\"\" width=\"288\" height=\"408\" srcset=\"https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2018\/04\/EPL18-w36-Pred2-212x300.png 212w, https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2018\/04\/EPL18-w36-Pred2-248x350.png 248w, https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2018\/04\/EPL18-w36-Pred2.png 342w\" sizes=\"auto, (max-width: 288px) 100vw, 288px\" \/>expected number of points given the predicted scores and then take an average across the 4 methods.\u00a0 This method tends to give more points to teams at the top and fewer points to teams at the bottom but it does result in an explicit prediction of the W-D-L record for each team.\u00a0 Again we see the same 3 teams being relegated, Man City winning the title with 102 points and Newcastle in 10th place this time with 45 instead of 46 points.\u00a0 The DIFF column shows the difference between the two predicted tables.<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>With only 3 or 4 games to go for the teams of the Premier League, most of the season&#8217;s excitement has dissipated.\u00a0 Man City have wrapped up the title, the top 7 who will be playing in Europe next season is more or less settled and the former 10-team dogfight for relegation has resolved itself [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":1048,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_genesis_hide_title":false,"_genesis_hide_breadcrumbs":false,"_genesis_hide_singular_image":false,"_genesis_hide_footer_widgets":false,"_genesis_custom_body_class":"","_genesis_custom_post_class":"","_genesis_layout":"","footnotes":""},"categories":[6,4],"tags":[53,62,55,14,54,15],"class_list":{"0":"post-1046","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-forecasting","8":"category-sport","9":"tag-epl","10":"tag-epl-2017-18","11":"tag-football","12":"tag-forecasts","13":"tag-premier-league","14":"tag-sport-analytics","15":"entry","16":"override"},"_links":{"self":[{"href":"https:\/\/marriott-stats.com\/nigels-blog\/wp-json\/wp\/v2\/posts\/1046","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/marriott-stats.com\/nigels-blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/marriott-stats.com\/nigels-blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/marriott-stats.com\/nigels-blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/marriott-stats.com\/nigels-blog\/wp-json\/wp\/v2\/comments?post=1046"}],"version-history":[{"count":1,"href":"https:\/\/marriott-stats.com\/nigels-blog\/wp-json\/wp\/v2\/posts\/1046\/revisions"}],"predecessor-version":[{"id":1055,"href":"https:\/\/marriott-stats.com\/nigels-blog\/wp-json\/wp\/v2\/posts\/1046\/revisions\/1055"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/marriott-stats.com\/nigels-blog\/wp-json\/wp\/v2\/media\/1048"}],"wp:attachment":[{"href":"https:\/\/marriott-stats.com\/nigels-blog\/wp-json\/wp\/v2\/media?parent=1046"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/marriott-stats.com\/nigels-blog\/wp-json\/wp\/v2\/categories?post=1046"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/marriott-stats.com\/nigels-blog\/wp-json\/wp\/v2\/tags?post=1046"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}