Solved

Match the Following Terms with the Corresponding Description

Question 96

Matching

Match the following terms with the corresponding description:

Premises:

Responses:

PERCENTRANK.INC

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

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

QUARTILE.INC

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

RANK.EQ

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

RANK.AVG

Identifies a value's rank within a list of values

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:

Premises:

Responses:

PERCENTRANK.INC

PERCENTRANK.EXC

QUARTILE.INC

RANK.EQ

RANK.AVG

Related Questions