Solved

Match the Following Terms with the Corresponding Description

Question 25

Matching

Match the following terms with the corresponding description:

Premises:
RANK.EQ
QUARTILE.INC
RANK.AVG
PERCENTRANK.EXC
PERCENTRANK.INC
Responses:
Identifies the rank of a value but assigns an average rank when identical values exist.
Displays a value's rank as a percentile of the range of data in the dataset
Returns a value's rank as a percent excluding 0 and 1
Identifies the value at a specific quartile for a dataset, including quartile 0 for the lowest value and quartile 4 for the highest value in the dataset
Identifies a value's rank within a list of values

Correct Answer:

RANK.EQ
QUARTILE.INC
RANK.AVG
PERCENTRANK.EXC
PERCENTRANK.INC
Related Questions

Q20: Match the following terms with the corresponding

Q21: A(n)_ allows the user to select a

Q22: Match the following terms with the corresponding

Q23: The IIf function requires _ parameters.<br>A)0<br>B)1<br>C)2<br>D)3

Q24: Match the following descriptions, sections, and categories

Q26: Match the following terms to their descriptions:

Q27: The _ function is used to check

Q28: Match the following terms to their descriptions:

Q29: The DatePart function has _ required parameters.<br>A)1<br>B)2<br>C)3<br>D)4

Q30: Match the following terms to their meanings: