Joseph is a business student at a local university. He is looking over his transcripts to determine how his performance looks so far. He pulled the following report from his profile on the University's Student Information section: At his University, A = 4, B = 3, C = 2, D = 1, and F = 0. What are the average value, mode, and median for Joseph's GPA values so far?
A) Average = 2.90; Mode = 3; and Median = 4
B) Average = 2.90; Mode = 4; and Median = 3
C) Average = 2.95; Mode = 3; and Median = 4
D) Average = 2.95; Mode = 4; and Median = 3

Question

Joseph is a business student at a local university. He is looking over his transcripts to determine how his performance looks so far. He pulled the following report from his profile on the University's Student Information section:  At his University, A = 4, B = 3, C = 2, D = 1, and F = 0. What are the average value, mode, and median for Joseph's GPA values so far?
A) Average = 2.90; Mode = 3; and Median = 4 
B) Average = 2.90; Mode = 4; and Median = 3 
C) Average = 2.95; Mode = 3; and Median = 4 
D) Average = 2.95; Mode = 4; and Median = 3

Quizplus · Accepted Answer

This question requires familiarity using Excel to calculate key statistics. To solve for each, you will need to use an appropriate function on the values in cells C2 through C21. The functions to calculate each of the desired outcomes are: =AVERAGE(C2:C21) that returns 2.95; =MODE(C2:C21) that returns 4; and =Median(C2:C21) that returns 3 (Choice D).

Joseph Is a Business Student at a Local University