Data analysis, Rd 2: Breaking down the key stats

This is actually fantastic! Well done! The kind of stats/strategic analysis that the SC community can really benefit from.
I do think that a slight tweak could be good here if it’s possible. I think the relevant number to multiply the actual-expected score differential by is not always the number of coaches that own the player. Maybe you’ve already considered this and maybe it’s too complicated to execute, however, I believe the relevant number is the amount of coaches that are on the other side of the coin to the observer. Let me explain, continuing on with the Gawn example. As a Gawn owner, his low score actually becomes less “painful” the more highly owned he is. If 100% of coaches have Gawn, then his score is not painful at all, because everyone has him. If 1% of coaches own Gawn, then his low score becomes extremely “painful” for those 1% of coaches, because nearly everyone else gets an advantage. However, with the current formula, the “pain” number gets bigger with a higher ownership. The “pain” number should get smaller with higher ownership. My suggestion would be to have two figures for each player, one for owners to look at, and one for non owners to look at. Also I think to help avoid confusion, rather than calling them “pain” or “gain” points, go with one name that is neutral (neither negative nor positive) like “contribution points” or something to that effect, and let the positive or negative nature of the number indicate whether the contribution has been positive or negative. The relevant “contribution points” figure to look at for OWNERS of a player would have their actual-expected score differential multiplied by how many coaches DON’T own that player, and the relevant “contribution points” figure to look at for NON-OWNERS of a player would have their actual-expected score differential multiplied by the number of coaches that DO own that player. Hope that makes sense. 🙂

<ul><li>WEEKLY WRAP: <a rel="noreferrer noopener" href="http://13.210.220.211/2022/03/21/weekly-wrap-round-1-studs-duds-injuries/" target="_blank">Round 1 studs, duds and injuries</a></li><li>SC PLAYBOOK PODCAST: <a href="http://13.210.220.211/podcast/episode-7-sc-playbook-afl-podcast-rd-2/" target="_blank" rel="noreferrer noopener">Weekend wrap, Rd 2 preview</a></li></ul>



Round one has come and gone and it is now time to ask why am I ranked in the position I am in?



A large part of this will be the performance of the competition’s most highly owned players.



The performance of these players will play a significant part in where you end up each week as they impact the largest number of coaches comparatively.



Miss out on a few value options and thousands of coaches could be surging ahead of you. Avoid the underperformers and watch your ranking climb!



<a href="http://13.210.220.211/subscribe/">Sign up to SC Playbook </a>for stacks of extra premium articles across the AFL season, including access to our contributor inclusive Whatsapp group where your SuperCoach dilemmas can be answered minutes before kick off!



<a id='s_e_siVxQ3tl0Vy66t54Qg' class='gie-single' href='http://www.gettyimages.com/detail/1238891701' target='_blank' style='color:#a7a7a7;text-decoration:none;font-weight:normal !important;border:none;display:inline-block;' rel="noopener">Embed from Getty Images</a><script>window.gie=window.gie||function(c){(gie.q=gie.q||[]).push(c)};gie(function(){gie.widgets.load({id:'s_e_siVxQ3tl0Vy66t54Qg',sig:'prCgTfx-4bvm3wn0PIeQbN0jTCTM9_urd-cwkdn2yls=',w:'594px',h:'393px',items:'1238891701',caption: true ,tld:'com',is360: false })});</script><script src='//embed-cdn.gettyimages.com/widgets.js' charset='utf-8' async></script>



To measure the impact of each player let’s create a metric called ‘Pain/Gain points’.



Firstly, we take a given player’s price and divide it by 5441 to calculate their expected score (e.g. Max Gawn at $657k is expected to score 120.8).



We then measure this against the player’s actual score (e.g. Max Gawn 92) and work out the difference (-28.8 for big Max).



This difference multiplied by ownership to give a number for total ‘Pain/Gain points’ (for big Max this is -28.8 * 91,575 owners = -2.6 million points – that’s a lot of points).



For simplicity, I will look at premium and mid-price players only as the rookies should all over perform their price points.



