Box Plot Template
160
140
120
100
80
60
40
20
0
Sample 1
Sample 2
Sample 3
Q3-Q2
Labels
Min
Q1
Median
Q3
Max
IQR
Upper Outliers
Lower Outliers
Data Table
Sample 4
Q2-Q1
Sample 5
Sample 6
Q1
Sample 1
Sample 2
22 12.079733103
Sample 3
30
Sample 4
40
Sample 5
10
Sample 6
22
39.5 17.683313006
62.5 21.87021149
82
92
55
93
75.25
83.5
35
44
80 33.864251342
108 78.604550771
40.5 16.180938336
0
1
0
0
99
145
17
2
1
116
138
61
0
0
93.75
140
18.5
2
2
56
130
21
1
0
Sample 3
102
99
102
100
106
91
82
84
75
93
98
97
99
96
92
108
Sample 4
116
98
95
67
48
109
72
125
55
119
92
46
55
116
137
70
Sample 5
98
97
94
98
96
83
75
76
72
84
89
90
92
95
91
99
Sample 6
31
35
45
29
44
67
55
41
57
34
22
38
37
59
56
44
Sample 1
52
63
107
54
79
80
108
80
78
106
80
61
42
104
39
104
Sample 2
18.2
17.0
48.0
30.5
20.9
29.3
42.4
30.7
14.5
17.2
34.9
42.2
22.8
20.8
20.3
24.1
[Link]
2009 Vertex42 LLC
Data Table
Sample 1
59
73
62
80
26
91
25
63
51
28
41
30
94
22
27
33
66
36
Sample 2
28.7
14.1
41.9
38.8
12.3
78.6
17.5
12.1
18.9
19.7
Sample 3
102
64
84
77
90
97
93
85
75
70
91
95
94
78
82
85
85
82
30
140
145
Sample 4
131
93
138
40
98
49
40
Sample 5
100
63
74
76
82
93
92
78
73
68
82
89
86
72
74
79
78
81
Sample 6
38
66
57
52
51
23
53
29
130
20
10
140
130
Insert new rows above this line
[Link]
2009 Vertex42 LLC
Box Plot Template
150
Box and Whisker Plot
100
50
-50
-100
-150
1
3
Bar
Labels
Min
Q1
Median
Q3
Max
IQR
Upper Outliers
Lower Outliers
Min Outlier
Max Outlier
Sample 1
-48
Sample 2
-7
Sample 3
-10
Sample 4
10
Sample 5
-115
Sample 6
33
-29.5
-7.5
6
19.5
42
52
34.5
45
-49.5
-41
46
54
11.5
29
41
0
0
24.75
30
18.75
0
0
59
105
17
2
1
62.5
86
28
0
0
-30.5
25
19
3
2
62
100
16
1
0
-41
-7
-12
-48
-26
-30
12
-27
-28
-37
9
-48
7
-2
-42
-7
28
27
24
28
26
13
5
6
2
14
19
20
22
25
21
29
62
59
62
60
66
51
42
44
35
53
58
57
59
56
52
68
42
27
49
58
29
45
43
28
40
26
42
64
60
26
79
65
-27
-28
-31
-27
-29
-42
-50
-49
-53
-41
-36
-35
-33
-30
-34
-26
Data Table
[Link]
100
53
45
46
42
54
59
60
62
65
61
69
2009 Vertex42 LLC
Data Table
12
22
16
4
-5
15
18
-37
-8
-21
20
15
29
-28
-42
10
-26
-41
30
-7
4
6
12
23
22
8
3
-2
62
24
44
37
50
57
53
45
35
30
51
55
54
38
42
45
45
42
-10
100
105
86
47
61
43
79
78
10
-25
-62
-51
-49
-43
-32
-33
-47
-52
-57
-43
-36
-39
-53
-51
-46
-47
-44
70
33
44
46
52
63
62
48
43
38
52
59
56
-105
-115
15
5
25
Insert new rows above this line
[Link]
2009 Vertex42 LLC
Box Plot Template
Note: All values represent X + 140 where X is the original data
160
140
120
100
80
60
40
20
0
Sample 1
Sample 2
Sample 3
Q3-Q2
Labels
Min
Q1
Median
Q3
Max
IQR
Upper Outliers
Lower Outliers
Zero Offset
Q1-1.5*IQR
Q2-Q1
Sample 5
Sample 6
Q1
Sample 1
#REF!
Sample 2
#REF!
Sample 3
#REF!
Sample 4
#REF!
Sample 5
#REF!
Sample 6
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
140
#REF!
#REF!
#REF!
#REF!
#REF!
140
#REF!
#REF!
#REF!
#REF!
#REF!
140
#REF!
#REF!
#REF!
#REF!
#REF!
140
#REF!
#REF!
#REF!
#REF!
#REF!
140
#REF!
#REF!
#REF!
#REF!
#REF!
140
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
For the Box (IQR and Median)
Q2-Q1
#REF!
Q3-Q2
#REF!
For the Whiskers
Q3+1.5*IQR
#REF!
Upper Whisker
Lower Whisker
W upper-Q3
Sample 4
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
Q1-W lower
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
For the Outliers
Max
Min
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
[Link]
2009 Vertex42 LLC
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
SHIFT:
140
Using This Worksheet
This worksheet adds a value to the data in the Dat
worksheet so that all the values are [Link]
chart in the BoxPlot_Shifted worksheet references
the data on this worksheet.
s a value to the data in the Data
l the values are [Link]
_Shifted worksheet references
-41
-7
-12
-48
-26
-30
12
-27
-28
-37
9
-48
7
-2
-42
-7
12
22
16
4
-5
15
18
-37
-8
-21
20
15
29
-28
-42
10
-26
-41
28
27
24
28
26
13
5
6
2
14
19
20
22
25
21
29
30
-7
4
6
12
23
22
8
3
-2
102
99
102
100
106
91
82
84
75
93
98
97
99
96
92
108
102
64
84
77
90
97
93
85
75
70
91
95
94
78
82
85
85
82
30
140
145
42
27
49
58
29
45
43
28
40
26
42
64
60
26
79
65
86
47
61
43
79
78
10
-52
-53
-56
-52
-54
-67
-75
-74
-78
-66
-61
-60
-58
-55
-59
-51
-50
-87
-76
-74
-68
-57
-58
-72
-77
-82
-68
-61
-64
-78
-76
-71
-72
-69
-130
-140
-10
-20
83
75
76
72
84
89
90
92
95
91
99
100
63
74
76
82
93
92
78
73
68
82
89
86
130
Using This Worksheet
This worksheet is where you enter your data for th
chart in the BoxPlot_Shifted worksheet. The
Data_Shifted worksheet first offsets all the data ba
on the minimum value, so that all the values are
positive. A relative comparison is still possible.
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 [Link]
[Link]
2009-2016 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
[Link]
Do not delete this worksheet. If necessary, you may hide it by right-clicking on
the tab and selecting Hide.