The Data on the Scores Obtained by Students in Five

question 45

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?

---

Definitions:

Loan Default

The failure to meet the legal obligations or conditions of a loan, such as not making scheduled payments on time.

Sarbanes-Oxley Act

A U.S. federal law enacted to protect investors from the possibility of fraudulent accounting activities by corporations.

Government Oversight

The monitoring and evaluation of activities by government agencies or legislative bodies to ensure compliance with laws, regulations, and policies.

Private Securities Litigation Reform Act

Legislation designed to protect companies from frivolous litigation concerning the securities market by imposing stricter requirements on plaintiffs.