Matching
Match each of the following concepts to its most likely application:
Premises:
PERCENTRANK.INC
PERCENTRANK.EXC
RANK.AVG
RANK.EQ
QUARTILE.EXC
Responses:
A value's rank as a percent of the range of data in the dataset with highest and lowest values
A value's rank as a percent excluding 0 and 1
A value's rank within a list of values, returning the same value for ties
The value at a specific quartile for a dataset
A value's rank within a list of values, returning the mean value for ties
Correct Answer:
Premises:
Responses:
PERCENTRANK.INC
PERCENTRANK.EXC
RANK.AVG
RANK.EQ
QUARTILE.EXC
Premises:
PERCENTRANK.INC
PERCENTRANK.EXC
RANK.AVG
RANK.EQ
QUARTILE.EXC
Responses:
Related Questions
Q21: Inferential statistics and Descriptive statistics are the
Q22: A quartile is a value used to
Q23: Which of the following outputs from an
Q24: The _ function returns the variance of
Q25: What is F in an ANOVA summary
Q27: The FORECAST.ETS function returns a confidence interval
Q28: The Analysis ToolPak is available on the
Q29: Which of the following is an Excel
Q30: A college admissions office might use which
Q31: The FREQUENCY function determines the strength of