Question

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?

Answer 1

The rank function

Step-by-step explanation:

Required

Function to find the order of a list

In a spreadsheet application (say Microsoft Office Excel), the rank function are used to execute what Daniel wants to achieve with the list of numbers (i.e. determine their order)

The syntax to do use this function is:

=RANK (number, ref, [order])

Where

number = the number to rank

ref = The range to rank

order = Whether to rank in ascending or descending order