Question

Team	League	Wins	ERA	BA	HR	SB	Errors	Built	Size	Attendance	Payroll
Pittsburgh Pirates	NL	57	5.00	0.242	126	87	127	2001	38496	1.61	34.9
San Diego Padres	NL	90	3.39	0.246	132	124	72	2004	42445	2.13	37.8
Oakland Athletics	AL	81	3.56	0.256	109	156	99	1966	34077	1.42	51.7
Texas Rangers	AL	90	3.93	0.276	162	123	105	1994	49115	2.51	55.3
Florida Marlins	NL	80	4.08	0.254	152	92	123	1987	36331	1.54	55.6
Arizona Diamondbacks	NL	65	4.81	0.250	180	86	102	1998	49033	2.06	60.7
Cleveland Indians	AL	69	4.30	0.248	128	91	110	1994	43345	1.39	61.2
Washington Nationals	NL	69	4.13	0.250	149	110	127	2008	41888	1.83	61.4
Toronto Blue Jays	AL	85	4.22	0.248	257	58	92	1989	50516	1.63	62.7
Tampa Bay Rays	AL	96	3.78	0.247	160	172	85	1990	36048	1.84	71.9
Kansas City Royals	AL	67	4.97	0.274	121	115	121	1973	40793	1.62	72.3
Cincinnati Reds	NL	91	4.01	0.272	188	93	72	2003	42059	2.06	72.4
Milwaukee Brewers	NL	77	4.58	0.262	182	81	101	2001	42200	2.78	81.1
Baltimore Orioles	AL	66	4.59	0.259	133	76	105	1992	48876	1.73	81.6
Colorado Rockies	NL	83	4.14	0.263	173	99	101	1995	50445	2.88	84.2
Atlanta Braves	NL	91	3.56	0.258	139	63	126	1996	50091	2.51	84.4
Houston Astros	NL	76	4.09	0.247	108	100	103	2000	40950	2.33	92.4
St. Louis Cardinals	NL	86	3.57	0.263	150	79	99	2006	49660	3.3	93.5
Los Angeles Dodgers	NL	80	4.01	0.252	120	92	98	1962	56000	3.56	94.9
Minnesota Twins	AL	94	3.95	0.273	142	68	78	2010	40000	3.22	97.6
San Francisco Giants	NL	92	3.36	0.257	162	55	73	2000	41503	3.04	97.8
Seattle Mariners	AL	61	3.93	0.236	101	142	110	1999	47116	2.09	98.4
Los Angeles Angels	AL	80	4.04	0.248	155	104	113	1966	45050	3.25	105
Chicago White Sox	AL	88	4.09	0.268	177	160	103	1991	40615	2.19	108.3
Detroit Tigers	AL	81	4.30	0.268	152	69	109	2000	41782	2.46	122.9
New York Mets	NL	79	3.70	0.249	128	130	87	2009	45000	2.56	132.7
Philadelphia Phillies	NL	97	3.67	0.260	166	108	83	2004	43647	3.65	141.9
Chicago Cubs	NL	75	4.18	0.257	149	55	126	1914	41118	3.06	146.9
Boston Red Sox	AL	89	4.20	0.268	211	68	111	1912	39928	3.05	162.7
New York Yankees	AL	95	4.06	0.267	201	103	69	2009	52325	3.77	206.3

1. At the .05 significance level, can we conclude that there is a difference in the mean payroll of teams in the American League versus teams in the National League?

- Can some one help me understand how to conduct this using excel

Answer 1