Analyzing Student Data

	A	B	C	D	E	F	G	H
1	Last	First	Test 6	Test 7	Test 8	Test 9	Test 10	Average Score for each Student

2	Abzug	Bella	212	215	218	220	220	217
3	Borne	Jason	170	180	200	210	215	195
4	Clinton	Hillary	210	220	210	215	225	216
5	Daniels	Charlie	150	160	170	180	190	170
6	Estrada	Eric	150	165	180	185	200	176
7	Farmer	Fanny	195	200	210	220	230	211
8	Gandhi	Indira	180	190	200	225	250	209
9	Hepburn	Katherine	120	180	160	170	180	162
10	Isabella	Queen	135	138	140	155	150	143.6
11	Jackson	Stonewall	150	154	160	165	189	163.6
12	Kamakawiwo'ole	Israel	210	230	240	250	255	237
13	Lee	Jason	175	180	190	189	196	186
14	Marshall	Thurgood	168	175	180	195	205	184.6
15	Nin	Anais	169	180	185	193	202	185.8
16	Owens	Terrell	168	180	190	210	225	194.6
17	Pound	Ezra	205	210	219	205	210	209.8
18	Quayle	Dan	170	175	190	201	215	190.2
19	Rand	Ayn	200	210	218	219	223	214
20	Scott	Walter	140	143	145	143	150	144.2
21	Twain	Shania	193	203	208	210	220	206.8
22	Underwood	Blair	169	180	201	210	208	193.6
23	Vincent	Jan	175	185	193	199	215	193.4
24	Washington	George	215	230	231	235	245	231.2
25	X	Malcolm	195	210	215	220	232	214.4
26	Yamaguchi	Kristi	174	186	190	193	199	188.4
27	Zellweger	Renee	140	146	158	160	170	154.8
28	Average Score for each test		174.54	185.58	192.35	199.12	208.42
29	Overall average for all test		192
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
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