NFLTeamData19702009.xls

	A	B	C	D
1	This workbook has data on NFL team offensive statistics from 1970 to 2009 used in my paper, "Explaining More Passing as a Rational Response to Decreased Risk."
2
3	Humberto Barreto
4	hbarreto@depauw.edu
5
6	Data Source:
7	http://www.databasefootball.com/leagues/leaguelist.htm
8
9	The Data sheet has the raw data; the PT sheet uses Excel's PivotTable to create various tables (crosstabs) for analysis.
10	The red columns in the Data sheet indicate values that were added to the original data.
11		PASS YDS = yards from passing - sack yards
12		Adj Yards Passing follows Carroll, Palmer, Thorn, The Hidden Game of Football (1988) = PASS YDS + 10TDs Passing - 45Interceptions
13	The PTAdj sheet uses Adjusted Passing Yards instead of raw (unadjusted) Passing Yards.
14
15
16	To get yards (or any other variable) per game, we must adjust for the number of games played in a season.
17
18	Number of regular season games per team
19	1935-1936	12 games
20	1937-1942	11 games
21	1943-1945	10 games
22	1946	11 games
23	1947-1960	12 games
24	1961-1977	14 games
25	1978-1981	16 games
26	1982	9 games (strike)
27	1983-86	16 games
28	1987	15 games (strike)
29	1988-present	16 games
30
31				Use this column to find yards (or any other team variable) per game
32	Year	Games per Team	Teams	Games
33	1970	14	26	182
34	1971	14	26	182
35	1972	14	26	182
36	1973	14	26	182
37	1974	14	26	182
38	1975	14	26	182
39	1976	14	28	196
40	1977	14	28	196
41	1978	16	28	224
42	1979	16	28	224
43	1980	16	28	224
44	1981	16	28	224
45	1982	9	28	126
46	1983	16	28	224
47	1984	16	28	224
48	1985	16	28	224
49	1986	16	28	224
50	1987	15	28	210
51	1988	16	28	224
52	1989	16	28	224
53	1990	16	28	224
54	1991	16	28	224
55	1992	16	28	224
56	1993	16	28	224
57	1994	16	28	224
58	1995	16	30	240
59	1996	16	30	240
60	1997	16	30	240
61	1998	16	30	240
62	1999	16	31	248
63	2000	16	31	248
64	2001	16	31	248
65	2002	16	32	256
66	2003	16	32	256
67	2004	16	32	256
68	2005	16	32	256
69	2006	16	32	256
70	2007	16	32	256
71	2008	16	32	256
72	2009	16	32	256
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100