Madden NFL 17 - Player Ratings Visualized

[Hooe]

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:

Name	Color	Definition	Description
Black Chip		r ≥ μ+2σ	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.
Blue Chip		μ+σ ≤ r < μ+2σ	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.
Red Chip		μ ≤ r < μ+σ	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.
White Chip		μ-σ ≤ r < μ	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.
N/A		r < μ-σ	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.

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.

[un4gettable fire]

This is great, thanks! Really helps visualize where players stand compared to one another.

[manEATgod]

Thanks a lot sir.

[gosox2000]

Thanks a million. Great Work.

[richrolla]

Can't wait to get into this after work!

[SpaceBoyXVII]

Possible for you to upload this in excel format?

[Hooe]

Quote: Originally Posted by dtalley347

Possible for you to upload this in excel format?

I'm on OS X so I used Numbers to build this. It has an export to XLSX function, so I'll take a look at that this evening and if it spits out something which is reasonably similar to the original document I built I will absolutely push that up.

[SpaceBoyXVII]

Quote: Originally Posted by CM Hooe

I'm on OS X so I used Numbers to build this. It has an export to XLSX function, so I'll take a look at that this evening and if it spits out something which is reasonably similar to the original document I built I will absolutely push that up.

Thanks! It would be a lot easier to edit the rating in to 16. Already have QBs, K/Ps, and FBs done.