Match the Following Five Terms to Their Meanings

question 8

Multiple Choice

Match the following five terms to their meanings:
i.nested function
II.AND function
III.NOT function
IV.AVERAGEIFS function
v.OR function

• A)This function returns a value of TRUE if ALL of the conditions are met.
• B)A logical function that takes only one argument and is used to test one condition.
• C)This function returns a value of TRUE if ANY of the conditions are met.
• D)A function that is contained inside another function.
• E)This function enables you to specify multiple criteria when computing an average.

---

Definitions:

Dispersion

A measure of the spread of a distribution or the variability of data points around a central value.

Standard Deviation

A statistic that measures the dispersion of a dataset relative to its mean, indicating how spread out the data points are.

Percentile

A measure used in statistics to indicate the value below which a given percentage of observations in a group of observations falls.

Measures of Dispersion

Statistical indicators that describe the spread or variability of a data set.