Attendance vs Performance

In the Table below:

Column 3 (Grade A):    The average attendance of students who got 93% or higher for the course.
Column 4 (Grade <C-): The average attendance of students who got 69% or lower for the course.
Column 6 (100% Attendance): The average performance (scores) of students who attended 100% of classes.
Column 7 (<90% Attendance): The average performance (scores) of students who attended <90% of classes.
Column 9 (Attendance of Top): The attendance of students who got the highest scores in their groups.
Column 10 (Attendance of Bottom): The attendance of students who got the lowest scores in their groups.

Quick analysis:

1. Overall, students who got A had better attendance than students who got <C- (columns 3 and 4).
Vice versa, students who attended all classes had better scores than students who attended
<90% of classes (columns 6 and 7). In short, better attendance, better performance and vice versa.

2. Most students who got the best scores in their groups attended all classes and have never been late (column 9).
Almost all students who got the lowest scores in their groups missed at least one class (column 10).

Semester Course Grade
A
 Grade
<C-
 Difference 100%
 Attendance
<90%
Attendance 		Difference Attendance
of
Top
 Attendance
 of
Bottom
 Difference Comments
Spring 2017 427J
 89.96%
 67.70%
 22.26%
 82.90%
 75.50%
 7.40%
 95.80% 12.5% 83.30%
Spring 2017 340L
 96.10%
 60%
 36.10%
 89.28%
 82.85%
 6.43%
 82.00%
 68.00%
 14.00%
Spring 2017 340L
 90.67%
89.52%
 83.32%
 6.20%
 100.00% 92.00%
 8.00%
 All students got 70% or higher.
Fall 2017 427J 93.60%
 95%
 -1.40%
 83.22%
 85.59%
 -2.37%
 100.00% 95.80%
 4.20%
Fall 2017 427J 96.76%
 56.09%
 40.67%
 84.60%
 74.85%
 9.75%
 100.00% 33.33%
 66.67%
Spring 2018 427J 88.45%
 96%
 -7.55%
 90.08%
 86.10%
 3.98%
 100.00% 96.00%
 4.00%
 Only one student got <C-.
Spring 2018 427J 95.60%
 87.20%
 8.40%
 89.52%
 79.53%
 9.99%
 100.00% 74.00%
 26.00%
Fall 2018 427J 96.79%
 73.08%
 23.71%
 86.80%
 73.67%
 13.13%
 100.00% 53.85%
 46.15%
Fall 2018 427J 99.57%
 90.38%
 9.19%
 81.75%
 78.60%
 3.15%
 100.00% 80.77%
 19.23%
Spring 2019 427J 97.63%
 79.40%
 18.23%
 87.64%
 79.21%
 8.43%
 94.44%
 90.28%
 4.16%
Spring 2019 427J 96.88%
 90.54%
 6.34%
 86.30%
 78.75%
 7.55%
 100.00% 87.50%
 12.50%
Fall 2019 427J 100%
 88.50%
 11.50%
 81.02%
 69.50%
 11.52%
 100.00% 92.00%
 8.00%
Fall 2019 427J 86.29%
 88%
 -1.71%
 80.69%
 78.86%
 1.83%
 100.00% 84.00%
 16.00%
 One student who got an A never attended a single class. The average attendance of other A students was 98%.
Spring 2020 427J 99.49%
 84.62%
 14.87%
 89.45%
 79.13%
 10.32%
 100.00% 100.00% 0.00%
Spring 2020 427J 99.18%
 98.72%
 0.46%
 90.12%
 83.65%
 6.47%
 100.00% 97.44%
 2.56%

Average:
 95.13%
 82.52%
 12.93%
 86.19%
 79.27%
 6.92%
 98.15%
 77.16%
 20.98%