excel homework

profilefavgadhed
alqadheeb_e03ps1_grader_h1_start.xlsx

Enrollment

Count of Students
Average Fee
Total Revenue
Student_ID Class Gender Fee
X2396G23 Z23 F
X6260G23 A22 M
X2637G23 A22 M
X6649G23 Y23 F
X3307G23 S39 M
T4742G23 Z23 F
T1011G23 Z23 F
T6528G23 A22 M
T2068G23 Z23 M
X8696G23 A39 F
T9032G23 T22 F
T5701G23 J49 F
X6613G23 Z23 M
T5406G23 A39 F
T5178G23 T22 M
X5420G23 S39 M
T4814G23 A22 F
X9593G23 Z23 M
T1993G23 A39 M
T4370G23 T22 F
X3127G23 J49 M
X2204G23 S39 F
T4313G23 A22 F
T3335G23 S39 F
T4327G23 Z23 F
X8027G23 A39 F
X1934G23 Y23 F
X5554G23 J49 M
T5210G23 S39 M
X5585G23 A22 F
X7651G23 S39 F
T3628G23 Z23 M
X9847G23 Z23 F
T4087G23 J49 F
T4297G23 A39 M
T2084G23 Y23 F
X7597G23 Y23 M
T3720G23 Y23 M
T4413G23 S39 F
T3335G23 S39 F
T3994G23 T22 F
X7892G23 J49 M

Input Data

Class ID Z23 J49 Y23 A22 S39 A39 T22
Class Category Zumba Jazzercise Yoga Step Aerobics Swimmercize Aerobics Tai Chi
Target Class Size 20 20 10 30 10 30 20
Can Split Y Y N Y Y Y N
Fee $50.00 $35.00 $40.00 $25.00 $25.00 $30.00 $75.00
Zumba_I Jazzercise_I Yoga_I Step_Aerobics_I Swimmercize_I Aerobics_I Tai_Chi_I
Joe Joe Shanti Joe Francine Joe Shanti
Jill Jill Bill Jill Bill
Alesha Alesha

Report

Class Gender Enrolled Report Class Report Gender
Z23 x F
J49 M
Y23
Max Enrollment A22
Class Type x S39
A39
NOTES T22
Availability
Number of Instructors
Options