Scribd Logo
Upload

Welcome to Scribd!

  • 27 views

    Excel Worksheet

    Uploaded by

    api-402614544
    The document shows test scores for 16 students in various subjects. Overall, the class average was 68% with a median of 70% and mode of 80%. The highest scoring student received 100% while the lowest was 40%. Most students scored in the 60-80% range.

    Copyright:

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

    Excel Worksheet

    Uploaded by

    api-402614544
    27 views3 pages
    The document shows test scores for 16 students in various subjects. Overall, the class average was 68% with a median of 70% and mode of 80%. The highest scoring student received 100% while the lowest was 40%. Most students scored in the 60-80% range.

    Original Title

    excel worksheet

    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 shows test scores for 16 students in various subjects. Overall, the class average was 68% with a median of 70% and mode of 80%. The highest scoring student received 100% while the lowest was 40%. Most students scored in the 60-80% range.

    Copyright:

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

    Excel Worksheet

    Uploaded by

    api-402614544
    The document shows test scores for 16 students in various subjects. Overall, the class average was 68% with a median of 70% and mode of 80%. The highest scoring student received 100% while the lowest was 40%. Most students scored in the 60-80% range.

    Copyright:

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

    1 2 3 4 5 6 7 8 9

    Patrick 1 0 0 1 1 1 0 1 0
    Hugh 1 1 1 1 1 1 1 1 1
    Sarah 1 1 0 1 0 0 1 1 0
    Nathan 1 0 0 1 0 0 0 0 1
    Juan 1 1 1 1 1 1 1 1 1
    Bianca 0 1 1 1 0 1 1 0 1
    Kiara 1 1 0 1 0 0 1 1 1
    Jack 0 1 1 1 1 1 1 1 1
    Holly 1 1 1 1 0 1 1 1 0
    Molly 0 0 1 1 0 1 1 1 0
    Cody 0 1 1 1 1 1 1 1 1
    Claire 1 0 1 1 0 1 0 0 1
    Jamal 0 1 1 1 0 1 1 1 0
    Luke 0 1 0 1 0 1 0 0 0
    Hannah 1 1 0 1 0 1 1 1 1
    Carly 0 1 1 1 0 1 1 0 1
    56% 75% 63% 100% 31% 81% 75% 69% 63%
    Adding
    Subtract
    Divide Mean 68%
    Class Aver 68% Median 70%
    Mode 80%
    Range 60%
    10 11 12 13 14 15 Test Average Addition Subtraction
    0 0 1 1 1 0 53% 80% 40%
    1 0 1 1 0 0 80% 100% 80%
    0 0 1 1 0 1 53% 80% 60%
    1 0 1 1 1 0 47% 60% 20%
    1 1 1 1 1 1 100% 100% 100%
    0 0 1 1 1 1 67% 60% 80%
    1 0 1 1 0 0 60% 80% 60%
    0 1 0 1 1 1 80% 80% 80%
    1 0 1 1 1 0 73% 100% 80%
    1 0 0 1 1 1 60% 80% 40%
    1 1 1 1 1 1 93% 80% 100%
    1 0 1 0 0 1 53% 60% 40%
    1 1 1 1 1 1 80% 80% 100%
    0 0 0 1 1 1 40% 40% 40%
    1 1 1 0 1 1 80% 60% 100%
    1 1 1 1 0 1 73% 60% 100%
    69% 38% 81% 88% 69% 69%
    Subtraction
    MAX 100% 90s 2
    AVG 68% 80s 4
    MIN 40% 70s 2
    60s 3
    50s 5

    Test Grades
    50s
    60s
    70s
    Grading scale

    80s
    90s

    0 0.5 1 1.5 2 2.5 3 3.5 4 4.5 5


    Number of grades given

    You might also like