I am trying to calculate mean grade points for students that have not enrolled for a particular class, to contrast with those who have.
The courses are separated as such, with columns that would ideally show: # that did not enroll, mean GPA did not enroll, # that enrolled, mean GPA for enrolled as such
(apologies for the edits).
Basically, I want to be able to take all data from people not enrolled in course A, and average their grade points, and so on for course B, C, etc.. displayed on the same row of the course that I am comparing.
Please attach a workbook.