Scribd Logo
Upload

Welcome to Scribd!

  • 3 views

    Excel Assignmentv 1

    Uploaded by

    lewisbjunk
    The document contains data from multiple data sets including frequency tables and charts with values, frequencies and percentages. It discusses editing charts and changing file formats. Sections include frequency tables with categories like good, excellent, fair and poor along with counts and cumulative percentages.

    Copyright:

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

    Excel Assignmentv 1

    Uploaded by

    lewisbjunk
    3 views8 pages
    The document contains data from multiple data sets including frequency tables and charts with values, frequencies and percentages. It discusses editing charts and changing file formats. Sections include frequency tables with categories like good, excellent, fair and poor along with counts and cumulative percentages.

    Original Title

    ExcelAssignmentv1

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document contains data from multiple data sets including frequency tables and charts with values, frequencies and percentages. It discusses editing charts and changing file formats. Sections include frequency tables with categories like good, excellent, fair and poor along with counts and cumulative percentages.

    Copyright:

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

    Excel Assignmentv 1

    Uploaded by

    lewisbjunk
    The document contains data from multiple data sets including frequency tables and charts with values, frequencies and percentages. It discusses editing charts and changing file formats. Sections include frequency tables with categories like good, excellent, fair and poor along with counts and cumulative percentages.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    You are on page 1of 8

    DATA SET

    1
    2
    1
    2
    3 MIN 0
    2 MAX 4
    1
    2
    2 Data Frequency Cumulative Relative
    2 0 3 3 4%
    1 1 21 24 30%
    3 2 23 47 33%
    3 3 15 62 21%
    3 4 8 70 11%
    3 70 206 100%
    4
    2 This chart isn’t available in your version of Excel.
    4
    3 Editing this shape or saving this workbook into a different file format will
    permanently break the chart.
    3
    1
    2
    4
    2
    4
    2
    4
    1
    0
    1
    1
    3
    2
    1
    2
    3
    1
    1
    3
    1
    2
    3
    1
    1
    2
    2
    0
    0
    3
    2
    4
    2
    1
    2
    1
    2
    3
    1
    4
    2
    3
    1
    2
    1
    1
    2
    1
    3
    4
    2
    xcel.

    o a different file format will


    DATA SET
    2467
    3373 This chart isn’t available in your version of Excel.
    434
    Editing this shape or saving this workbook into a different file format will
    1426
    permanently break the chart.
    4628
    167
    5927
    4064
    4503
    2600
    3673
    4231
    1788
    5805
    5395
    733
    4890
    1455
    5817
    1145
    846
    739
    4370
    986
    5729
    1159
    1021
    1563
    967
    499
    353
    2297
    289
    375
    162
    1740
    Quartile Data Point Frequency Cumulative Relative
    0 162.00 1 1 3%
    1 819.25 8 9 22%
    2 1651.50 9 18 25%
    3 4265.75 9 27 25%
    4 5927.00 9 36 25%
    36 55 100%
    G
    G
    E Frequency Table Cumulative Relative
    31
    G Good 31 31 52%
    F Excellent 16 47 27%
    G Fair 8 55 13%
    G Poor 5 60 8%
    E 100%
    16
    G
    E GOOD OR EXCELLENT 78%
    F
    G
    P
    G
    Good Excel
    E
    E
    G
    F
    G
    G
    E
    E
    F
    E
    G
    E
    P
    G
    G
    F
    E
    G
    E
    G
    G
    G
    G
    F
    E
    G
    E
    E
    G
    P
    G
    G
    E
    G
    P
    F
    E
    F
    G
    G
    P
    G
    G
    G
    G
    G
    31

    16

    8
    5

    Good Excellent Fair Poor

    You might also like