Solved

Match the Following Terms with the Corresponding Description

Question 57

Matching

Match the following terms with the corresponding description:

Premises:

Responses:

QUARTILE.INC

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

RANK.AVG

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

RANK.EQ

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

PERCENTRANK.INC

Identifies a value's rank within a list of values

Premises:

QUARTILE.INC

PERCENTRANK.EXC

RANK.AVG

RANK.EQ

PERCENTRANK.INC

Responses:

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 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

Identifies a value's rank within a list of values

Correct Answer:

Premises:

Responses:

QUARTILE.INC

PERCENTRANK.EXC

RANK.AVG

RANK.EQ

PERCENTRANK.INC