Question

nancy needs to find the average of two numbers in the middle from an even count of numbers arranged in descending order. which statistical function should she use in the spreadsheet?
a. mode
b. rank
c. min
d. average
e. median

Explanation:

The median is the middle value of a set of data. When there is an even count of numbers, the median is calculated as the average of the two middle - numbered values. The mode is the most frequently occurring value. The rank is used to determine the position of a value in a sorted list. The min gives the smallest value. The average (mean) is the sum of all values divided by the number of values. Since Nancy needs to find the average of the two middle numbers (which is the definition of median for an even - numbered data set), the median function is appropriate.

Answer:

E. Median