Scribd Logo
Upload

Welcome to Scribd!

  • 29 views

    Box Whisker Chart

    Uploaded by

    RANAIVOARIMANANA

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd

    Box Whisker Chart

    Uploaded by

    RANAIVOARIMANANA
    29 views6 pages

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    29 views6 pages

    Box Whisker Chart

    Uploaded by

    RANAIVOARIMANANA

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    of 6

    Box and Whisker Chart Template

    This chart isn't available in your version of Excel.


    160
    Editing this shape or saving this workbook into a different file format will permanently break the chart.
    140
    120

    100
    80

    60
    40
    20

    0
    Sample 1 Sample 2 Sample 3 Sample 4 Sample 5 Sample 6
    -20

    -40

    Min Outlier Max Outlier

    Summary Stats Sample 1 Sample 2 Sample 3 Sample 4 Sample 5 Sample 6


    Minimum 25 -23 25 -10 20 -30
    1st Quartile: Q1 51 17.163693767 77 50.5 75.25 -9.5
    Median 63 21.87021149 92 94 83.5 12
    3rd Quartile: Q3 80 39.574058842 99 118.25 93.75 27.5
    Maximum 108 120 108 145 140 90
    IQR 29 22.410365076 22 67.75 18.5 37
    Mean 68 29 86 87 84 11
    Calculations for the Whiskers
    1.5*IQR 162 180 162 217.5 210 135
    Q3+1.5*IQR 123.5 73.189606456 132 219.875 121.5 83
    Q1-1.5*IQR 7.5 -16.451853847 44 -51.125 47.5 -65
    Min (ex-outliers) 25 12.079733103 64 -10 63 -30
    Max (ex-outliers) 108 48.031902726 108 145 100 35
    Upper Whisker 108 48.031902726 108 145 100 35
    Lower Whisker 25 12.079733103 64 -10 63 -30
    Wupper-Q3 28 8.4578438841 9 26.75 6.25 7.5
    Q1-Wlower 26 5.0839606637 13 60.5 12.25 20.5

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


    52 -23.0 102 116 98 -10
    63 17.0 99 98 97 18
    107 78.6 25 95 94 34
    54 48.0 100 67 20 20
    79 30.5 30 48 98 90
    80 20.9 75 109 96 35
    108 120.0 106 72 83 -30

    https://www.vertex42.com/ExcelTemplates/box-whisker-plot.html © 2020 Vertex42 LLC


    Data Table Sample 1 Sample 2 Sample 3 Sample 4 Sample 5 Sample 6
    80 42.4 91 125 140 -5
    78 30.7 82 145 75 -9
    106 14.5 84 119 76 3
    80 17.2 75 92 72 9
    61 34.9 93 46 84 23
    42 42.2 98 55 89 12
    104 22.8 97 116 90 32
    39 20.8 99 137 92 12
    104 20.3 96 70 95 -15
    59 24.1 92 131 91 -30
    73 28.7 108 93 99
    62 14.1 102 138 100
    80 41.9 64 40 63
    26 38.8 84 98 74
    91 12.3 77 49 76
    25 17.5 90 -10 82
    63 12.1 97 40 93
    51 18.9 93 92
    28 19.7 85 78
    41 75 73
    68
    82
    89
    86
    72
    74
    79
    78
    81

    Insert new rows above this line

    https://www.vertex42.com/ExcelTemplates/box-whisker-plot.html © 2020 Vertex42 LLC


    School 1 School 2 School 3 School 4 This chart isn't available in your version of Excel.
    10th Grade 72.0 87.9 79.4 72.1
    10th Grade 75.2 78.3 86.5 77.9 Editing this shape or saving this workbook into a different file for
    10th Grade 68.8 76.0 76.7 80.2 the chart.
    10th Grade 97.0 79.4 75.0 85.1
    10th Grade 76.0 82.5 84.6 82.6
    10th Grade 73.0 88.2 86.1 79.3
    10th Grade 76.1 76.9 100.0 74.4
    10th Grade 68.2 83.5 87.1 55.0
    10th Grade 73.9 73.8 85.6 85.0
    11th Grade 71.1 83.7 91.8 81.8
    11th Grade 71.7 80.7 85.0 98.0
    11th Grade 71.3 74.2 80.7 83.7
    11th Grade 80.8 77.6 71.6 81.3
    11th Grade 74.7 79.5 89.6 81.7
    11th Grade 68.6 89.9 84.3 85.6
    11th Grade 76.0 78.2 83.3 57.0
    11th Grade 80.4 79.8 77.9 79.2
    11th Grade 78.8 81.4 97.7 74.2
    12th Grade 80.8 82.8 86.2 68.3
    12th Grade 69.1 77.8 83.8 77.0
    12th Grade 69.6 76.8 82.2 83.2
    12th Grade 74.6 81.1 80.8 80.1
    12th Grade 71.1 76.1 89.6 83.6
    12th Grade 76.7 77.1 87.5 80.9
    12th Grade 77.8 93.7 92.6 75.3
    12th Grade 76.4 76.7 80.1 75.6
    12th Grade 70.4 73.3 82.9 84.0
    12th Grade 81.8 78.5 97.7 81.7
    of Excel.

    k into a different file format will permanently break


    Box and Whisker Chart

    By Vertex42.com
    https://www.vertex42.com/ExcelTemplates/box-whisker-plot.html

    © 2020 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.

    License Agreement
    https://www.vertex42.com/licensing/EULA_privateuse.html

    Do not delete this worksheet

    You might also like