Back at the final 8, I asked everypony to 1) rank the other players in the game, and 2) post what they thought everypony else's rankings would be. I've finally stopped procrastinating and analyzed the data. Rainbow Dash and Rarity never answered my questions, and Queen Chrysalis only answered the first question, so I did the best that I could. I know this probably won't be interesting to anypony but me, but here's my analysis.
This image shows how everypony ranked everypony else. For example, Coco ranked Rarity first, Granny second, DJ third, etc.
Coco ranked as the most trusted overall (and this is without including Rarity's ranking), DJ was second, Granny third, Rarity fourth, Soarin fifth, Grand Pear sixth, and Queen was ranked the lowest.
This is a little bit harder to explain, but it basically shows how accurate everypony was about each other's rankings. For example, the 16 in the Soarin column, Queen Chrysalis row means that Soarin was off by 16 about Queen's ranking (the max is 18, so Soarin had no idea about Queen).
Coco was the most accurate overall, and was off on her guesses by only 4 places. Granny was the second most accurate, followed by DJ and Grand Pear, and Soarin was the least accurate.
Coco was also the hardest ranking for anypony else to guess. everypony was off on her by 10 places, mostly because nopony realized how close she was to Rarity. Queen was the second hardest to guess, followed by Granny and Grand Pear. everypony was able to read DJ and Soarin like a book.
While the last image showed how accurate everypony was about reading individual's ranking, this image shows how good everypony was at understanding the social hierarchy. The 3 in the Grand Pear column, Rarity row (and in the Granny Smith and Soarin columns) represents that these players thought Rarity was ranked the lowest on the tribe but she was actually ranked fourth. Similarly, the -3 in the Grand Pear column, Grand Pear row shows that Grand Pear thought he was three spots more popular than he really was.
Once again, Coco had an incredibly accurate read of the game, followed by DJ. Granny was in the middle, and Soarin and Grand Pear had the least accurate reads of the tribe hierarchy.
Rarity was the most underestimated pony in the game. Because of this, and because of her being the #1 of the dominant player in the game, it's not surprising that she made it to the final tribal council. DJ was also underestimated, and Queen Chrysalis and Grand Pear were overestimated.
Overall: We all know that Coco dominated the game, and this post just puts more evidence behind that. She was the most popular, had the most accurate read on the game, and nopony knew about all her connections (especially her relationship with Rarity).