The data on the scores obtained by students in 5 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 had taken up each exam and the average score for students in each exam.
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?
Correct Answer:
Verified
a. Most students attempted the GMAT ex...
View Answer
Unlock this answer now
Get Access to more Verified Answers free of charge
Q43: Growth is the primary focus for all
Q44: A consumer electronics company, after three months
Q45: The project lead in an MNC decides
Q46: A local search service company surveys on
Q47: A survey on the average pass percentage
Q49: The data on the distance walked per
Q50: Consider the below table and the line
Q51: The following table shows the average monthly
Q52: The data on the ranks assigned to
Q53: A research was conducted on a sample
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents