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

Which formula represents a compound whose molecules are tetrahedral? (A) BH₃ (B) C₂H₂ (C) CH₄ (D) H₂O (E) C₂H6₆
Identify the joint injury that occurs often form natural wear and tear. a. Dislocation b. Arthritis c. Bursitis d. Bunions
The product of two consecutive positive integers is 27 more than 5 times the larger
a butterfly has a wingspan of 66mm and a height of 6cm which i greater its wingspan or its height
How to find next number in this sequence. 2,7,26,101,400?
Describe the primordial soup theory
How did the democracy of Athens influence the American government?
how did the British navy cause economic hardship for the colonies?
Describe the primordial soup theory
what river located in southwest china was the boundary of the shang dynasty