excel

Enable Macros

asdf
	BMI
	Baseball

Enable Macros to Begin Assignment This assignment file relies on a set of macros to handle submission and scoring. Before you may begin the assignment, you must enable macros in this workbook. Depending the version of Excel and the security settings, you may see a prompt similar to those below. If you have already dismissed the prompt, you may need to close this workbook and open it again.

Unable to Begin Assignment This assignment is not currently available. Please contact your instructor for further information.

Unable to Begin Assignment To begin this assignment, this workbooks needs to verify that the assessment is currently open. You must have an active internet connection to enable this verification.

Please wait, exam initializing.

Assignment is Active You may begin work on the assignment now. Actually, you should not be seeing this message. If everything worked correclty, this will be invisible and the worksheets with the assignment will be showing.

BMI

	Survey of Men's Weight and Height					Summary Statistics
	Subject	Weight	Height	BMI
	1	185.22	72.74	24.61			Weight	Height	BMI
	2	173.09	69.03	25.53		Count
	3	173.24	70.21	24.71		Average
	4	155.81	68.76	23.17		Standard*
	5	162.83	70.94	22.75		95% CI**
	6	141.69	67.50	21.86
	7	194.85	76.92	23.15			Correlation
	8	201.81	70.74	28.35			Correlation coefficient --->
	9	136.98	63.36	23.99
	10	156.22	70.40	22.16			Forecast***
	11	194.71	70.61	27.46			Jim's Height (in inches) --->		70
	12	125.78	72.47	16.84			Predict Jim's Weight --->
	13	183.75	70.82	25.76
	14	128.15	71.02	17.86			Forecast Confidence Interval
	15	202.77	70.00	29.09			Lower Weight Bound --->
	16	154.39	70.06	22.11			Upper Weight Bound --->
	17	139.91	70.35	19.87
	18	200.67	72.92	26.53		* Note: the STDEV.S function is not available in Excel 2007. If you are using Excel 2007, use the STDEV funtion instead.
	19	206.44	72.77	27.41
	20	250.26	79.44	27.88
	21	153.79	70.09	22.01		** Note: the CONFIDENCE.NORM function is not available in Excel 2007. If you are using Excel 2007, use the CONFIDENCE function instead.
	22	219.13	72.38	29.41
	23	181.56	70.93	25.37
	24	166.69	70.58	23.53
	25	207.97	68.89	30.80		*** Note: the FORECAST.LINEAR function is not available prior to Excel 2016. If you are using a prior version of Excel, use the FORECAST function instead.
	26	119.41	71.43	16.45
	27	207.78	68.94	30.74
	28	168.17	68.88	24.92
	29	178.07	68.66	26.55
	30	187.84	71.56	25.78
	31	199.66	68.38	30.02
	32	208.32	70.92	29.11
	33	208.27	70.83	29.18
	34	205.41	70.76	28.84
	35	188.97	72.65	25.17
	36	181.26	69.16	26.64
	37	206.80	68.23	31.23
	38	166.96	67.23	25.97
	39	163.82	67.22	25.49
	40	174.02	69.59	25.27
	41	226.85	72.43	30.40
	42	141.77	71.42	19.54
	43	150.46	68.61	22.47
	44	173.39	67.14	27.04
	45	158.68	71.04	22.10
	46	164.49	71.33	22.73
	47	167.28	70.22	23.85
	48	178.51	70.50	25.25
	49	152.66	69.22	22.40
	50	181.85	71.58	24.95
	51	161.28	69.34	23.58
	52	158.09	69.71	22.87
	53	313.65	71.33	43.33
	54	217.80	70.53	30.78
	55	182.51	68.47	27.37
	56	201.80	72.66	26.87
	57	168.45	72.60	22.47
	58	166.85	71.28	23.08
	59	132.52	68.86	19.65
	60	155.31	70.22	22.14
	61	178.68	69.36	26.11
	62	157.60	70.27	22.44
	63	144.04	70.66	20.28
	64	140.40	68.52	21.02
	65	161.50	68.78	24.00
	66	177.42	69.22	26.03
	67	193.98	71.86	26.41
	68	127.04	69.27	18.61
	69	161.99	69.32	23.70
	70	154.78	68.37	23.28
	71	205.28	70.73	28.84
	72	137.58	71.10	19.13
	73	180.74	72.26	24.33
	74	156.74	70.88	21.93
	75	159.29	70.21	22.72
	76	163.61	69.95	23.51
	77	135.97	70.44	19.27
	78	194.95	72.85	25.82
	79	187.27	69.75	27.06
	80	167.65	69.91	24.11
	81	145.19	71.26	20.10
	82	175.32	66.72	27.69
	83	145.90	67.11	22.78
	84	147.99	68.94	21.89
	85	158.84	69.90	22.85
	86	133.72	69.57	19.42
	87	324.61	69.06	47.84
	88	116.12	69.11	17.09
	89	166.65	69.82	24.04
	90	133.19	68.40	20.01
	91	166.83	68.90	24.71
	92	234.30	76.64	28.04
	93	209.97	72.10	28.39
	94	192.20	68.68	28.64
	95	177.53	73.56	23.06
	96	160.10	70.15	22.87
	97	162.23	70.76	22.78
	98	142.59	69.73	20.62
	99	172.84	69.67	25.03
	100	173.53	69.95	24.93
	101	203.83	71.75	27.83
	102	176.53	68.75	26.25
	103	154.01	70.43	21.82
	104	195.47	68.38	29.38
	105	178.26	68.66	26.58
	106	195.97	68.63	29.25
	107	136.30	69.51	19.83
	108	136.60	67.73	20.93
	109	183.17	68.76	27.24
	110	139.87	70.10	20.01
	111	166.70	72.11	22.54
	112	182.58	68.19	27.60
	113	346.97	70.85	48.60
	114	201.21	72.89	26.62
	115	155.64	71.99	21.11
	116	169.18	72.66	22.53
	117	127.96	68.82	19.00
	118	130.98	69.95	18.82
	119	175.29	69.07	25.83
	120	153.05	67.19	23.83
	121	184.47	68.74	27.45
	122	174.01	68.18	26.31
	123	137.37	70.35	19.51
	124	155.44	67.00	24.34
	125	143.23	69.73	20.71
	126	151.47	72.66	20.17
	127	198.46	72.83	26.30
	128	146.49	69.95	21.05
	129	156.97	70.23	22.37
	130	162.52	71.20	22.54
	131	193.22	70.42	27.39
	132	170.11	72.57	22.71
	133	199.84	72.45	26.76
	134	173.08	70.48	24.50
	135	179.38	71.00	25.02
	136	161.66	72.11	21.85
	137	200.56	72.15	27.08
	138	203.29	72.20	27.42
	139	178.19	70.41	25.27
	140	196.96	68.51	29.50
	141	182.40	69.17	26.80
	142	156.70	67.78	23.98
	143	128.07	69.55	18.61
	144	155.96	70.22	22.24
	145	189.31	71.03	26.38
	146	155.85	68.62	23.27
	147	171.73	68.73	25.55
	148	157.78	67.42	24.40
	149	135.66	67.42	20.98
	150	187.63	71.06	26.12
	151	165.95	70.15	23.71
	152	175.64	69.60	25.49
	153	148.58	68.59	22.20
	154	207.53	69.64	30.08
	155	191.66	70.32	27.24
	156	190.91	71.29	26.41
	157	212.51	69.90	30.58
	158	217.84	70.41	30.89
	159	131.01	70.30	18.64
	160	155.26	71.03	21.63
	161	152.22	70.05	21.81
	162	133.03	69.35	19.45
	163	136.07	69.45	19.83
	164	157.78	68.47	23.66
	165	206.03	72.93	27.24
	166	190.31	72.94	25.15
	167	255.85	76.08	31.07
	168	181.47	68.81	26.95
	169	176.24	70.59	24.86
	170	160.75	69.04	23.71
	171	164.40	70.74	23.09
	172	180.34	68.65	26.90
	173	173.16	71.74	23.65
	174	194.04	71.30	26.83
	175	122.90	68.82	18.24
	176	181.26	71.09	25.22
	177	129.15	67.55	19.90
	178	167.34	67.43	25.87
	179	211.36	70.25	30.11
	180	218.92	70.25	31.19
	181	200.71	68.00	30.51
	182	122.90	67.80	18.79
	183	124.36	68.25	18.77
	184	179.55	71.17	24.92
	185	197.01	70.89	27.56
	186	174.77	68.90	25.88
	187	169.85	71.18	23.56
	188	208.79	69.33	30.53
	189	143.54	71.09	19.96
	190	153.48	69.72	22.20
	191	157.98	71.12	21.96
	192	152.88	69.41	22.31
	193	173.23	68.64	25.85
	194	168.29	71.18	23.35
	195	190.75	70.31	27.13
	196	161.66	68.05	24.54
	197	205.68	69.23	30.17
	198	192.53	69.58	27.96
	199	186.49	68.69	27.78
	200	139.13	69.95	19.99

