221k views
0 votes
Daniel has a list of numbers that are not in any order. He wants to find the order of the numbers with the help of a spreadsheet. Which statistical function will help him do so?

Mode
Rank
Median
Average

2 Answers

2 votes
Answer:
The rank function.
User Karmakaze
by
9.1k points
1 vote

Answer: Rank.

The RANK function in Microsoft Excel spreadsheet allows the user to rank the different data according to its numerical value. The rank function may also be used by setting an absolute value of the range of cells that the user would like to rank. If you do not set an absolute value, the rank of the different cells may change due to the auto-formula generated by the program itself.

User Jaco
by
8.4k points