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 #NENÍ_K_DISPOZICI #NENÍ_K_DISPOZICI 145 #NENÍ_K_DISPOZICI 140 130 Min #NENÍ_K_DISPOZICI #NENÍ_K_DISPOZICI 30 40 10 #NENÍ_K_DISPOZICI 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 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 #NENÍ_K_DISPOZICI #NENÍ_K_DISPOZICI 145 #NENÍ_K_DISPOZICI 140 130 Min #NENÍ_K_DISPOZICI #NENÍ_K_DISPOZICI 30 40 10 #NENÍ_K_DISPOZICI ##### Sheet/List 3 ##### 98 88 102 70 98 97 87 99 71 97 94 84 102 72 94 98 88 100 73 98 96 86 106 74 96 83 73 91 75 83 83 75 65 82 76 75 75 76 66 84 77 76 76 72 62 75 78 72 72 84 74 93 79 84 84 89 79 98 80 89 89 90 80 97 81 90 90 92 82 99 82 92 92 95 85 96 83 95 95 91 81 92 84 91 91 99 89 108 85 99 99 100 90 102 86 100 100 63 53 64 87 63 63 74 64 84 88 74 74 76 66 77 89 76 76 82 72 90 90 82 82 93 83 97 91 93 93 92 82 93 92 92 78 68 85 78 78 73 63 75 73 73 68 58 70 68 68 82 91 82 82 89 95 89 89 86 94 86 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 ##### 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