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:

Pre-emptive Rights

The rights granted to shareholders to purchase additional shares in a company before the shares are offered to the public, to maintain their proportionate ownership.

Due Diligence

The thorough investigation or exercise of care that a reasonable business or person is expected to take before entering into an agreement or contract with another party.

Legal Entity

An organization or entity that is legally recognized as having rights and responsibilities separate from its members or owners, such as corporations, trusts, and partnerships.

Directors Responsibility

The legal obligations that board directors have to manage a company's affairs diligently, in good faith, and in the best interests of the company and its shareholders.