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 that his GPA will be on par with that of his classmates. He has earned the following GPAs in his courses to date: 4, 3, 3, 2, 2, 4, 4, 4, 4, 3, 3, 3, 3, 4, 2, 2, 3, 4, 4, and 3. The average GPA for pre-med students is 3.75. Using Excel, determine how close Trevor's GPA is to that average. (Round intermediate calculations to two decimal places.)
A) 14.67% higher than the average
B) 14.67% lower than the average
C) 17.19% higher than the average
D) 17.19% lower than the average

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, you would calculate the average with =AVERAGE(number1, [number2], …) which returns an answer of 3.2. To determine the difference, use the following formula: (Trevor's Average GPA - Average GPA of a pre-med student) / (Average GPA of pre-med student) = (3.2 - 3.75)/3.75 = -0.14666667 or 14.67% lower than the average of a pre-med student (Choice B).

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