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:

Bargain Purchase Option

A lease clause allowing the lessee to purchase the leased asset at a price significantly lower than its expected fair market value at the end of the lease term.

Leased Asset's Useful Life

The expected period over which a leased asset is anticipated to be used by the lessee, often corresponding to the lease term unless a shorter period is more representative.

Minimum Lease Payments

The lowest amount that a lessee is expected to pay over the lease term, including both principal and interest components.

Direct Financing Lease

A type of lease arrangement where the lessor purchases an asset for the lessee and rents it out, effectively acting as a financing tool.