<a id='dC7G-uruQkxwM5Dtla_apQ' class='gie-single' href='http://www.gettyimages.com/detail/1239231630' target='_blank' style='color:#a7a7a7;text-decoration:none;font-weight:normal !important;border:none;display:inline-block;' rel="noopener">Embed from Getty Images</a><script>window.gie=window.gie||function(c){(gie.q=gie.q||[]).push(c)};gie(function(){gie.widgets.load({id:'dC7G-uruQkxwM5Dtla_apQ',sig:'7vp-mNqi0iDwyujo3FtpeN26s_pgfm_Da_jLaKUAxkU=',w:'487px',h:'594px',items:'1239231630',caption: true ,tld:'com',is360: false })});</script><script src='//embed-cdn.gettyimages.com/widgets.js' charset='utf-8' async></script>



<h2 class="wp-block-heading">The gainers:</h2>



<ul><li>These are the players you want to have selected and helped many a coach move up the rankings (and you are likely thinking how you will trade them in right now).</li><li>Rowell is the standout here – scoring 94 points above his price point and rewarding the 51% of owners that went with him (I suspect that number will go up …).</li><li>Someone like Petracca who scored 163 helped their coaches a great deal, but was only in 11% of teams – not owning him didn’t hurt you too much.</li><li>Other highly touted pre-season picks also did well – Coniglio, Neale, Butters and Dunkley. This contributed to the generally high scores seen across the comp.</li><li>Those that did well likely had a couple more players from this list (and probably barrack for Carlton!).</li></ul>



<figure class="wp-block-table"><table><tbody><tr><td>First Name</td><td>Own</td><td>Score</td><td>Price</td><td>Exp. Score</td><td>Scoring +/-</td><td>Pain / Gain Points</td></tr><tr><td>Matt Rowell</td><td>51%</td><td>157</td><td>$&nbsp; 342,900</td><td>63</td><td>94</td><td>7,380,809</td></tr><tr><td>Stephen Coniglio</td><td>75%</td><td>80</td><td>$&nbsp; 261,300</td><td>48</td><td>32</td><td>3,693,356</td></tr><tr><td>Lachie Neale</td><td>54%</td><td>140</td><td>$&nbsp; 543,200</td><td>100</td><td>40</td><td>3,308,507</td></tr><tr><td>George Hewett</td><td>32%</td><td>131</td><td>$&nbsp; 399,000</td><td>73</td><td>58</td><td>2,795,289</td></tr><tr><td>Patrick Cripps</td><td>35%</td><td>132</td><td>$&nbsp; 454,800</td><td>84</td><td>48</td><td>2,613,997</td></tr><tr><td>Zak Butters</td><td>47%</td><td>114</td><td>$&nbsp; 443,600</td><td>82</td><td>32</td><td>2,360,901</td></tr><tr><td>Will Brodie</td><td>40%</td><td>76</td><td>$&nbsp; 224,300</td><td>41</td><td>35</td><td>2,107,084</td></tr><tr><td>Isaac Heeney</td><td>20%</td><td>141</td><td>$&nbsp; 454,500</td><td>84</td><td>57</td><td>1,718,949</td></tr><tr><td>Josh Dunkley</td><td>60%</td><td>117</td><td>$&nbsp; 558,200</td><td>103</td><td>14</td><td>1,319,473</td></tr><tr><td>Jade Gresham</td><td>15%</td><td>109</td><td>$&nbsp; 299,000</td><td>55</td><td>54</td><td>1,260,142</td></tr></tbody></table></figure>



<h2 class="wp-block-heading">The painful:</h2>



<ul><li>These are the players you want to have avoided and importantly – chosen a player instead that performed or exceeded their price point.</li><li>Gawn is the big standout here – costing a whopping 2.6 million points across the competition. Hold fire on the trade though – he should come good.</li><li>Going with someone such as Sicily or Hewett instead of the underperforming defenders below would have gone a long way to helping your ranking. It would have been very easy to have all three of Crisp, Whitfield and Ridley in your side (ouch!).</li><li>Whilst some might be happy with a score of 112 from Oliver, you paid for 123 points!</li></ul>



