0% found this document useful (0 votes)
9 views3 pages

Student Test Results and Grades Analysis

The document displays test results for 16 students in 15 questions, including their grades which range from 40% to 100%. On average, students scored 67% on the test with a median score of 67%. Most students (56%) answered question 1 correctly while the fewest (31%) answered question 6 correctly.

Uploaded by

Matoawka
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
0% found this document useful (0 votes)
9 views3 pages

Student Test Results and Grades Analysis

The document displays test results for 16 students in 15 questions, including their grades which range from 40% to 100%. On average, students scored 67% on the test with a median score of 67%. Most students (56%) answered question 1 correctly while the fewest (31%) answered question 6 correctly.

Uploaded by

Matoawka
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

STUDENT 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 0 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% 75% 75% 69% 63%
Per Question Percent

Test Results Least to Greatest


Average (Mean) 67.14 53 40
Median 67.00 80 47
Mode 53.00 53 53
Range 60.00 47 53
100 53
67 60
60 60
80 67
67 67
60 67
93 73
53 80
80 80
40 80
73 93
67 100
10 11 12 13 14 15 Grade MAX 100%
0 0 1 1 1 0 53% CLASS AVG 67%
1 0 1 1 0 0 80% MIN 40%
0 0 1 1 0 1 53%
1 0 1 1 1 0 47% 90's A 2
1 1 1 1 1 1 100% 80's B 3
0 0 1 1 1 1 67% 70's C 1
1 0 1 1 0 0 60% 60's D 5
0 1 0 1 1 1 80% 50's Fail 5
1 0 1 1 1 0 67%
1 0 0 1 1 1 60%
1 1 1 1 1 1 93%
1 0 1 0 0 1 53%
1 1 1 1 1 1 80%
0 0 0 1 1 1 40%
1 1 1 0 1 0 73%
1 0 1 1 0 1 67%
69% 31% 81% 88% 69% 63%

Student Pass/Fail Data


6

90's A 80's B 70's C 60's D 50's Fail


Addition Subtraction Division
80% 40% 33%
100% 80% 50%
80% 60% 17%
60% 20% 50%
100% 100% 83%
60% 80% 50%
80% 60% 33%
80% 80% 67%
100% 60% 33%
80% 40% 50%
80% 100% 83%
60% 40% 50%
80% 100% 50%
40% 40% 33%
60% 100% 50%
60% 80% 50%

Data

50's Fail

You might also like