2.3: Location of the Data

7

Location of the Data

jkesler

The common measures of location are quartiles and percentiles

Quartiles are special percentiles. The first quartile, Q₁, is the same as the 25^th percentile, and the third quartile, Q₃, is the same as the 75^th percentile. The median, M, is called both the second quartile and the 50^th percentile.

To calculate quartiles and percentiles, the data must be ordered from smallest to largest. Quartiles divide ordered data into quarters. Percentiles divide ordered data into hundredths. To score in the 90^th percentile of an exam does not mean, necessarily, that you received 90% on a test. It means that 90% of test scores are the same or less than your score and 10% of the test scores are the same or greater than your test score.

Percentiles are useful for comparing values. For this reason, universities and colleges use percentiles extensively. One instance in which colleges and universities use percentiles is when SAT results are used to determine a minimum testing score that will be used as an acceptance factor. For example, suppose Duke accepts SAT scores at or above the 75^th percentile. That translates into a score of at least 1220.

Percentiles are mostly used with very large populations. Therefore, if you were to say that 90% of the test scores are less (and not the same or less) than your score, it would be acceptable because removing one particular data value is not significant.

The median is a number that measures the “center” of the data. You can think of the median as the “middle value,” but it does not actually have to be one of the observed values. It is a number that separates ordered data into halves. Half the values are the same number or smaller than the median, and half the values are the same number or larger. For example, consider the following data.
1; 11.5; 6; 7.2; 4; 8; 9; 10; 6.8; 8.3; 2; 2; 10; 1
Ordered from smallest to largest:
1; 1; 2; 2; 4; 6; 6.8; 7.2; 8; 8.3; 9; 10; 10; 11.5

Since there are 14 observations, the median is between the seventh value, 6.8, and the eighth value, 7.2. To find the median, add the two values together and divide by two.

$$\frac{6.8+7.2}{2}=7$$

The median is seven. Half of the values are smaller than seven and half of the values are larger than seven.

Quartiles are numbers that separate the data into quarters. Quartiles may or may not be part of the data. To find the quartiles, first find the median or second quartile. The first quartile, Q₁, is the middle value of the lower half of the data, and the third quartile, Q₃, is the middle value, or median, of the upper half of the data. To get the idea, consider the same data set:
1; 1; 2; 2; 4; 6; 6.8; 7.2; 8; 8.3; 9; 10; 10; 11.5

The median or second quartile is seven. The lower half of the data are 1, 1, 2, 2, 4, 6, 6.8. The middle value of the lower half is two.
1; 1; 2; 2; 4; 6; 6.8

The number two, which is part of the data, is the first quartile. One-fourth of the entire sets of values are the same as or less than two and three-fourths of the values are more than two.

The upper half of the data is 7.2, 8, 8.3, 9, 10, 10, 11.5. The middle value of the upper half is nine.

The third quartile, Q3, is nine. Three-fourths (75%) of the ordered data set are less than nine. One-fourth (25%) of the ordered data set are greater than nine. The third quartile is part of the data set in this example.

The interquartile range is a number that indicates the spread of the middle half or the middle 50% of the data. It is the difference between the third quartile (Q₃) and the first quartile (Q₁).

IQR = Q₃ – Q₁

The IQR can help to determine potential outliers. A value is suspected to be a potential outlier if it is less than (1.5)(IQR) below the first quartile or more than (1.5)(IQR) above the third quartile. Potential outliers always require further investigation. In the previous example, $Q_1=2$ and $Q_3=9$ so the $IQR=9-2=7$. So a value would be a potential outlier if it was (1.5)(7) = 10.5 below 2 (which would be -8.5) or 10.5 above 9 (which would be 19.5). If we saw the value 20 in our data, that is probably an outlier.

NOTE

A potential outlier is a data point that is significantly different from the other data points. These special data points may be errors or some kind of abnormality or they may be a key to understanding the data.

EXAMPLE 2.13

For the following 13 real estate prices, calculate the IQR and determine if any prices are potential outliers. Prices are in dollars.
389,950; 230,500; 158,000; 479,000; 639,000; 114,950; 5,500,000; 387,000; 659,000; 529,000; 575,000; 488,800; 1,095,000

Solution 2.13

