★0 XP
Question 1 of 10
The MEDIAN function in excel returns the median, or middle value in a set of numbers. For example, =MEDIAN(B2:B4) would return 3.8 because if we put the numbers in order, 3.8 would be in the middle.
Type =MEDIAN(B2:B4) to continue.
Type =MEDIAN(B2:B4) to continue.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | STUDENT | GPA | ||
| 2 | Kip | 3.5 | ||
| 3 | Shelby | 4.0 | ||
| 4 | Harry | 3.8 | ||
| 5 |
fx