The following post is very similar to this one a couple years ago for Madden NFL 15. A few people found it helpful, and I was bored this evening, so I've repeated that work for Madden NFL 17. Hopefully you still find it helpful if you did before, and if you didn't see before, well here you go.
Now please forgive me while I plagiarize myself.
---
If you're like me, you learn better and process information more quickly when things are presented visually. A spreadsheet full of numbers is an incredibly dense thing which is hard to gloss over. Thus, quickly making comparisons between players in the Madden NFL 17 ratings reveal was a bit of a painful exercise.
I made the following document in an attempt to aid myself to this end. First thing I did was to group together all the players at each position. Then, for each rating for each player (divided into individual position groups), I calculated the cumulative normal distribution and finally color-coded the result.
Color key is as follows:
Included in the ZIP are two PDFs - one sorted by OVR per-position, and one sorted by team then OVR per-position.
Hopefully at least one person finds the product of my boredom useful, haha.
Now please forgive me while I plagiarize myself.
---
If you're like me, you learn better and process information more quickly when things are presented visually. A spreadsheet full of numbers is an incredibly dense thing which is hard to gloss over. Thus, quickly making comparisons between players in the Madden NFL 17 ratings reveal was a bit of a painful exercise.
I made the following document in an attempt to aid myself to this end. First thing I did was to group together all the players at each position. Then, for each rating for each player (divided into individual position groups), I calculated the cumulative normal distribution and finally color-coded the result.
Color key is as follows:
<table width="600"><tr><th style="width:10%;">
Name
</th><th style="width:2.5%;">Color
</th><th style="width:15%;">Definition
</th><th style="width:30%;">Description
</th></tr><tr><td>Black Chip
</td><td bgcolor="535353"> </td><td>r ≥ μ+2σ
</td><td>Player's rating is at least two standard deviations above the mean rating for this category and position; i.e. the player has a great rating in this category relative to peers at his position.</td></tr><tr><td>Blue Chip
</td><td bgcolor="88ccff"> </td><td>μ+σ ≤ r < μ+2σ
</td><td>Player's rating is at least one standard deviation above the mean rating for this category and position; i.e. the player has a good rating in this category relative to peers at his position.</td></tr><tr><td>Red Chip
</td><td bgcolor="ff9781"> </td><td>μ ≤ r < μ+σ
</td><td>Player's rating is at or above the mean rating for this category and position; i.e. the player has an average rating in this category relative to peers at his position.</td></tr><tr><td>White Chip
</td><td bgcolor="ffffff"> </td><td>μ-σ ≤ r < μ
</td><td>Player's rating is below the mean rating for this category and position; i.e. the player has a below-average rating in this category relative to peers at his position.</td></tr><tr><td>N/A
</td><td bgcolor="dddddd"> </td><td>r < μ-σ
</td><td>Player's rating is at least one standard deviation below the mean for this category and position,i.e. the player has a poor rating in this category relative to peers at his position.</td></tr></table>Included in the ZIP are two PDFs - one sorted by OVR per-position, and one sorted by team then OVR per-position.
Hopefully at least one person finds the product of my boredom useful, haha.
(because the conditional formatting rules which color-code the cells for each rating are the entire point)
Comment