dylantyler6412 dylantyler6412
  • 20-04-2021
  • Computers and Technology
contestada

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?

Respuesta :

MrRoyal
MrRoyal MrRoyal
  • 24-04-2021

Answer:

The rank function

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

Answer Link

Otras preguntas

What is Whites attitude towards Arthur in The story "Textual Evidence- informational Texts"
What makes connections between New York City, New York, and Paris, France?
George and Patty need a mortgage for $375,000 and they'd like the term length to be 30 years. They are debating between two loan options which at the surface, l
Find the sum of 9, x, squared, plus, 69x 2 6 and 2, x, squared, minus, x, minus, 102x 2 −x−10.
What is one of the challenges unique to telehealth use
Which two measurements are needed to calculate the speed of the car in this experiment?
Which statement about the Chernobyl disaster is NOT true?
At what temperature (in K) does CH₄ have a density of 0.812 g/L at 1.17 atm?
4x-1/2= x-4 what is the answer
Make a conjecture about the sum of any three even integers