Box Plot Template © 2009 Vertex42 LLC HELP Labels Sample 1 Sample 2 Sample 3 Sample 4 Sample 5 Sample 6 Min 63 53 30 40 10 63 Q1 76 66 82 74.5 75.25 76 Median 83.5 79.5 92 80 83.5 84 Q3 92.75 84.75 99 85.5 93.75 92 Max 100 90 145 91 140 130 IQR 16.75 18.75 17 11 18.5 16 Upper Outliers 0 0 2 0 2 1 Lower Outliers 0 0 1 1 2 0 For the Box (IQR and Median) Q2-Q1 7.5 13.5 10 5.5 8.25 8 Q3-Q2 9.25 5.25 7 5.5 10.25 8 For the Whiskers Q3+1.5*IQR 117.875 112.875 124.5 102 121.5 116 Q1-1.5*IQR 50.875 37.875 56.5 58 47.5 52 Upper Whisker 100 90 124.5 91 121.5 116 Lower Whisker 63 53 56.5 58 47.5 63 Wupper-Q3 7.25 5.25 25.5 5.5 27.75 24 Q1-Wlower 13 13 25.5 16.5 27.75 13 For the Outliers Max #N/A #N/A 145 #N/A 140 130 Min #N/A #N/A 30 40 10 #N/A Data Table 98 88 102 70 98 83 97 87 99 71 97 75 94 84 102 72 94 76 98 88 100 73 98 72 96 86 106 74 96 84 83 73 91 75 83 89 75 65 82 76 75 90 76 66 84 77 76 92 72 62 75 78 72 95 84 74 93 79 84 91 89 79 98 80 89 99 90 80 97 81 90 100 92 82 99 82 92 63 95 85 96 83 95 74 91 81 92 84 91 76 99 89 108 85 99 82 100 90 102 86 100 93 63 53 64 87 63 92 74 64 84 88 74 78 76 66 77 89 76 73 82 72 90 90 82 68 93 83 97 91 93 82 92 82 93 92 89 78 68 85 78 86 73 63 75 73 68 58 70 68 82 91 82 89 95 89 86 94 86 72 78 72 74 82 74 79 85 79 78 85 78 81 82 81 20 30 40 10 140 140 130 145 130 Insert new rows above this line ##### Sheet/List 2 ##### Box Plot Template © 2009 Vertex42 LLC HELP Labels Sample 1 Sample 2 Sample 3 Sample 4 Sample 5 Sample 6 Sample 7 Sample 8 Sample 9 Sample 10 Sample 11 Sample 12 Min -93 -110 -55 48 105 132 150 150 100 55 105 132 Q1 -29.25 -10 25 79 133 168 185 179.75 140 86.75 133 168 Median -8 9 42 92 146 178 196 190 150 97 146 178 Q3 14.25 26.25 56 106 157 187 206 197 160 107 157 187 Max 58 65 91 162 196 225 240 253 194 138 196 225 IQR 43.5 36.25 31 27 24 19 21 17.25 20 20.25 24 19 Upper Outliers 0 0 0 1 1 1 1 4 2 1 1 1 Lower Outliers 0 5 2 0 0 1 1 1 2 2 0 1 For the Box (IQR and Median) Q2-Q1 21.25 19 17 13 13 10 11 10.25 10 10.25 13 10 Q3-Q2 22.25 17.25 14 14 11 9 10 7 10 10 11 9 For the Whiskers Q3+1.5*IQR 79.5 80.625 102.5 146.5 193 215.5 237.5 222.875 190 137.375 193 215.5 Q1-1.5*IQR -94.5 -64.375 -21.5 38.5 97 139.5 153.5 153.875 110 56.375 97 139.5 Upper Whisker 58 65 91 146.5 193 215.5 237.5 222.875 190 137.375 193 215.5 Lower Whisker -93 -64.375 -21.5 48 105 139.5 153.5 153.875 110 56.375 105 139.5 Wupper-Q3 43.75 38.75 35 40.5 36 28.5 31.5 25.875 30 30.375 36 28.5 Q1-Wlower 63.75 54.375 46.5 31 28 28.5 31.5 25.875 30 30.375 28 28.5 For the Outliers Max #N/A #N/A #N/A 162 196 225 240 253 194 138 196 225 Min #N/A -110 -55 #N/A #N/A 132 150 150 100 55 #N/A 132 ##### Sheet/List 3 ##### 30 -20 15 65 170 160 150 187 152 93 -10 12 40 44 65 102 135 185 196 194 157 107 70 16 37 8 27 92 165 164 180 182 157 99 50 40 25 22 52 124 145 153 202 198 151 108 41 4 -2 50 64 74 140 200 207 215 171 111 43 9 -81 37 55 85 119 178 198 190 144 89 38 1 -14 1 43 69 142 162 177 192 139 100 55 3 5 0 51 115 151 162 220 194 127 78 65 51 -31 36 56 116 162 165 189 194 164 112 50 38 -34 -24 75 78 142 167 193 192 136 108 42 -8 -16 17 52 105 148 200 210 220 176 80 48 -3 11 -31 37 80 144 185 216 194 156 78 4 0 16 42 28 98 156 190 205 200 168 108 41 -42 -87 -30 21 68 162 185 193 190 176 76 59 -10 -33 -21 -55 54 140 173 188 186 177 89 42 5 -26 -4 20 101 125 181 163 160 127 57 -9 -4 -31 5 46 75 130 209 206 209 153 126 60 39 23 10 44 107 161 202 232 188 163 103 35 -96 -59 35 1 110 187 184 209 191 158 106 59 38 18 41 52 77 168 194 184 191 142 88 37 30 36 34 68 123 149 186 211 217 153 106 29 22 -8 2 59 113 149 194 216 193 147 93 49 24 -20 39 45 82 143 171 217 204 151 128 65 43 25 56 78 139 162 197 229 186 144 106 54 4 -76 11 49 125 146 196 175 194 159 138 39 46 58 26 8 79 153 180 198 195 170 108 44 -6 14 29 37 116 178 181 204 213 176 99 49 26 15 34 41 98 167 207 212 220 194 107 31 -47 -93 -35 26 76 142 167 188 197 153 94 46 -38 -9 -5 -15 162 186 164 190 207 162 99 57 17 13 -1 69 100 181 172 201 188 177 127 64 21 -30 0 41 106 135 185 197 218 158 133 60 24 -46 -16 32 126 136 178 206 198 134 94 52 11 33 -1 20 91 162 181 206 194 172 113 14 -29 -50 -9 25 72 129 172 194 180 167 65 10 15 34 32 51 72 177 175 196 192 174 100 64 57 6 29 19 81 170 184 219 253 153 110 60 16 2 -4 -11 79 174 186 218 218 171 88 32 -50 -27 35 31 61 168 190 205 209 164 87 42 26 -31 -20 45 79 151 166 207 201 189 98 47 28 -62 -1 63 109 196 225 228 208 165 136 58 15 -37 5 37 57 162 185 187 192 149 121 25 -51 -26 33 34 115 159 170 195 179 145 90 40 9 -33 -54 11 111 126 164 204 191 127 82 49 33 -23 39 66 102 158 187 176 179 139 101 34 -14 14 -2 41 96 139 167 184 173 141 90 32 3 20 46 44 49 146 197 193 186 163 75 56 13 21 10 53 110 151 187 200 179 159 102 51 -10 9 27 60 104 146 198 205 198 164 98 41 -6 -48 12 37 108 161 160 184 216 149 100 29 -8 5 -14 36 124 149 154 180 182 169 101 65 38 22 31 80 112 165 204 209 190 152 120 55 -21 -87 17 54 85 163 178 192 203 166 112 51 27 8 21 39 84 135 172 195 193 177 113 68 56 19 8 13 106 149 175 197 194 168 99 66 54 -57 -13 45 93 134 185 225 229 171 112 41 21 -18 -70 58 113 174 197 217 192 157 109 13 31 -9 -9 53 110 146 187 212 179 154 92 49 32 -38 -46 18 98 133 168 207 179 155 84 5 -71 -83 -28 55 115 155 192 208 197 148 86 59 9 -42 -1 49 119 144 172 207 192 140 124 43 15 -10 7 43 96 133 176 182 204 150 104 39 10 -40 43 37 78 186 201 188 158 146 92 47 50 44 12 43 82 177 203 240 220 177 103 42 21 8 26 42 88 154 187 215 195 162 93 4 -10 -20 6 78 89 117 184 199 191 147 116 35 24 1 -13 11 72 123 174 173 204 130 93 39 -6 -92 -66 28 66 141 171 184 169 163 87 19 -11 -9 9 10 48 135 198 194 169 157 108 58 19 -21 -7 -5 90 130 168 177 175 143 73 65 -77 -24 -62 45 104 179 163 180 184 161 121 54 39 -47 -40 46 71 157 179 191 224 155 76 16 19 7 43 26 96 127 156 178 190 138 94 50 39 -13 -3 27 93 133 173 161 159 145 98 62 -34 3 -56 -31 91 118 187 199 170 134 100 56 26 3 28 64 102 137 189 204 209 157 121 23 -34 -38 -10 23 64 165 154 188 192 127 78 28 9 -86 27 53 112 139 191 192 184 136 108 36 -5 -28 33 29 78 146 176 178 169 137 88 18 -12 -61 35 9 94 139 179 185 184 131 79 56 9 -3 -3 36 104 108 168 176 180 125 114 11 8 23 22 14 56 148 178 211 191 149 88 65 42 16 -16 -21 58 130 175 197 185 147 93 29 -56 -10 0 40 84 149 161 195 174 141 95 16 26 -28 -66 22 70 127 179 186 186 135 119 40 -59 -4 24 15 108 136 177 172 188 138 102 6 2 -29 -31 35 89 140 181 197 200 154 125 14 17 -33 -52 20 80 126 200 186 182 166 97 -30 8 7 24 72 88 141 181 227 211 139 106 31 -27 13 -14 21 86 147 181 168 177 143 80 12 -10 -51 25 55 68 120 193 198 201 146 100 52 -5 -22 -2 63 112 163 169 192 180 153 114 48 4 27 27 55 92 145 177 181 204 152 112 52 27 -74 0 58 66 108 177 176 167 147 80 24 -46 -3 -62 -1 103 180 153 222 181 159 98 55 4 34 41 34 111 114 198 179 171 172 75 46 22 -10 41 20 93 134 173 182 194 157 96 27 -10 -10 44 48 88 189 201 213 217 175 106 25 45 -17 49 21 117 153 149 206 173 161 74 38 9 -9 -52 5 77 150 169 206 173 131 84 46 -8 -62 -25 51 80 109 147 196 193 156 66 14 -57 -15 14 53 106 155 169 203 181 165 113 68 29 20 1 53 83 115 176 215 205 144 111 46 5 5 2 38 101 108 175 225 178 174 96 13 -10 7 -55 5 80 150 201 195 210 145 69 21 -21 -35 6 50 110 105 188 199 195 139 109 7 19 20 27 26 72 115 203 196 199 122 77 59 7 -5 25 39 102 147 183 180 191 166 107 33 -9 -18 17 23 77 124 182 170 195 164 89 13 -86 -18 -11 38 106 123 174 199 177 155 97 46 42 -50 2 33 62 137 166 204 184 130 59 46 13 6 18 78 89 136 155 192 164 152 99 47 10 -6 24 -7 67 145 182 186 178 150 98 47 11 32 25 52 66 147 148 199 181 155 86 23 27 -24 21 39 118 132 201 198 150 150 91 37 -4 -10 -10 7 107 149 165 193 193 169 104 52 15 -47 -8 22 92 121 168 216 179 148 72 46 -4 -24 -11 27 79 152 178 172 174 139 81 28 9 -18 -12 8 91 184 206 188 180 123 96 28 -20 22 -17 55 89 158 159 179 197 141 85 35 -40 -44 -10 40 62 158 168 184 173 149 106 27 22 -8 11 10 83 139 182 183 215 161 83 24 -16 -78 23 50 94 137 178 196 185 141 113 28 5 -27 26 51 113 135 161 198 178 123 96 51 8 -42 -64 21 96 134 175 203 184 163 84 50 3 -26 5 57 71 122 183 191 167 146 101 24 -7 -10 14 64 88 125 186 185 188 139 75 24 13 14 21 52 97 144 171 172 203 151 99 60 32 23 16 35 90 130 164 188 177 140 84 64 -45 0 17 10 75 123 181 203 191 156 95 62 24 -45 -44 28 90 150 184 201 183 143 104 32 17 39 4 43 86 107 174 178 171 139 79 7 -42 -5 43 67 65 147 168 184 181 144 102 56 -3 -6 21 45 102 136 173 210 194 136 93 39 28 -21 21 60 70 139 190 205 184 144 56 43 21 13 14 35 101 150 167 196 184 137 94 71 -17 -4 -2 33 71 156 178 167 188 141 127 25 18 -24 21 37 72 162 191 194 166 133 87 11 -11 -17 -19 27 92 126 168 174 190 149 105 30 14 19 30 45 85 143 185 176 175 129 95 31 31 -7 15 49 90 146 178 216 213 159 91 53 27 -35 17 67 80 137 179 199 161 101 72 23 28 -10 10 71 93 140 167 165 165 139 90 68 29 -34 3 56 108 133 166 194 189 138 94 47 24 12 13 24 84 152 199 188 166 128 77 21 40 45 12 68 98 154 150 182 177 136 96 52 37 -14 -48 9 54 164 211 202 193 162 92 54 -12 10 20 51 114 157 159 189 182 156 92 34 41 17 -2 42 69 118 168 168 183 169 76 13 10 27 24 68 117 157 163 199 175 147 66 12 12 50 18 59 90 161 161 206 199 145 115 9 3 -22 -25 46 74 152 181 181 170 125 63 30 20 14 8 58 77 146 132 203 181 149 116 39 -13 -29 -24 28 79 158 168 189 169 156 102 30 5 28 44 24 94 158 166 190 180 128 92 36 -3 -3 44 47 112 131 154 192 175 160 93 76 12 26 5 67 86 128 170 197 187 154 92 36 -25 21 24 29 88 121 163 216 186 143 92 74 1 -54 -110 20 60 151 169 199 191 167 115 58 40 12 3 61 102 137 209 192 177 151 97 68 8 2 -2 11 67 177 189 196 175 115 81 43 3 17 -20 8 94 154 161 205 203 176 103 48 2 -29 10 52 77 138 164 207 193 148 104 36 -36 6 17 63 118 161 191 210 192 171 106 53 63 -5 24 28 92 126 205 203 195 159 104 59 10 32 15 59 89 146 184 198 180 146 73 41 15 -20 26 54 94 176 194 197 193 153 107 44 8 15 21 86 63 133 186 194 200 148 107 71 -8 26 26 25 112 122 181 197 201 150 76 60 -14 -88 -57 31 97 132 188 185 162 143 87 59 -36 -52 5 42 68 112 179 203 177 129 88 21 16 -86 -44 12 85 148 166 188 201 183 120 39 14 -14 39 67 108 144 166 203 210 158 109 39 0 39 -6 16 93 131 166 197 218 150 104 52 -7 -37 45 72 104 157 188 206 184 149 105 48 14 -21 33 57 116 170 178 211 192 159 69 41 -28 -54 -62 37 114 166 201 213 202 191 82 64 19 36 6 60 125 160 180 182 190 160 99 49 -1 7 20 30 119 152 159 198 192 168 110 53 42 -17 26 63 95 166 207 209 200 149 86 49 -9 19 31 36 96 139 180 197 204 166 84 73 28 14 12 23 125 140 177 216 214 127 86 33 -5 1 9 56 115 146 193 210 186 158 116 46 21 -34 -46 63 73 142 196 168 194 158 107 39 34 -15 -10 16 77 131 172 194 186 151 92 46 28 8 -94 27 75 145 158 196 175 157 99 24 21 4 42 69 95 122 199 205 174 134 97 60 8 -5 31 5 66 166 171 195 189 154 104 63 27 8 -6 66 111 148 187 208 193 144 91 48 31 -8 -2 45 90 148 185 183 189 144 100 69 28 -8 45 79 132 125 186 180 180 172 114 43 -5 17 5 13 111 122 170 178 195 145 93 45 -33 -63 -46 32 104 146 186 211 193 159 101 86 -31 -35 4 12 109 160 206 210 177 154 91 62 10 24 -12 29 88 127 179 184 178 146 83 21 38 -28 53 50 116 152 193 186 178 148 132 39 28 3 36 68 92 151 177 214 190 159 129 48 14 -8 22 60 109 136 188 190 182 151 111 50 -10 -2 -7 19 90 167 176 209 185 157 101 67 -46 -18 2 29 81 133 191 198 187 147 98 72 16 -22 28 25 107 160 163 206 212 134 97 48 49 -14 29 71 95 144 181 206 186 128 78 59 10 6 26 60 74 151 183 196 201 167 89 41 11 38 46 83 104 139 163 181 202 156 73 52 59 48 14 56 93 147 173 208 209 184 91 40 25 21 16 23 94 154 194 217 181 145 115 65 3 5 33 80 81 146 186 191 182 135 106 66 18 20 -5 65 92 136 174 180 174 142 101 48 23 -34 7 59 88 158 207 174 185 148 86 52 53 -28 33 45 73 124 175 171 189 144 96 40 16 -13 13 86 93 156 188 186 191 157 102 60 -8 -33 4 62 82 157 194 214 200 178 112 61 35 50 -8 63 116 151 189 233 201 156 111 40 11 18 9 41 88 139 168 181 191 142 117 61 16 -50 -24 48 100 161 160 200 195 155 100 24 49 13 -48 51 104 175 184 195 191 139 107 63 26 -52 4 8 111 128 170 201 177 167 106 62 32 40 36 41 107 170 177 201 198 156 111 28 40 26 49 87 103 161 178 203 197 163 117 33 28 25 65 91 96 167 187 198 209 136 110 50 18 27 -16 75 93 116 172 216 201 167 96 77 8 27 40 59 103 170 203 217 230 160 88 58 14 30 -11 47 123 181 184 190 194 145 97 23 48 21 -12 60 79 127 163 218 184 136 63 58 18 -15 40 24 85 124 145 205 179 125 102 7 -27 -46 -39 -4 85 120 160 157 167 100 90 42 -52 -46 23 46 53 133 160 171 190 135 65 24 11 4 36 39 100 143 172 170 176 127 85 6 -7 5 -13 49 91 142 154 188 174 168 84 21 7 -11 31 41 111 156 179 156 190 135 107 52 9 -16 9 38 72 144 143 183 186 117 118 23 -21 1 43 46 82 154 176 188 193 127 77 43 -20 -16 -34 46 81 153 201 191 211 143 55 45 -1 -34 18 36 95 119 158 177 191 140 95 38 0 9 -31 20 101 140 166 185 166 150 99 26 -4 -53 -20 12 89 135 177 224 158 167 108 60 33 42 37 59 117 151 186 187 184 124 81 21 2 22 35 37 82 141 177 185 182 127 86 46 10 -36 -3 41 130 142 151 186 196 160 80 64 -8 -45 -16 37 90 119 173 209 177 123 68 48 -52 ##### Sheet/List 4 ##### Terms of Use © 2009 Vertex42 LLC. All rights reserved. http://www.vertex42.com/ExcelTemplates/box-whisker-plot.html "This TermsOfUse worksheet may not be modified, removed, or deleted." Limited Use Policy "You may make archival copies and customize this template (the ""Software"") for personal use or for your" company use. The customized template (with your specific personal or company information) may be "used and shared within your company, but this template or any document including or derived from" "this template may NOT be sold, distributed, or placed on a public server such as the internet." No Warranties "THE SOFTWARE AND ANY RELATED DOCUMENTATION ARE PROVIDED TO YOU ""AS IS.""" "VERTEX42, LLC MAKES NO WARRANTIES, EXPRESS OR IMPLIED, AND EXPRESSLY DISCLAIMS ALL" "REPRESENTATIONS, ORAL OR WRITTEN, TERMS, CONDITIONS, AND WARRANTIES, INCLUDING BUT NOT" "LIMITED TO, IMPLIED WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, AND" NONINFRINGEMENT. WITHOUT LIMITING THE ABOVE YOU ACCEPT THAT THE SOFTWARE MAY NOT MEET "YOUR REQUIREMENTS, OPERATE ERROR FREE, OR IDENTIFY ANY OR ALL ERRORS OR PROBLEMS, OR DO" SO ACCURATELY. This Agreement does not affect any statutory rights you may have as a consumer. Limitation of Liability "IN NO EVENT SHALL VERTEX42, LLC BE LIABLE TO YOU, FOR ANY DAMAGES, INCLUDING ANY LOST PROFITS," "LOST SAVINGS, OR ANY OTHER DIRECT, INDIRECT, SPECIAL, INCIDENTAL, OR CONSEQUENTIAL DAMAGES" ARISING FROM THE USE OR THE INABILITY TO USE THE SOFTWARE (EVEN IF WE OR AN AUTHORIZED DEALER "OR DISTRIBUTOR HAS BEEN ADVISED OF THE POSSIBILITY OF THESE DAMAGES), OR ANY MISTAKES AND" "NEGLIGENCE IN DEVELOPING THIS SOFTWARE, OR FOR ANY CLAIM BY ANY OTHER PARTY. THE " "ORGANIZATION, BUSINESS, OR PERSON USING THIS SOFTWARE BEARS ALL RISKS AND RESPONSIBILITY " FOR THE QUALITY AND PERFORMANCE OF THIS SOFTWARE. "Somes states do not allow the limitation or exclusion of liability for incidental or consequential damages," so the above limitation may not apply to you. ##### Sheet/List 5 ##### Box Plot Template © 2009 Vertex42 LLC http://www.vertex42.com/ExcelTemplates/box-whisker-plot.html