Solved

Match the Following Terms with the Corresponding Description

Question 46

Matching

Match the following terms with the corresponding description:

Premises:

Responses:

RANK.EQ

Identifies the rank of a value but assigns an average rank when identical values exist.

QUARTILE.INC

Displays a value's rank as a percentile of the range of data in the dataset

RANK.AVG

Returns a value's rank as a percent excluding 0 and 1

PERCENTRANK.EXC

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

PERCENTRANK.INC

Identifies a value's rank within a list of values

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:

Premises:

Responses:

RANK.EQ

QUARTILE.INC

RANK.AVG

PERCENTRANK.EXC

PERCENTRANK.INC

Related Questions

Q40: Match the following terms with the corresponding

Q41: Match the following terms with the corresponding