Raw Data
- Quentin Heise
- Apr 28, 2022
- 2 min read
Updated: May 5, 2022
Here is my raw data for the project. In column A, we have the 32 NFL teams sorted alphabetically by conference (AFC and NFC). I then repeated the following eight columns for each of the years 2020-2011:
(Win) Number of wins
(Loss) Number of losses
(Tie) Number of ties
(Win %) Win percentage
(Win % Rank) Win percentage ordinal rank (note that for ties, the lowest ranking is put. For example, if three teams tied for 2nd place, they are listed as having received 4th)
(Win % Rank Change) Win percentage rank change (from the previous season)*
(Win % Rank Change Bottom 16) Win percentage rank change IF the team ranked in the bottom 16 for the previous season*
( ) Calculates the standard deviation of the above column (results in row 40). The higher numbers in this column, the more that teams contributed to the standard deviation*
*These were not calculated for the year 2011.
Starting in column CK, I calculated the overall average of each of the above (except for points seven and eight, this is because the bottom 16 teams changed annually) for the years 2020-2011.
Next, I calculated Chi-Squared. The data produced a 32x2 table of the wins and losses for each team. I compared this table to a 32x2 table where every entry was the number 80 (Not shown; if each team were equal, they would all have exactly a 50% win rate, 16 games per season and 10 seasons = 160 games total). The Chi-squared value was EXTREMELY significant at 217.65 (df 31; P < 10^(-5)). I conclude that NFL teams are completely unbalanced in terms of win percentages!
I also highlighted portions of some lines in yellow, from the win percentage rank of a team from one year to the win percentage rank of the following year. This is the team that, out of all the worst teams in terms of win percentage the previous year, this is the first team (starting from worst) that worsened their win percentage ranking the following year. For example, in 2019, the Jacksonville Jaguars were 23rd in terms of win percentage ranking. While the other eight worse teams improved their win percentage ranking in 2020, the Jaguars slipped to the bottom of the pack, at rank 32.
Next, I looked up the current general manager (GM) for each team and when they were hired. I then ranked them in terms of time tenured (a rank of one means the longest-tenured GM). This data is explored in a different post (GM Tenure vs. Win Percentages) about the correlation between GM tenure and the overall win percentages - raw and ordinal ranks.
Finally, I included the data I used to make the five graphs (explored in the post Graphs of Win Percentages).
コメント