Essay
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
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
Q8: A chart that is recommended as an
Q17: Making visual comparisons between categorical variables is
Q41: A two-dimensional graph representing the data using
Q54: Growth is the primary focus for all
Q55: Deleting the grid lines in the table
Q56: The regional manager of a company wishes
Q57: The data on the ranks assigned to
Q58: In designing an effective table,<br>A) avoid the
Q59: To summarize and analyze data with both
Q60: The following table shows the average monthly