Baseball

	Major League Baseball Salaries by Team							Statistical Analysis
	DIVISION	TEAM	2010 PAYROLL	1990 PAYROLL	2010 WINS	1990 Wins		Response		Task
	AL East	Baltimore Orioles	$81,612,500	$10,037,084	66	76				Number of MLB Teams in 1990
	AL East	Boston Red Sox	$162,447,333	$20,983,333	89	88
	AL East	New York Yankees	$206,333,389	$20,991,318	95	67				Number of MLB teams in 2010
	AL East	Tampa Bay Rays	$71,923,471	NA	96	NA
	AL East	Toronto Blue Jays	$62,234,000	$18,486,834	85	86				Average salary for the teams in 1990.
	AL Central	Chicago White Sox	$105,530,000	$9,496,238	88	94
	AL Central	Cleveland Indians	$61,203,966	$15,152,000	69	77				Average salary for the teams in 2010.
	AL Central	Detroit Tigers	$122,864,928	$18,092,238	81	79
	AL Central	Kansas City Royals	$71,405,210	$23,873,745	67	75				Population standard deviation* for wins 1990.
	AL Central	Minnesota Twins	$97,559,166	$15,106,000	94	74
	AL West	Los Angeles Angels	$104,963,866	$21,870,000	80	80				Population standard deviation* for wins in 2010.
	AL West	Oakland Athletics	$51,654,900	$19,987,501	81	103
	AL West	Seattle Mariners	$86,510,000	$12,841,667	61	77				Were teams more similar regarding wins in 1990 or 2010?
	AL West	Texas Rangers	$55,250,544	$15,104,372	90	83
	NL East	Atlanta Braves	$84,423,666	$13,328,334	91	65				Correlation between the number of wins a team earned in 2010 and the amount teams' salary amount.
	NL East	Florida Marlins	$57,029,719	NA	80	NA
	NL East	New York Mets	$134,422,942	$22,418,834	79	91
	NL East	Philadelphia Phillies	$141,928,379	$13,953,667	97	77				Correlation between the number of wins a team earned in 1990 and the amount teams' salary amount.
	NL East	Washington Nationals*	$61,400,000	$16,656,388	69	85
	NL Central	Chicago Cubs	$146,609,000	$14,496,000	75	77
	NL Central	Cincinnati Reds	$71,761,542	$14,769,500	91	91				Is the relationship between wins and salary stronger in 1990 or 2010?
	NL Central	Houston Astros	$92,355,500	$18,830,000	76	75
	NL Central	Milwaukee Brewers	$81,108,278	$20,019,167	77	74
	NL Central	Pittsburgh Pirates	$34,943,000	$15,656,000	57	95				How many wins could a team expect to earn in 2010 if they paid $150,000,000 in salary**?
	NL Central	St. Louis Cardinals	$93,540,751	$20,923,334	86	70		Salary Amount
	NL West	Arizona Diamondbacks	$60,718,166	NA	65	NA		$150,000,000
	NL West	Colorado Rockies	$84,227,000	NA	83	NA
	NL West	Los Angeles Dodgers	$95,358,016	$21,618,704	80	86				What is the 95% confidence interval*** for wins in 2010?
	NL West	San Diego Padres	$37,799,300	$18,588,334	90	75
	NL West	San Francisco Giants	$98,641,333	$20,942,333	92	85				Upper 95% confidence interval level.
	* The Washington Nationals were the Montreal Expos in 1990
	NA = The team did not exist in 1990									Lower 95% confidence interval level.
								* Note: the STDEV.P function is not available in Excel 2007. If you are using Excel 2007, use the STDEVP function instead.
								** Note: the FORECAST.LINEAR function is not available prior to Excel 2016. If you are using a prior version of Excel, use the FORECAST function instead.
								*** Note: the CONFIDENCE.NORM function is not available in Excel 2007. If you are using Excel 2007, use the CONFIDENCE function instead.