1. The data on the scores obtained by students in five different entrance quiz 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 quiz and the average score for students in each quiz.

Exams	Scores	quiz	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

1. Which quiz did most students attempt?

2. Which quiz has the highest average score?

G19 fx A B D E TI G H Data: Private Transport 1 2 3 4 5 Public Transport 27 33 28 30 29 25 20 27 32 6 32 7 20 8 34 30 28 37 38 21 18 29 35 9 10 11 12 13 14 Question a: 15 16 17 Private Transportation: mean = median = 18 Public Transportation: 19 20 mean = median = Private Transportation: 21 22 Question b: 23 24 25 26 27 variance standard deviation = Public Transportation: variance standard deviation = 28 29 30 Question c: 31 32 33 34 Coment on the results: Your answer: 35 36 37 38 39 40