Frequency Distribution, Bar Graph, and Boxplot

For instructions on using this spreadsheet, please click on the ABOUT tab, below.
Data Outlier? Statistics Values Formulas Graph Calculations
4.56 mean, x-bar 14.70533333333 =AVERAGE(range) 4.56
5.83 smallest entry 4.56 =MIN(range) 8.9675 Boxplot
Modified
6.49 largest entry 34.04 =MAX(range) 8.9675
6.54 number of observations 30 =COUNT(range) 17.3375
7.58 17.3375
7.98 median 12.61 =MEDIAN(range) 29.8925
8.9 1st quartile 8.9675 =QUARTILE(range, 1) 17.3375
8.92 3rd quartile 17.3375 =QUARTILE(range, 3) 17.3375
9.11 IQR 8.37 = 3rd quartile - 1st quartile 12.61
9.26 lower whisker 4.56 = 1st quartile - 1.5 * IQR or smallest val 12.61
9.98 upper whisker 29.8925 = 3rd quartile + 1.5 * IQR or largest val 0 5 10 15 12.6120 25 30
10.7 8.9675
Horizontal Axis Label Goes Here
10.92 8.9675
11.01 Columns G, H, and I
12.31 Frequency Table for Histogram and J Title
are Goes
usedHere
for the
12.91 suggested # of cats 5 9 boxplot work--don't use
8
14.41 category size 5
7
14.97 At least… …but less than… frequency category name
6
15.37 4 9 8 4 to 9-

Frequency
5
16.54 9 14 8 9 to 14-
4
16.69 14 19 8 14 to 19-
3
17 19 24 1 19 to 24-
2
17.45 24 29 3 24 to 29-
1
18 29 34 1 29 to 34-
0
23.66 34 39 1 34 to 39- 4 to 9- 9 to 14- 14 to 19- 19 to 24- 24 to 29- 29
26.32
26.33
26.81 Unmodified Boxplot
30.57 outlier
34.04 outlier
outlier
outlier
outlier

0 5 10 15 20 25 30
Horizontal Axis Label Goes Here
outlier
outlier
outlier 0 5 10 15 20 25 30
outlier Horizontal Axis Label Goes Here
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
outlier
 ph Calculations
2 4.56
Modified Boxplot2 8.9675
1 8.9675
1 17.3375
2 17.3375
2 34.04
2 17.3375
3 17.3375
3 12.61
1 12.61
15 20 25 3 30 35 12.61
40
3
orizontal Axis Label Goes Here 8.9675
2 8.9675
Columns G, H, and I
and J Title
are Goes
usedHere
for the
boxplot work--don't use

4- 14 to 19- 19 to 24- 24 to 29- 29 to 34- 34 to 39-

Unmodified Boxplot
2
2
2
2
2

15 20 25 30 35 40
rizontal Axis Label Goes Here
 2
2
15 20 25 30 235 40
rizontal Axis Label Goes Here 2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
Excel Templates by Scott P. Stevens, copyright 2005.
Instructions for Use:
Enter your data set in the yellow column labelled "Data" The template willl support data
sets of up to 3000 elements. In the yellow cell marked "Category size", enter the class
width that you want. In the yellow cell in the "Values from" column, enter the lower limit
for your first class. This template will allow you to use up to 7 classes, but this can be
easily adjusted. (Just delete unwanted categories from the bottom of the list, or create
additional categories by highlighting cells C28 to E28, then dragging them down to copy
their formulas to additional rows. If you change the number of classes, though, you'll
need to right click on the histogram and modify the SOURCE DATA.) (Try it--it's easy.)

NOTE: READ THE YELLOW BOX BELOW BEFORE YOU TRY THIS!
Unlike the boxplot discussed in your book, the whiskers on the modified boxplot do not
extend to the largest and smallest elements of the set. Instead, this approach is taken:
Find the interquartile range (IQR), multiply it by 1.5, then subtract that amount from the
first quartile (Q1) and add the value to the third quartile (Q3). The whiskers end at the
most extreme data point which falls within these bounds. All points beyond these limits
are called "outliers", and are indicated with dots. Many people use this kind of boxplot.
To get the kind of boxplot in your book, your whiskers would extend out to the include
the outliers. Other than that, the box and whisker plot of your text and the one used
here are identical.
Note:
This spreadsheet is protected, for your convenience. This prevents you from accidentally
changing cells which are needed by the spreadsheet for calculations. Unfortunately, this
also prevents you from adding or deleting categories. If you need to add or delete
categories as described in the green box above, choose Protection on the Tools menu,
and choose Unprotect Sheet. After you've added or removed the appropriate category
rows, select Protection from the Tool menu, and this time select Protect Sheet. Clear the
check marks on Objects and Scenarios, leaving only the check mark for Contents.