excel assignment

Real Estate 17e

Team	League	Year Opened	Team Salary	Attendance	Wins	ERA	BA	HR		Year	Average Salary (millions)			PART I TASKS:	Compute the mean number of home runs per game. To do this, first find the mean number of home runs per team. Next, divide this value by 162 (a season comprises 162 games); then multiply by 2 because there are two teams in each game. Use the Poisson distribution to estimate the number of home runs that will be hit in a game. Find the probability:
Arizona	National	1998	70.76	2036216	69	5.09	0.261	190		2000	1.99					3 points
Atlanta	National	1996	87.62	2020914	68	4.51	0.255	122		2001	2.26
Baltimore	American	1992	115.59	2172344	89	4.22	0.256	253		2002	2.38
Boston	American	1912	182.16	2955434	93	4.00	0.282	208		2003	2.56
Chicago Cubs	National	1914	116.65	3232420	103	3.15	0.256	199		2004	2.49
Chicago Sox	American	1991	98.71	1746293	78	4.10	0.257	168		2005	2.63				1) There are no home runs in a game.	7 points
Cincinnati	National	2003	116.73	1894085	68	4.91	0.256	164		2006	2.87				2) There are two home runs in a game.	7 points
Cleveland	American	1994	86.34	1591667	94	3.84	0.262	185		2007	2.94				3) There are at least 4 home runs in a game.	7 points
Colorado	National	1995	98.26	2602524	75	4.91	0.275	204		2008	3.15
Detroit	American	2000	172.28	2493859	86	4.24	0.267	211		2009	3.24
Houston	American	2000	69.06	2306623	84	4.06	0.247	198		2010	3.30			PART II TASKS:	1) The mean attendance per team for the season was 2.439 million, with a standard deviation of 0.618 million. Use the normal distribution to estimate the number of teams with attendance of more than 3.5 million. Compare that estimate with the actual number. Comment on the accuracy of your estimate.
Kansas City	American	1973	112.91	2557712	81	4.21	0.261	147		2011	3.31					8 points
LA Angels	American	1966	146.45	3016142	74	4.28	0.26	156		2012	3.44
LA Dodgers	National	1962	223.35	3703312	91	3.70	0.249	189		2013	3.65
Miami	National	2012	84.64	1712417	79	4.05	0.263	128		2014	3.95
Milwaukee	National	2001	98.68	2314614	73	4.08	0.244	194		2015	4.25				2) The mean team salary was $121 million, with a standard deviation of $40.0 million. Use the normal distribution to estimate the number of teams with a team salary of more than $100 million. Compare that estimate with the actual number. Comment on the accuracy of your estimate.
Minnesota	American	2010	108.26	1963912	59	5.08	0.251	200		2016	4.40					8 points
NY Mets	National	2009	99.63	2789602	87	3.58	0.246	218
NY Yankees	American	2009	213.47	3063405	84	4.16	0.252	183
Oakland	American	1966	80.28	1521506	69	4.51	0.246	169
Philadelphia	National	2004	133.05	1915144	71	4.63	0.24	161
Pittsburgh	National	2001	85.89	2249021	78	4.21	0.257	153
San Diego	National	2004	126.37	2351426	68	4.43	0.235	177
San Francisco	National	2000	166.50	3365256	87	3.65	0.258	130
Seattle	American	1999	122.71	2267928	86	4.00	0.259	223
St. Louis	National	2006	120.30	3444490	86	4.08	0.255	225
Tampa Bay	American	1990	73.65	1286163	68	4.20	0.243	216
Texas	American	1994	144.31	2710402	95	4.37	0.262	215
Toronto	American	1989	112.90	3392299	89	3.78	0.248	221
Washington	National	2008	166.01	2481938	95	3.51	0.256	203

FICO Residual Plot

FICO

Type code Residual Plot

Type code

Normal Probability Plot

Sample Percentile