The Data on the Scores Obtained by Students in Five

Essay

The data on the scores obtained by students in five different entrance exams have been collected from 50 colleges
and they are provided below. Create a PivotTable in Excel to display the number of students who took each exam
and the average score for students in each exam. $$\begin{array} { l l | l l } \text { Exams } & \text { Scores } & \text { Exams } & \text { Scores } \\\hline \text { SAT } & 520 & \text { MCAT } & 487 \\\text { ACT } & 400 & \text { GRE } & 267 \\\text { MCAT } & 580 & \text { GMAT } & 455 \\\text { GRE } & 280 & \text { SAT } & 528 \\\text { GMAT } & 540 & \text { GMAT } & 536 \\\text { ACT } & 356 & \text { GAT } & 469 \\\text { MCAT } & 520 & \text { GRE } & 455 \\\text { GRE } & 355 & \text { MCAT } & 520 \\\text { GMAT } & 480 & \text { GRE } & 489 \\\text { SAT } & 574 & \text { ACT } & 455 \\\text { GRE } & 396 & \text { MCAT } & 589 \\\text { GMAT } & 450 & \text { GRE } & 500 \\\text { ACT } & 420 & \text { GMAT } & 500 \\\text { MCAT } & 560 & \text { SAT } & 528 \\\text { GRE } & 297 & \text { GMAT } & 480 \\\text { GMAT } & 520 & \text { SAT } & 475 \\\text { SAT } & 489 & \text { GMAT } & 570 \\\text { GMAT } & 500 & \text { ACT } & 480 \\\text { SAT } & 566 & \text { MCAT } & 567 \\\text { GRE } & 451 & \text { GRE } & 546 \\\text { GMAT } & 460 & \text { GMAT } & 544 \\\text { ACT } & 422 & \text { GAT } & 420 \\\text { MCAT } & 550 & \text { GMAT } & 453 \\\text { GRE } & 310 & \text { SAT } & 510 \\\text { ACT } & 384 & \text { GRE } & 473\end{array}$$
a. Which exam did most students attempt?
b. Which exam has the highest average score?
c. Use the PivotTable to determine the exam attempted by the student with the highest score.What is the exam attempted by the student with the lowest score?