Box Plot Template

160

140

120

100

80

60

40

20

0
Sample 1 Sample 2 Sample 3 Sample 4 Sample 5 Sample 6
Min Outlier Max Outlier

Labels Sample 1 Sample 2 Sample 3 Sample 4 Sample 5 Sample 6

Min 22 12.079733103 30 40 10 22
Q1 39.5 17.683313006 82 55 75.25 35
Median 62.5 21.87021149 92 93 83.5 44
Q3 80 33.864251342 99 116 93.75 56
Max 108 78.604550771 145 138 140 130
IQR 40.5 16.180938336 17 61 18.5 21
Upper Outliers 0 1 2 0 2 1
Lower Outliers 0 0 1 0 2 0

Data Table Sample 1 Sample 2 Sample 3 Sample 4 Sample 5 Sample 6

52 18.2 102 116 98 31
63 17.0 99 98 97 35
107 48.0 102 95 94 45
54 30.5 100 67 98 29
79 20.9 106 48 96 44
80 29.3 91 109 83 67
108 42.4 82 72 75 55
80 30.7 84 125 76 41
78 14.5 75 55 72 57
106 17.2 93 119 84 34
80 34.9 98 92 89 22
61 42.2 97 46 90 38
42 22.8 99 55 92 37
104 20.8 96 116 95 59
39 20.3 92 137 91 56
104 24.1 108 70 99 44
59 28.7 102 131 100 38
73 14.1 64 93 63 66
62 41.9 84 138 74 57
80 38.8 77 40 76 52

http://www.vertex42.com/ExcelTemplates/box-whisker-plot.html © 2009 Vertex42 LLC

 Data Table Sample 1 Sample 2 Sample 3 Sample 4 Sample 5 Sample 6
26 12.3 90 98 82 51
91 78.6 97 49 93 23
25 17.5 93 92 53
63 12.1 85 40 78 29
51 18.9 75 73
28 19.7 70 68 130
41 91 82
30 95 89
94 94 86
22 78 72
27 82 74
33 85 79
66 85 78
36 82 81

20
30 10
140 140
145 130

Insert new rows above this line

http://www.vertex42.com/ExcelTemplates/box-whisker-plot.html © 2009 Vertex42 LLC

 Box Plot Template

150 Box and Whisker Plot

100

50

-50

-100

-150
1 2 3 4 5 6
Min Outlier Max Outlier Median

Labels Sample 1 Sample 2 Sample 3 Sample 4 Sample 5 Sample 6

Min -48 -7 -10 10 -115 33
Q1 -29.5 6 42 34.5 -49.5 46
Median -7.5 19.5 52 45 -41 54
Q3 11.5 24.75 59 62.5 -30.5 62
Max 29 30 105 86 25 100
IQR 41 18.75 17 28 19 16
Upper Outliers 0 0 2 0 3 1
Lower Outliers 0 0 1 0 2 0

Data Table
-41 28 62 42 -27
-7 27 59 27 -28
-12 24 62 49 -31 100
-48 28 60 58 -27
-26 26 66 29 -29
-30 13 51 45 -42 53
12 5 42 43 -50 45
-27 6 44 28 -49 46
-28 2 35 40 -53 42
-37 14 53 26 -41 54
9 19 58 42 -36 59
-48 20 57 64 -35 60
7 22 59 60 -33 62
-2 25 56 26 -30 65
-42 21 52 79 -34 61
-7 29 68 65 -26 69
12 30 62 86 -25 70
22 -7 24 47 -62 33
16 4 44 61 -51 44
4 6 37 43 -49 46
-5 12 50 79 -43 52

http://www.vertex42.com/ExcelTemplates/box-whisker-plot.html © 2009 Vertex42 LLC

 Data Table
15 23 57 78 -32 63
18 22 53 -33 62
-37 8 45 -47 48
-8 3 35 10 -52 43
-21 -2 30 -57 38
20 51 -43 52
15 55 -36 59
29 54 -39 56
-28 38 -53
-42 42 -51
10 45 -46
-26 45 -47
-41 42 -44

-105
-10 -115
100 15
105 5
25
Insert new rows above this line

http://www.vertex42.com/ExcelTemplates/box-whisker-plot.html © 2009 Vertex42 LLC

 Box Plot Template
Note: All values represent X + 140 where X is the original data

300

250

200

150

100

50

0
Sample 1 Sample 2 Sample 3 Sample 4 Sample 5 Sample 6
Min Outlier Max Outlier Zero Offset

Labels Sample 1 Sample 2 Sample 3 Sample 4 Sample 5 Sample 6