Order the data from smallest to largest.
114,950; 158,000; 230,500; 387,000; 389,950; 479,000; 488,800; 529,000; 575,000; 639,000; 659,000; 1,095,000; 5,500,000

M = 488,800

$Q_1=\frac{230,500+387,000}{2}=308,750$

$Q_3 = \frac{639,000+659,000}{2}=649,000$

$IQR = 649,000-308,750 = 340,250$

$(1.5)(IQR)=(1.5)(340,250) = 510,375$

$Q_1-(1.5)(IQR) = 308,750 – 510,375 = –201,625$

$Q3 + (1.5)(IQR) = 649,000 + 510,375 = 1,159,375$

No house price is less than –201,625. However, 5,500,000 is more than 1,159,375. Therefore, 5,500,000 is a potential outlier.

TRY IT 2.13

For the following 11 salaries, calculate the IQR and determine if any salaries are outliers. The salaries are in dollars.

\$33,000; \$64,500; \$28,000; \$54,000; \$72,000; \$68,500; \$69,000; \$42,000; \$54,000; \$120,000; \$40,500

EXAMPLE 2.14

For the two data sets in the test scores example, find the following:

1. The interquartile range. Compare the two interquartile ranges.
2. Any outliers in either set.

Solution 2.14

The five number summary for the day and night classes is

	Minimum	Q1	Median	Q3	Maximum
Day	32	56	74.5	82.5	99
Night	25.5	78	81	89	98

Table2.21

Solution 2.14

1. The IQR for the day group is Q₃ – Q₁ = 82.5 – 56 = 26.5

   The IQR for the night group is Q₃ – Q₁ = 89 – 78 = 11

   The interquartile range (the spread or variability) for the day class is larger than the night class IQR. This suggests more variation will be found in the day class’s class test scores.

2. Day class outliers are found using the IQR times 1.5 rule. So,
   • Q₁ – IQR(1.5) = 56 – 26.5(1.5) = 16.25
   • Q₃ + IQR(1.5) = 82.5 + 26.5(1.5) = 122.25

   Since the minimum and maximum values for the day class are greater than 16.25 and less than 122.25, there are no outliers.

   Night class outliers are calculated as:

   • Q₁ – IQR (1.5) = 78 – 11(1.5) = 61.5
   • Q₃ + IQR(1.5) = 89 + 11(1.5) = 105.5

   For this class, any test score less than 61.5 is an outlier. Therefore, the scores of 45 and 25.5 are outliers. Since no test score is greater than 105.5, there is no upper end outlier.

TRY IT 2.14

Find the interquartile range for the following two data sets and compare them.

Test Scores for Class A
69; 96; 81; 79; 65; 76; 83; 99; 89; 67; 90; 77; 85; 98; 66; 91; 77; 69; 80; 94
Test Scores for Class B
90; 72; 80; 92; 90; 97; 92; 75; 79; 68; 70; 80; 99; 95; 78; 73; 71; 68; 95; 100

EXAMPLE 2.15

Fifty statistics students were asked how much sleep they get per school night (rounded to the nearest hour). The results were:

AMOUNT OF SLEEP PER SCHOOL NIGHT (HOURS)	FREQUENCY	RELATIVE FREQUENCY	CUMULATIVE RELATIVE FREQUENCY
4	2	0.04	0.04
5	5	0.10	0.14
6	7	0.14	0.28
7	12	0.24	0.52
8	14	0.28	0.80
9	7	0.14	0.94
10	3	0.06	1.00

Table2.22

Find the 28^th percentile. Notice the 0.28 in the “cumulative relative frequency” column. Twenty-eight percent of 50 data values is 14 values. There are 14 values less than the 28^th percentile. They include the two 4s, the five 5s, and the seven 6s. The 28^th percentile is between the last six and the first seven. The 28^th percentile is 6.5.

Find the median. Look again at the “cumulative relative frequency” column and find 0.52. The median is the 50^th percentile or the second quartile. 50% of 50 is 25. There are 25 values less than the median. They include the two 4s, the five 5s, the seven 6s, and eleven of the 7s. The median or 50^th percentile is between the 25^th, or seven, and 26^th, or seven, values. The median is seven.

