Question

Hi, please instruct to do this problem on EXCEL

Solution: 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.

Exams	Scores	Exams	Scores
SAT	520	MCAT	487
ACT	400	GRE	267
MCAT	580	GMAT	455
GRE	280	SAT	528
GMAT	540	GMAT	536
ACT	356	SAT	469
MCAT	520	GRE	455
GRE	355	MCAT	520
GMAT	480	GRE	489
SAT	574	ACT	455
GRE	396	MCAT	589
GMAT	450	GRE	500
ACT	420	GMAT	500
MCAT	560	SAT	528
GRE	297	GMAT	480
GMAT	520	SAT	475
SAT	489	GMAT	570
GMAT	500	ACT	480
SAT	566	MCAT	567
GRE	451	GRE	546
GMAT	460	GMAT	544
ACT	422	SAT	420
MCAT	550	GMAT	453
GRE	310	SAT	510
ACT	384	GRE	473

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?

Answer 1

ANSWER:-

BY USING EXCEL