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

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)