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:

Product Pullout

The process of removing a product from the market or discontinuing its sale, often due to poor performance, safety concerns, or changing market conditions.

Divesting

Divesting is the process of selling off part of a company's operations or assets as a strategic move to focus on core activities, raise capital, or streamline operations.

Corporate Branding

is the practice of promoting the brand name of a corporate entity, as opposed to specific products or services.

Product-related Branding

The strategy of marketing a product by associating it with a distinct brand identity, including name, logo, and design, to differentiate it from competitors.