Find the third quartile. The third quartile is the same as the 75^th percentile. You can “eyeball” this answer. If you look at the “cumulative relative frequency” column, you find 0.52 and 0.80. When you have all the fours, fives, sixes and sevens, you have 52% of the data. When you include all the 8s, you have 80% of the data. The 75^th percentile, then, must be an eight. Another way to look at the problem is to find 75% of 50, which is 37.5, and round up to 38. The third quartile, Q₃, is the 38^th value, which is an eight. You can check this answer by counting the values. (There are 37 values below the third quartile and 12 values above.)

TRY IT 2.15

Forty bus drivers were asked how many hours they spend each day running their routes (rounded to the nearest hour). Find the 65^th percentile.

Amount of time spent on route (hours)	Frequency	Relative Frequency	Cumulative Relative Frequency
2	12	0.30	0.30
3	14	0.35	0.65
4	10	0.25	0.90
5	4	0.10	1.00

Table2.23

EXAMPLE 2.16

Using Table 2.22:

1. Find the 80^th percentile.
2. Find the 90^th percentile.
3. Find the first quartile. What is another name for the first quartile?

Solution 2.16

Using the data from the frequency table, we have:

1. The 80^th percentile is between the last eight and the first nine in the table (between the 40^th and 41^st values). Therefore, we need to take the mean of the 40^th an 41^st values. The 80^th percentile $=\frac{8+9}{2}=8.5$
2. The 90^th percentile will be the 45^th data value (location is 0.90(50) = 45) and the 45^th data value is nine.
3. Q₁ is also the 25^th percentile. The 25^th percentile location calculation: P₂₅ = 0.25(50) = 12.5 ≈ 13 the 13^th data value. Thus, the 25th percentile is six.

TRY IT 2.16

Refer to the Table 2.23. Find the third quartile. What is another name for the third quartile?

Home

A Formula for Finding the kth Percentile

If you were to do a little research, you would find several formulas for calculating the k^th percentile. Here is one of them.

k = the k^th percentile. It may or may not be part of the data.

L = the location or index (ranking or position of a data value)

n = the total number of data

• Order the data from smallest to largest.
• Calculate $$L = \frac{k}{100}\cdot n$$
• If L is an integer, then the k^th percentile is the mean of the data values in the L^th position and the L+1^th position in the ordered set of data.
• If L is not an integer, then round Lup (always up) and this will be the location of the percentile you’re looking for.

EXAMPLE 2.17

Listed are 29 ages for Academy Award winning best actors in order from smallest to largest.
18; 21; 22; 25; 26; 27; 29; 30; 31; 33; 36; 37; 41; 42; 47; 52; 55; 57; 58; 62; 64; 67; 69; 71; 72; 73; 74; 76; 77

Find the 70^th percentile.

Solution 2.17

1. • k = 70
   • L = the location
   • n = 29

   $L = \frac{k}{100}\cdot n = \frac{70}{100}\cdot 29 = 20.3$. The location is not an integer, therefor round up to 21 so the data value in the 21^st position in the ordered data set is the 70^th percentile, which is 64. The 70^th percentile is 64 years.

TRY IT 2.17

Listed are 29 ages for Academy Award winning best actors in order from smallest to largest.

18; 21; 22; 25; 26; 27; 29; 30; 31; 33; 36; 37; 41; 42; 47; 52; 55; 57; 58; 62; 64; 67; 69; 71; 72; 73; 74; 76; 77
Calculate the 20^th percentile and the 55^th percentile.

NOTE

You can calculate percentiles using calculators and computers. There are a variety of online calculators.

A Formula for Finding the Percentile of a Value in a Data Set

• Order the data from smallest to largest.
• p = the percentile of the data value you are looking for.
• x = the number of data values below the data value for which you want to find the percentile.
• n = the total number of data.
• Calculate $$p = \frac{x}{n}\cdot 100$$
  Then round to the nearest integer.

EXAMPLE 2.18

Listed are 29 ages for Academy Award winning best actors in order from smallest to largest.
18; 21; 22; 25; 26; 27; 29; 30; 31; 33; 36; 37; 41; 42; 47; 52; 55; 57; 58; 62; 64; 67; 69; 71; 72; 73; 74; 76; 77

Find the percentile for 58.

Solution 2.18