<figure class="wp-block-table"><table><tbody><tr><td>First Name</td><td>Own</td><td>Score</td><td>Price</td><td>Exp. Score</td><td>Scoring +/-</td><td>Pain Points</td></tr><tr><td>Max Gawn</td><td>60%</td><td>92</td><td>$&nbsp; 657,400</td><td>121</td><td>-29</td><td>-2,639,519</td></tr><tr><td>Jack Crisp</td><td>40%</td><td>69</td><td>$&nbsp; 571,000</td><td>105</td><td>-36</td><td>-2,210,933</td></tr><tr><td>Jack Steele</td><td>36%</td><td>87</td><td>$&nbsp; 685,800</td><td>126</td><td>-39</td><td>-2,126,068</td></tr><tr><td>Lachie Whitfield</td><td>53%</td><td>73</td><td>$&nbsp; 502,600</td><td>92</td><td>-19</td><td>-1,577,941</td></tr><tr><td>Jordan Ridley</td><td>22%</td><td>68</td><td>$&nbsp; 537,100</td><td>99</td><td>-31</td><td>-1,055,316</td></tr><tr><td>Daniel Rich</td><td>11%</td><td>71</td><td>$&nbsp; 582,700</td><td>107</td><td>-36</td><td>-581,344</td></tr><tr><td>Clayton Oliver</td><td>32%</td><td>112</td><td>$&nbsp; 672,000</td><td>124</td><td>-12</td><td>-571,876</td></tr><tr><td>Tom Mitchell</td><td>8%</td><td>80</td><td>$&nbsp; 638,100</td><td>117</td><td>-37</td><td>-463,151</td></tr><tr><td>N. Naitanui</td><td>5%</td><td>63</td><td>$&nbsp; 627,400</td><td>115</td><td>-52</td><td>-385,149</td></tr><tr><td>Luke Ryan</td><td>9%</td><td>70</td><td>$&nbsp; 540,300</td><td>99</td><td>-29</td><td>-382,046</td></tr></tbody></table></figure>



Lastly, it is important to remember that one game does not make a trend.



The underperformers should revert back closer to their expected scoring and Matt Rowell probably won’t go 150+ each week (well, maybe).



By all means make a trade if you have an injury, but otherwise try to hold off on that annual Isaac Heeney trade at least until after round two before prices start to change.



FANCY A SAME-GAME MULTI? Topsport offer the best in the business, where the market odds ACTUALLY add up. Give it a try, compare to other bookies, and see the difference for yourself! <a rel="noreferrer noopener" href="https://www.topsport.com.au/?Referrer=SC%20Playbook" target="_blank">Use the code ‘SCPLAYBOOK’ when signing up</a>.



<figure class="wp-block-image size-large"><img loading="lazy" decoding="async" width="1024" height="575" src="http://13.210.220.211/wp-content/uploads/2022/01/TopSport-SC-Playbook-AFL-2048x1149-V2--1024x575.jpg" alt="" class="wp-image-1953956" srcset="https://blog.scplaybook.com.au/wp-content/uploads/2022/01/TopSport-SC-Playbook-AFL-2048x1149-V2--1024x575.jpg 1024w, https://blog.scplaybook.com.au/wp-content/uploads/2022/01/TopSport-SC-Playbook-AFL-2048x1149-V2--300x168.jpg 300w, https://blog.scplaybook.com.au/wp-content/uploads/2022/01/TopSport-SC-Playbook-AFL-2048x1149-V2--768x431.jpg 768w, https://blog.scplaybook.com.au/wp-content/uploads/2022/01/TopSport-SC-Playbook-AFL-2048x1149-V2--1536x862.jpg 1536w, https://blog.scplaybook.com.au/wp-content/uploads/2022/01/TopSport-SC-Playbook-AFL-2048x1149-V2--640x359.jpg 640w, https://blog.scplaybook.com.au/wp-content/uploads/2022/01/TopSport-SC-Playbook-AFL-2048x1149-V2--1200x673.jpg 1200w, https://blog.scplaybook.com.au/wp-content/uploads/2022/01/TopSport-SC-Playbook-AFL-2048x1149-V2--800x450.jpg 800w, https://blog.scplaybook.com.au/wp-content/uploads/2022/01/TopSport-SC-Playbook-AFL-2048x1149-V2-.jpg 2048w" sizes="(max-width: 639px) 98vw, (max-width: 1199px) 64vw, 770px" /></figure>

Data analysis, Rd 2: Breaking down the key stats

Discussion (1)