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?

Question

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?

Quizplus · Accepted Answer

The Answer of 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?

The Data on the Scores Obtained by Students in Five