Solved

Match the Following Terms with the Corresponding Description

Question 78

Matching

Match the following terms with the corresponding description:

Premises:
PERCENTRANK.INC
PERCENTRANK.EXC
QUARTILE.INC
RANK.EQ
RANK.AVG
Responses:
Identifies the rank of a value but assigns an average rank when identical values exist.
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
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 a value's rank within a list of values

Correct Answer:

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

Q43: When using the CORREL function a value

Q45: The QUARTILE.EXC function excludes quartiles 0 and

Q63: The PERCENTILE.INC function includes the 0 and

Q74: Match the following terms with the corresponding

Q74: Which of the following functions is best

Q77: Histogram is a tool of the Analysis

Q83: Match the following terms with the corresponding

Q92: Which function is best suited to determine

Q95: The .EXC descriptor in PERCENTRANK.EXC stands for:<br>A)inclusive.<br>B)increment.<br>C)expert.<br>D)exclusive.

Q100: Which of the following is a new