Excel explination

profileRedhand
CA1_Scores.xlsx
Home>Information Systems homework help>Excel explination

DataAnalysis

Enter Your 8-digit Student ID 23791666
Enter Your Name Ibrahim Alsuroor
Student Exam 1 Score Exam 2 Score Total Score Score Percentage
Ibrahim Alsuroor 73.66 75.90 149.56 74.78%
William Bloom 50.00 91.00 141.00 70.50%
Christina Diaz 89.00 43.00 132.00 66.00%
Olivia Neal 92.00 99.00 191.00 95.50%
Noah Salinas 42.00 68.00 110.00 55.00%
Daniel Joyce 84.00 90.00 174.00 87.00%
Olivia Engel 86.00 87.00 173.00 86.50%
Paul Knapp 59.00 72.00 131.00 65.50%
Aaron Gee 89.00 61.00 150.00 75.00%
Helen Shaver 70.00 72.00 142.00 71.00%
Average 73.47 75.89 149.36 74.68%

Raw_Data

ID Name Exam_1 Exam_2
0 Margaret Perry 98 77
1 Ethan Rosenberg 53 65
2 Alice Ames 52 85
3 Michael Willis 75 84
4 Melissa Woodward 47 73
5 Samuel Dominguez 69 81
6 Keith Coon 91 58
7 Jonathan Vinson 73 80
8 Brittany Lester 42 79
9 Ethan Leal 85 50
10 Anthony Burnett 80 100
11 Donald Valentine 77 42
12 Ashley Bloom 38 98
13 Joseph Proctor 71 100
14 Julie Shaver 64 46
15 Adam Sheffield 73 71
16 Randy Kirkland 71 95
17 Madison Lockett 36 95
18 Adam Pennington 37 79
19 Kathy Steward 98 74
20 Jennifer Pina 61 77
21 Grace Crosby 58 58
22 Brian Bryan 80 75
23 Jose Olsen 91 95
24 Christopher Sapp 100 49
25 Dennis Lester 91 69
26 Marilyn Christiansen 39 58
27 Douglas Christiansen 53 90
28 Joe Briggs 80 60
29 Judy Avila 65 60
30 Aaron Pineda 96 98
31 Aaron Roberson 45 68
32 Samuel Avila 92 53
33 Christian Joyce 36 94
34 Ruth Whitt 98 59
35 Patricia Zamora 51 52
36 Olivia Shook 88 83
37 James Murray 55 73
38 Karen Cochran 95 56
39 Emma McClendon 58 90
40 Ruth Summers 71 50
41 Nathan Gabriel 54 44
42 Wayne Hooks 81 85
43 Billy Ames 47 43
44 Samantha Gage 62 47
45 Peter Riddle 75 51
46 Judith Edmonds 74 91
47 Timothy Sapp 62 54
48 Maria Summers 37 40
49 Randy Foley 63 46
50 Albert Wynn 38 61
51 Anna Boyer 39 71
52 Beverly Briggs 89 68
53 Heather Hendrix 85 62
54 Stephen Cervantes 60 73
55 Timothy Graves 35 59
56 Lisa Gomes 93 45
57 Judith Waller 53 58
58 Margaret Hammer 43 47
59 Jacqueline Cormier 74 73
60 Walter Raymond 55 61
61 Evelyn Rosen 69 45
62 Susan Kenny 84 98
63 Brenda Riggs 91 56
64 Alexander Brandt 47 45
65 Marie Curtis 100 90
66 Kenneth Crosby 75 62
67 Noah Tracy 93 93
68 Catherine Brewster 37 78
69 Shirley Rowell 98 49
70 Doris Graves 87 80
71 David Raymond 50 92
72 Catherine Costa 99 85
73 Robert Crosby 82 89
74 Vincent Marquez 92 66
75 Wayne Burnett 61 42
76 Carl Hope 39 83
77 Alice Hollis 87 52
78 Virginia Soto 65 40
79 Jason Gilmore 74 84
80 Edward Lowery 69 78
81 Maria Raymond 100 95
82 Lawrence Cody 52 73
83 Austin Hutchins 66 70
84 Jason Floyd 56 83
85 Timothy Burton 59 82
86 Alexander Buchanan 87 97
87 Patricia Villa 46 95
88 Gerald Brewster 69 95
89 Jessup Martin 89 70
90 Thomas Hutchins 58 48
91 Marie Sexton 58 59
92 Teresa Rowell 87 80
93 Danielle Lusk 96 61
94 Rebecca Salas 72 85
95 Linda Salas 72 40
96 Samuel Hammer 69 60
97 Alice Foley 70 46
98 Howard Raymond 78 53
99 Rachel Guthrie 71 48
100 Christina Curtis 35 68
101 Elizabeth Krause 36 100
102 Bryan Neal 45 89
103 Gloria Cooley 55 70
104 Kenneth Salinas 60 71
105 Emily Wynn 88 87
106 Virginia Floyd 56 41
107 Ethan Ziegler 96 62
108 Kelly Cody 81 46
109 Kimberly Palmer 53 57
110 Margaret Seay 62 66
111 Joe Pugh 40 42
112 Theresa Fry 87 99
113 Andrew Floyd 62 88
114 Bryan Reynolds 67 42
115 Ryan Bryan 52 73
116 Jessica Shields 76 46
117 Gerald Wright 70 87
118 Catherine Gabriel 36 77
119 Andrea Graves 40 77
120 Hannah Roberson 58 72
121 Harold Burris 67 95
122 Arthur Butler 71 65
123 Nancy Martinez 80 52
124 Gary Hendrix 97 42
125 Anna Gordon 82 74
126 Sharon Olsen 42 77
127 Bryan Maloney 65 81
128 Joshua Seay 91 43
129 Roy Salas 69 85
130 Melissa Trent 70 54
131 Jessica Cherry 75 95
132 Janice McNeill 51 63
133 Nancy Fitzpatrick 86 89
134 Samuel Ames 50 93
135 Jacob Baker 69 76
136 Virginia Tracy 96 65
137 Juan Byrd 65 84
138 Bruce Cochran 64 95
139 Daniel McPherson 71 57
140 Jennifer Fernandez 39 63
141 Sarah Odell 65 43
142 Betty Guthrie 94 70
143 Sandra Maynard 48 82
144 Kathryn Salas 41 51
145 Jeremy Garner 99 76
146 Mary Sapp 55 74
147 Randy Avila 43 75
148 Maria Sheffield 91 90
149 Arthur Waller 93 100
150 Dennis Paige 68 94
151 Daniel Wolff 37 55
152 John Watkins 55 49
153 Ralph Seay 38 43
154 Janet Roberson 92 93
155 Beverly Santiago 45 66
156 Gerald Cormier 86 69
157 Nancy Fry 57 87
158 Andrew Bryan 86 72
159 Stephen Bryant 61 64
160 Gerald Brandt 50 43
161 Dennis Fernandez 97 47
162 Debra Hardy 82 48
163 Nicole Briggs 85 67
164 Henry Rosen 53 79
165 Eric Martinez 75 79
166 William Bloom 50 91
167 Christina Diaz 89 43
168 Olivia Neal 92 99
169 Noah Salinas 42 68
170 Daniel Joyce 84 90
171 Olivia Engel 86 87
172 Paul Knapp 59 72
173 Aaron Gee 89 61
174 Helen Shaver 70 72
175 Nathan Ortiz 92 96
176 George Leach 90 42
177 Carol Carver 56 84
178 Jeffrey Shannon 67 58
179 Stephen Andrade 60 40
180 Helen Guzman 62 76
181 Andrew Fry 68 81
182 Alice Sheffield 92 96
183 Russell Egan 72 57
184 Jose Soto 40 65
185 Andrea Gilmore 55 59
186 Jacob Kenny 64 63
187 Kevin Hooks 58 45
188 Melissa McNeill 77 53
189 Angela Bryant 85 75
190 Philip Herbert 59 51
191 Julie Bennett 83 98
192 Gerald Browning 91 87
193 Bruce Valentine 92 80
194 Victoria Barajas 99 63
195 Janice Willis 82 72
196 Austin Burnett 92 88
197 Ruth Watkins 96 72
198 Keith Graves 36 55
199 Nancy Palmer 71 45
200 Kathryn Bain 43 86
201 Zachary Trent 57 41
202 Brenda Hammer 74 93
203 Alice Waller 65 92
204 Madison Hankins 45 66
205 Deborah Burton 73 92
206 Tammy Neal 96 100
207 Olivia Raymond 58 84
208 Frances Dickson 95 93
209 Sara Cooley 64 81
210 Emma Briggs 76 87
211 Jennifer Pennington 98 87
212 Joseph McDowell 86 44
213 Martha Valencia 58 79
214 Jerry Shannon 53 42
215 Keith Sheffield 74 49
216 Scott Dixon 93 79
217 Jason Joyce 55 57
218 Diane Vinson 59 97
219 Jerry Whitten 71 49
220 Jacob Hendrix 90 47

Sheet1

Student Exam 1 Score Exam 2 Score Total Score Score Percentage
Ibrahim Alsuroor ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
William Bloom 50.00 91.00 141.00 70.50%
Christina Diaz 89.00 43.00 132.00 66.00%
Olivia Neal 92.00 99.00 191.00 95.50%
Noah Salinas 42.00 68.00 110.00 55.00%
Daniel Joyce 84.00 90.00 174.00 87.00%
Olivia Engel 86.00 87.00 173.00 86.50%
Average ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!