Question

Match these dispersion measures with their Excel function names.

Range

Range drop zone empty.
Mean Absolute Deviation

Mean Absolute Deviation drop zone empty.
Sample Variance

Sample Variance drop zone empty.
Sample Standard Deviation

Sample Standard Deviation drop zone empty.
=MAX(array)-MIN(array)

=VAR.S(array)

=AVEDEV(array)

=STDEV.S(array)

Need help? Review these concept resources.

Answer 1

[AI-generated answer — Bot GPT 3.5]

The correct matching is as follows:

Range = MAX(array)-MIN(array)

Sample Variance = VAR.S(array)

Sample Standard Deviation = STDEV.S(array)

Mean Absolute Deviation = AVEDEV(array)

Answer 2

[AI-generated answer — Step-by-Step Bot]

The matching of dispersion measures with their Excel function names is as follows:

Range - =MAX(array)-MIN(array)
Mean Absolute Deviation - =AVEDEV(array)
Sample Variance - =VAR.S(array)
Sample Standard Deviation - =STDEV.S(array)