Trevor is about to enter his third year of a pre-med program and knows the program will continue to become more competitive. He needs to ensure his GPA will be on par with that of his classmates. He has earned the following GPAs in courses to date: 4, 3, 3, 2, 2, 4, 4, 4, 4, 3, 3, 3, 3, 4, 2, 2, 3, 4, 4, and 3. Using Excel, determine the Mode and the Median for his GPAs thus far.
A) GPA Mode is 3, and GPA Median is 4.
B) GPA Mode is 3.2, and GPA Median is 4.
C) GPA Mode is 4, and GPA Median is 3.
D) GPA Mode is 4, and GPA Median is 3.2.

Question

Quizplus · Accepted Answer

This question requires familiarity with data analysis and the use of Excel as a tool to calculate various items. The first task would be to copy the data into Excel. Next, to calculate the Mode, you would enter =MODE(number1, [number2], …) which returns an answer of 4. Lastly, to calculate the Median, you would enter =MEDIAN(number1, [number2], …) which returns an answer of 3. This makes choice C the correct choice. The remaining choices are incorrect because each contains at least one incorrect number, either switching the Mode or the Median or using the GPA Mean instead.

Trevor Is About to Enter His Third Year of a Pre-Med