Chat with AIExam 3: Data Visualization
Exam 1: Introduction30 Questions
Exam 2: Descriptive Statistics60 Questions
Exam 3: Data Visualization61 Questions
Exam 4: Linear Regression60 Questions
Exam 5: Time Series Analysis and Forecasting58 Questions
Exam 6: Data Mining60 Questions
Exam 7: Spreadsheet Models60 Questions
Exam 8: Linear Optimization Models60 Questions
Exam 9: Integer Linear Optimization Models60 Questions
Exam 10: Nonlinear Optimization Models60 Questions
Exam 11: Monte Carlo Simulation59 Questions
Exam 12: Decision Analysis60 Questions
Select questions type
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?
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? (Essay)
4.8/5 
(38)
(38) 
Filters
- Essay(0)
- Multiple Choice(0)
- Short Answer(0)
- True False(0)
- Matching(0)