Gender	Height
Female	65
Male	66
Female	63
Male	70
Female	66
Female	68
Female	61
Male	71
Male	72
Male	75
Female	61
Female	64
Male	69
Female	63
Female	64
Male	71
Female	64
Male	73
Female	59

1. Create a new sheet named "Height"
2. Copy column D of Sheet1 to column A of the new sheet
3. Copy column F of Sheet1 to column B of the new sheet

Use the five-number summary to locate the upper and lower fences:

1. Highlight columns A and B, then select Home > Format as Table > Medium > Blue, Table Style Medium 2
2. In cell J2, type "Min" in bold
3. In cell J3, type "Q1" in bold
4. In cell J4, type "Q2" in bold
5. In cell J5, type "Q3" in bold
6. In cell J6, type "Max" in bold

1. In cell K2, enter the formula =MIN(B:B)
2. In cell K3, enter the formula =QUARTILE.INC(B:B, 1)
3. In cell K4, enter the formula =QUARTILE.INC(B:B, 2)
4. In cell K5, enter the formula =QUARTILE.INC(B:B, 3)
5. In cell K3, enter the formula =MAX(B:B)

1. In cell J8, type "IQR" in bold
2. In cell J9, type "1.5*IQR" in bold
3. In cell K8, enter the formula =K5-K3
4. In cell K9, enter the formula =1.5*K8

1. In cell J11, type "Lower Fence" in bold
2. In cell J12, type "Upper Fence" in bold
3. In cell K11, enter the formula =K3-K9
4. In cell K12, enter the formula =K5+K9

What is the lower fence (in inches)?

What is the upper fence (in inches)?

Sort the data to identify any outliers:

1. In cell B1, click on the triangle next to "Height," then select Sort Smallest to Largest
2. Check the data for low outliers

What is the height (in inches) of the tallest low outlier that seems unreasonable?

Delete the unreasonably short students from the data set:

1. Highlight the cell range A2:B29
2. Right-click on the highlighted cells, then select Delete > Table Rows

Notice the that upper and lower fences changed.

How many low outliers remain after deleting the unreasonably short students?

How many high outliers remain after deleting the unreasonably short students?