$p = \frac{x}{n}\cdot 100 = \frac{18}{29}\cdot 100 \approx 62.07 $
We round this number up and find that 58 is the 63^rd percentile

TRY IT 2.18

Listed are 30 ages for Academy Award winning best actors in order from smallest to largest.

18; 21; 22; 25; 26; 27; 29; 30; 31, 31; 33; 36; 37; 41; 42; 47; 52; 55; 57; 58; 62; 64; 67; 69; 71; 72; 73; 74; 76; 77
Find the percentiles for 47 and 31.

Interpreting Percentiles, Quartiles, and Median

A percentile indicates the relative standing of a data value when data are sorted into numerical order from smallest to largest. Percentages of data values are less than or equal to the p^th percentile. For example, 15% of data values are less than or equal to the 15^th percentile.

• Low percentiles always correspond to lower data values.
• High percentiles always correspond to higher data values.

A percentile may or may not correspond to a value judgment about whether it is “good” or “bad.” The interpretation of whether a certain percentile is “good” or “bad” depends on the context of the situation to which the data applies. In some situations, a low percentile would be considered “good;” in other contexts a high percentile might be considered “good”. In many situations, there is no value judgment that applies.

Understanding how to interpret percentiles properly is important not only when describing data, but also when calculating probabilities in later chapters of this text.

NOTE

When writing the interpretation of a percentile in the context of the given data, the sentence should contain the following information.

• information about the context of the situation being considered
• the data value (value of the variable) that represents the percentile
• the percent of individuals or items with data values below the percentile
• the percent of individuals or items with data values above the percentile.

EXAMPLE 2.19

On a timed math test, the first quartile for time it took to finish the exam was 35 minutes. Interpret the first quartile in the context of this situation.

 

Solution 2.19

• Twenty-five percent of students finished the exam in 35 minutes or less.
• Seventy-five percent of students finished the exam in 35 minutes or more.
• A low percentile could be considered good, as finishing more quickly on a timed exam is desirable. (If you take too long, you might not be able to finish.)

TRY IT 2.19

For the 100-meter dash, the third quartile for times for finishing the race was 11.5 seconds. Interpret the third quartile in the context of the situation.

EXAMPLE 2.20

On a 20 question math test, the 70^th percentile for number of correct answers was 16. Interpret the 70^th percentile in the context of this situation.

TRY IT 2.20

On a 60 point written assignment, the 80^th percentile for the number of points earned was 49. Interpret the 80^th percentile in the context of this situation.

EXAMPLE 2.21

At a community college, it was found that the 30^th percentile of credit units that students are enrolled for is seven units. Interpret the 30^th percentile in the context of this situation.

TRY IT 2.21

During a season, the 40^th percentile for points scored per player in a game is eight. Interpret the 40^th percentile in the context of this situation.

EXAMPLE 2.22

Sharpe Middle School is applying for a grant that will be used to add fitness equipment to the gym. The principal surveyed 15 anonymous students to determine how many minutes a day the students spend exercising. The results from the 15 anonymous students are shown.

0 minutes; 40 minutes; 60 minutes; 30 minutes; 60 minutes

10 minutes; 45 minutes; 30 minutes; 300 minutes; 90 minutes;

30 minutes; 120 minutes; 60 minutes; 0 minutes; 20 minutes

Determine the following five values.

• Min = 0
• Q₁ = 20
• Med = 40
• Q₃ = 60
• Max = 300

If you were the principal, would you be justified in purchasing new fitness equipment? Since 75% of the students exercise for 60 minutes or less daily, and since the IQR is 40 minutes (60 – 20 = 40), we know that half of the students surveyed exercise between 20 minutes and 60 minutes daily. This seems a reasonable amount of time spent exercising, so the principal would be justified in purchasing the new equipment.

However, the principal needs to be careful. The value 300 appears to be a potential outlier.

Q₃ + 1.5(IQR) = 60 + (1.5)(40) = 120.

The value 300 is greater than 120 so it is a potential outlier. If we delete it and calculate the five values, we get the following values:

• Min = 0
• Q₁ = 20
• Q₃ = 60
• Max = 120

We still have 75% of the students exercising for 60 minutes or less daily and half of the students exercising between 20 and 60 minutes a day. However, 15 students is a small sample and the principal should survey more students to be sure of his survey results.