Student with highest attendance rate
This example shows how to calculate a student with the highest attendance rate by initially calculating the attendance rate of all students and then identifying the student with the highest attendance rate
Example: Student with highest attendance rate
|
This is a two step example. The first step uses this formula to calculate each of the students attendance rate across the five five classes. If a student attends a class "Attended" is entered into the cell, otherwise, if the student is absent "Absent" is entered into the cell. The table in range (C5:G9) captures the students attendance record and the attendance rate of each student is captured in range (H5:H9).
|
|
This formula is the second part of this example and it identifies the student with the highest attendance rate, using the list of students, captured in range (B5:B9), and the attendance rate, captured in range (H5:H9).
|
EXPLANATION
This example shows how to calculate a student with the highest attendance rate through a two step process. Initially, we calculate the attendance rate of each student and then calculate the student with the highest attendance rate. To achieve this we need to apply two different formulas, one to calculate the attendance rate of each student and the other to calculate the student with the highest attendance rate.
This example shows how to calculate a student with the highest attendance rate through a two step process. Initially, we calculate the attendance rate of each student and then calculate the student with the highest attendance rate. To achieve this we need to apply two different formulas, one to calculate the attendance rate of each student and the other to calculate the student with the highest attendance rate.
FORMULA (ATTENDANCE RATE)
=COUNTIF(attendance_record,"Attended")/COUNTA(attendance_record)
=COUNTIF(attendance_record,"Attended")/COUNTA(attendance_record)
FORMULA (STUDENT WITH HIGHEST ATTENDANCE RATE)
=INDEX(student_rng,MATCH(MAX(attendance_rate),attendance_rate,0))
=INDEX(student_rng,MATCH(MAX(attendance_rate),attendance_rate,0))
ARGUMENTS
attendance_record: The attendance record for each class by each student.
student_rng: List of students.
attendance_rate: The attendance rate of each student.
attendance_record: The attendance record for each class by each student.
student_rng: List of students.
attendance_rate: The attendance rate of each student.
APPLICATION
The calculation of a student with the highest attendance rate that is shown in this example can be applied to an educational environment. Educational institutions such as Universities, Colleges, High Schools and others can apply this example if they want to calculate student with the highest attendance rate.
The calculation of a student with the highest attendance rate that is shown in this example can be applied to an educational environment. Educational institutions such as Universities, Colleges, High Schools and others can apply this example if they want to calculate student with the highest attendance rate.