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? 1.mode 2.rank 3.min 4.average 5.median

The correct answer is (5) Median

Average of numbers given in a series give the mean of all those numbers. We can find the mean or average by simply adding all the numbers and then divide them by the total number of numbers given in the series. But if we are supposed to find the average of two numbers present in the middle of the series then we will use median because it gives us the middle value of any particular numbers. Therefore the correct answer is Median

a) click on any cells in the range of data

b) click the data

c) click sort& filter group, click sort

d) select the column to sort by and then select a sort order

e) select the next column to sort by and select the sort order

f) click ok