Lab 7 Measures of Location

Measures of location are numbers that indicate the position of data values in a data set. In this lab, you will use Excel to determine measures of location in a distribution: percentiles and standard scores (z-scores).

A percentile represents the location of a value as a cumulative percentage. The k-th (where 1 ≤ k ≤ 99) percentile is the data value that indicates the k% percentage of all values in the data set that falls at or below it, and (100-k)% of all data falls above it.

Another common measure of location is the standard value score, which relates to the distribution’s spread. A standard score (or z-score) indicates the position of a value in terms of its distance to the mean in units of standard deviation.