Min 92 133 170 150 0 203
Q1 110.5 146 222 174.5 65.25 216
Median 132.5 159.5 232 185 73.5 224
Q3 151.5 164.75 239 202.5 83.75 232
Max 169 170 285 226 130 270
IQR 41 18.75 17 28 18.5 16
Upper Outliers 0 0 2 0 2 1
Lower Outliers 0 0 1 0 2 0
Zero Offset 140 140 140 140 140 140

For the Box (IQR and Median)

Q2-Q1 22 13.5 10 10.5 8.25 8
Q3-Q2 19 5.25 7 17.5 10.25 8
For the Whiskers
Q3+1.5*IQR 213 192.875 264.5 244.5 111.5 256
Q1-1.5*IQR 49 117.875 196.5 132.5 37.5 192
Upper Whisker 169 170 264.5 226 111.5 256
Lower Whisker 92 133 196.5 150 37.5 203
Wupper-Q3 17.5 5.25 25.5 23.5 27.75 24
Q1-Wlower 18.5 13 25.5 24.5 27.75 13
For the Outliers
Max #N/A #N/A 285 #N/A 130 270
Min #N/A #N/A 170 #N/A 0 #N/A

http://www.vertex42.com/ExcelTemplates/box-whisker-plot.html © 2009 Vertex42 LLC

 99 168 242 182 88 SHIFT: 140
133 167 239 167 87
128 164 242 189 84 Using This Worksheet
92 168 240 198 88 This worksheet adds a value to the data in the Data
114 166 246 169 86 worksheet so that all the values are positive.The
110 153 231 185 73 223 chart in the BoxPlot_Shifted worksheet references
152 145 222 183 65 215 the data on this worksheet.
113 146 224 168 66 216
112 142 215 180 62 212
103 154 233 166 74 224
149 159 238 182 79 229
92 160 237 204 80 230
147 162 239 200 82 232
138 165 236 166 85 235
98 161 232 219 81 231
133 169 248 205 89 239
152 170 242 226 90 240
162 133 204 187 53 203
156 144 224 201 64 214
144 146 217 183 66 216
135 152 230 219 72 222
155 163 237 218 83 233
158 162 233 82 232
103 148 225 68 218
132 143 215 150 63 213
119 138 210 58 208
160 231 72 222
155 235 79 229
169 234 76 226
112 218 62
98 222 64
150 225 69
114 225 68
99 222 71

10
170 0
280 130 270
285 120
s a value to the data in the Data
l the values are positive.The
_Shifted worksheet references
-41 28 102 42 -52
-7 27 99 27 -53
-12 24 102 49 -56 Using This Worksheet
-48 28 100 58 -52 This worksheet is where you enter your data for the
-26 26 106 29 -54 chart in the BoxPlot_Shifted worksheet. The
-30 13 91 45 -67 83 Data_Shifted worksheet first offsets all the data based
12 5 82 43 -75 75 on the minimum value, so that all the values are
-27 6 84 28 -74 76 positive. A relative comparison is still possible.
-28 2 75 40 -78 72
-37 14 93 26 -66 84
9 19 98 42 -61 89
-48 20 97 64 -60 90
7 22 99 60 -58 92
-2 25 96 26 -55 95
-42 21 92 79 -59 91
-7 29 108 65 -51 99
12 30 102 86 -50 100
22 -7 64 47 -87 63
16 4 84 61 -76 74
4 6 77 43 -74 76
-5 12 90 79 -68 82
15 23 97 78 -57 93
18 22 93 -58 92
-37 8 85 -72 78
-8 3 75 10 -77 73
-21 -2 70 -82 68
20 91 -68 82
15 95 -61 89
29 94 -64 86
-28 78 -78
-42 82 -76
10 85 -71
-26 85 -72
-41 82 -69

-130
30 -140
140 -10 130
145 -20
here you enter your data for the
_Shifted worksheet. The
heet first offsets all the data based
ue, so that all the values are
omparison is still possible.
Box Plot Template
By Vertex42.com
http://www.vertex42.com/ExcelTemplates/box-whisker-plot.html

© 2009-2025 Vertex42 LLC

This spreadsheet, including all worksheets and associated content is a

copyrighted work under the United States and other copyright laws.

Do not submit copies or modifications of this template to any website or online

template gallery.

Please review the following license agreement to learn how you may or may not
use this template. Thank you.

See License Agreement

http://www.vertex42.com/licensing/EULA_privateuse.html

Do not delete this worksheet. If necessary, you may hide it by right-clicking on

the tab and selecting Hide.