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.
ExamsScores
ExamsScores
SAT520
MCAT487
ACT400
GRE267
MCAT580
GMAT455
GRE280
SAT528
GMAT540
GMAT536
ACT356
SAT469
MCAT520
GRE455
GRE355
MCAT520
GMAT480
GRE489
SAT574
ACT455
GRE396
MCAT589
GMAT450
GRE500
ACT420
GMAT500
MCAT560
SAT528
GRE297
GMAT480
GMAT520
SAT475
SAT489
GMAT570
GMAT500
ACT480
SAT566
MCAT567
GRE451
GRE546
GMAT460
GMAT544
ACT422
SAT420
MCAT550
GMAT453
GRE310
SAT510
ACT384
GRE473
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?
What will be an ideal response?
a. Most students attempted the GMAT exam. The PivotTable shows that the GMAT
exam has the greatest number of students with 13 students.
b. MCAT has the highest average score of 547 (approx.).
c. By changing the Value Field Settings for Scores from Average to Max, we see that
MCAT has the highest score of 589. By changing the Value Field Settings for Scores to Min, we see that GRE has the least score of 267.
You might also like to view...
On January 1, 2016, Sharpsburg, Inc issued $400,000, 10-year, 10% bonds for $354,200 . The bonds pay interest on June 30 and December 31 . The market rate is 12%. The cash payment on June 30, 2016, is
a. $20,000. b. $21,200. c. $24,000. d. $17,710.
Which of the following is not an enhancing qualitative characteristic?
A) Verifiability B) Timeliness C) Understandability D) Neutrality
Describe the primary goal of the recruiting process.
What will be an ideal response?
Raptor Company is considering replacing equipment which originally cost $500,000 and which has $460,000 accumulated depreciation to date. A new machine will cost $790,000 and the old equipment can be sold for $8,000. What is the sunk cost in this situation?
A) $53,000 B) $40,000 C) $37,000 D) $290,000