Part 1. In Excel, for 2002 and 2007, make a scatterplot of the number of wins (Y-axis) and the average salary (X-axis) for the 2002 data, then make a second scattrplot for the 2007 data. Add the linear trendline to each scatterplot. Calculate the correlation coefficients for the variables in these two scatterplots. Which scatterplot has the highest correlation coefficient and what is the strength of the relationship (weak, moderate, strong, or very strong)? Why?

Part 2. In Excel, make a pivot table for Playoffs 2002 with Salaries 2002 and another one for the Playoffs 2009 with Salaries 2009. Place Playoffs in the Rows field and Salary in the Values field. Change the Values field to display Average Salary (using Value Field Settings). make a pivot chart for each pivot table. Did the teams that made it to the playoffs have higher average salaries? Describe any changes you observe in the salary data over the 7 years.

Team	Salary2002	Salary2003	Salary2004	Salary2005	Salary2006	Salary2007	Salary2008	Salary2009	Wins2002	Playoffs2002	Wins2003	Wins2004	Wins2005	Wins2006	Wins2007	Wins2008	Wins2009	2009Playoffs
ArizonaCardinals	$984,817	$1,286,269	$1,273,570	$1,142,376	$1,854,139	$1,731,488	$2,220,184	$1,984,619	5	No	4	6	5	5	8	9	10	Yes
AtlantaFalcons	$1,493,423	$1,347,004	$1,216,342	$1,674,356	$1,722,495	$1,374,514	$1,633,755	$1,728,417	9.5	Yes	5	11	8	7	4	11	9	No
BaltimoreRavens	$1,010,225	$1,263,782	$1,293,068	$1,371,822	$1,371,599	$1,784,851	$2,024,374	$1,795,138	7	No	10	9	6	13	5	11	9	Yes
BuffaloBills	$960,548	$1,290,753	$1,253,305	$1,552,449	$1,924,082	$1,842,066	$1,511,899	$1,765,923	8	No	6	9	5	7	7	7	6	No
CarolinaPanthers	$1,088,686	$1,314,342	$1,272,853	$1,206,877	$1,553,368	$1,627,375	$2,223,441	$1,947,645	7	No	11	7	11	8	7	12	8	No
ChicagoBears	$1,094,568	$854,758	$1,185,517	$1,225,088	$1,564,848	$1,796,402	$2,198,605	$2,154,859	4	No	7	5	11	13	7	9	7	No
CincinnatiBengals	$904,181	$1,526,022	$969,181	$1,226,908	$1,738,462	$1,563,955	$1,798,818	$1,617,941	2	No	8	8	11	8	7	4.5	10	Yes
ClevelandBrowns	$820,765	$1,250,073	$1,219,550	$1,478,817	$1,806,010	$1,677,576	$2,038,449	$1,647,933	9	Yes	5	4	6	4	10	4	5	No
DallasCowboys	$1,097,598	$1,028,999	$1,036,642	$1,563,684	$1,599,876	$1,731,396	$1,648,272	$1,613,231	5	No	10	6	9	9	13	9	11	Yes
DenverBroncos	$1,176,801	$1,373,598	$976,261	$1,265,151	$1,992,902	$1,952,292	$2,762,294	$1,918,089	9	No	10	10	13	9	7	8	8	No
DetroitLions	$960,138	$1,142,090	$1,455,056	$1,388,892	$1,628,942	$1,778,865	$1,597,119	$1,693,397	3	No	5	6	5	3	7	0	2	No
GreenBayPackers	$847,120	$1,206,721	$1,199,756	$1,011,565	$1,540,021	$1,600,882	$1,621,005	$1,909,660	12	Yes	10	10	4	8	13	6	11	Yes
HoustonTexans	$1,288,927	$1,108,450	$1,476,873	$1,385,485	$1,698,061	$1,487,194	$1,749,120	$2,037,644	4	No	5	7	2	6	8	8	9	No
IndianapolisColts	$1,095,478	$1,249,970	$1,397,109	$1,155,606	$2,261,892	$1,772,179	$1,638,139	$1,782,086	10	Yes	12	12	14	12	13	12	14	Yes
JacksonvilleJaguars	$826,060	$1,269,921	$1,045,116	$1,388,512	$1,526,008	$1,541,488	$1,907,956	$1,875,074	6	No	5	9	12	8	11	5	7	No
KansasCityChiefs	$1,066,518	$1,407,165	$1,343,137	$1,391,161	$1,434,176	$1,937,187	$1,520,432	$1,410,856	8	No	13	7	10	9	4	2	4	No
MiamiDolphins	$1,056,708	$1,070,463	$1,304,685	$1,074,883	$1,683,797	$1,624,090	$1,943,215	$2,225,542	9	No	10	4	9	6	1	11	7	No
MinnesotaVikings	$725,823	$1,530,712	$1,320,114	$1,400,097	$2,155,619	$1,616,876	$2,260,238	$1,919,269	6	No	9	8	9	6	8	10	12	Yes
NewEnglandPatriots	$796,464	$1,324,649	$1,149,241	$1,409,090	$1,695,331	$1,902,632	$1,520,231	$1,642,595	9	No	14	14	10	12	16	11	10	Yes
NewOrleansSaints	$1,004,886	$1,533,925	$1,182,646	$1,477,344	$1,542,734	$1,971,732	$2,267,790	$1,992,663	9	No	8	8	3	10	7	8	13	Yes
NewYorkGiants	$1,179,291	$1,183,717	$1,100,848	$1,396,990	$1,865,456	$1,221,861	$1,898,626	$2,470,623	10	Yes	4	6	11	8	10	12	8	No
NewYorkJets	$1,661,556	$1,214,208	$1,538,791	$1,202,217	$1,538,319	$1,666,192	$2,051,054	$2,079,904	9	Yes	6	10	4	10	4	9	9	Yes
OaklandRaiders	$1,447,097	$1,134,922	$1,208,893	$1,693,100	$1,217,324	$1,594,208	$2,539,823	$2,065,319	11	Yes	4	5	4	2	4	5	5	No
PhiladelphiaEagles	$1,463,029	$1,269,457	$1,566,826	$1,053,932	$1,807,698	$1,708,598	$1,956,382	$1,817,122	12	Yes	12	13	6	10	8	9.5	11	Yes
PittsburghSteelers	$1,470,405	$1,096,064	$1,257,339	$1,525,270	$1,593,864	$2,005,546	$2,111,722	$2,056,775	10.5	Yes	6	15	11	8	10	12	9	No
SanDiegoChargers	$1,083,151	$1,126,624	$1,121,368	$1,381,218	$1,720,388	$1,862,922	$2,032,970	$2,025,154	8	No	4	12	9	14	11	8	13	Yes
SanFrancisco49ers	$1,156,099	$1,043,436	$926,968	$1,285,220	$1,640,257	$1,811,476	$2,120,826	$1,957,339	10	Yes	7	2	4	7	5	7	8	No
SeattleSeahawks	$1,240,014	$1,432,572	$1,193,585	$1,314,576	$1,774,920	$1,760,359	$1,977,587	$1,649,552	7	No	10	9	13	9	10	4	5	No
St.LouisRams	$925,726	$1,380,782	$1,382,445	$1,622,647	$1,852,585	$1,777,986	$1,634,694	$1,661,798	7	No	12	8	6	8	3	2	1	No
TampaBayBuccaneers	$1,092,988	$1,376,323	$1,138,744	$1,250,347	$1,312,992	$1,509,316	$1,830,339	$1,458,497	12	Yes	7	5	11	4	9	9	3	No
TennesseeTitans	$987,810	$1,325,894	$1,197,028	$1,100,801	$1,497,013	$1,645,443	$2,291,226	$2,141,397	11	Yes	12	5	4	8	10	13	8	No
WashingtonRedskins	$940,756	$1,368,164	$1,638,365	$1,139,805	$1,935,798	$2,091,661	$1,964,275	$1,784,886	7	No	5	6	10	5	9	8	4	No
Coloringkey
Playoffteam	13
SuperBowlteam	13
SuperBowlwinner	13