Scribd
Upload
115 views3 pages

Analyzing Data Assignment

The document shows test scores for 16 students across 15 questions. It includes averages for each question, each student, and the class. Overall, the class average was 67%, with scores ranging from 40% to 100%. The most common grade was a 50S, earned by 4 students.

Uploaded by

api-549219288
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
115 views3 pages

Analyzing Data Assignment

The document shows test scores for 16 students across 15 questions. It includes averages for each question, each student, and the class. Overall, the class average was 67%, with scores ranging from 40% to 100%. The most common grade was a 50S, earned by 4 students.

Uploaded by

api-549219288
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

1 2 3 4 5 6 7 8 9

Patrick 0 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 0 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

Q, AVG 56% 75% 65% 100% 31% 75% 75% 68% 62%

MEAN 67% MEDIAN 67% MODE 53%


10 11 12 13 14 15 ADD AVG
0 0 1 1 1 0 53% 80%
1 0 1 1 0 0 80% 100%
0 0 1 1 0 1 53% 80%
1 0 1 1 1 0 47% 60%
1 1 1 1 1 1 100% 100%
0 0 1 1 1 1 67% 60%
1 0 1 1 0 0 60% 80%
1 1 0 1 1 1 87% 80%
1 0 1 1 1 0 73% 100%
1 0 0 1 1 1 53% 80%
1 1 1 1 1 1 93% 80%
1 0 1 0 0 1 53% 60%
1 1 1 1 1 1 80% 80%
0 0 0 1 1 1 40% 40%
1 1 1 0 1 0 73% 60%
1 0 1 1 0 1 67% 60%

75% 31% 81% 87% 68% 62% CLASS AVG 67%

RANGE 60%
SUB AVG
40% MAX 100%
80% AVG 67%
60% MIN 40%
20%
100% 90S 2
80% 80S 3
60% 70S 2
80% 60S 3
80% 50S 4
20% FAILING 2
100%
40%
100% Class Percentages'
40% 4.5
100% 4
80% 3.5
Number of Students

3
2.5
2
1.5
1
0.5
0
90S 80S 70S 60S 50S FAILING
Grade

You might also like