-

1 A B C E "Do we have enough tutors for each subject?" G H 2 Status ID State Country Preferred Hours/Week Expertise Time Zone End Date Pay $/hr 3 Inactive 001 WA USA 0 Biology Pacific 3/30/2022 120 4 Active 002 OB Canada 8 Chemistry Eastern 9/1/2023 65 5 Inactive 003 MA USA 0 Biology Eastern 3/30/2022 55 6 Active 004 CA USA 25 Chemistry Pacific 5/10/2022 55 7 Training 005 MI USA 10 Biology Eastern 9/4/2024 80 8 Active 006 BC Canada 20 Biology Pacific 6/1/2022 80 9 Active 007 ON Canada 30 Biology Mountain 6/1/2022 75 10 Inactive 008 OH Canada 0 Chemistry Pacific 3/30/2022 55 11 Active 009 FL USA 10 Chemistry Eastern 7/26/2021 55 12 Active 010 PA USA 6 Chemistry Eastern 8/8/2022 60 13 Active 011 UT USA 35 Chemistry Mountain 8/2/2022 50 14 Active 012 MI USA 10 Physics UK 8/1/2023 50 15 Training 013 OH USA 10 Chemistry Eastern 8/13/2023 50 16 Training 014 OH USA 10 Chemistry Eastern 8/7/2023 75 17 Active 015 NY USA 15 Biology Eastern 8/1/2023 75 18 Inactive 016 TX USA 0 Biochemistry Mountain 3/28/2022 65 19 Active 017 IA USA 6 Physics Central 6/1/2022 45 20 Active 018 TX USA 15 Chemistry Eastern 8/1/2022 70 21 Active 019 CA USA 20 Physics Pacific 7/1/2022 55 22 Active 020 NJ USA 25 Physics Eastern 8/1/2022 65 23 Active 021 AZ USA 10 Chemistry Arizona 8/9/2021 50 24 Active 022 NY USA 6 Biology Eastern 9/1/2024 55 25 Active 023 UT USA 10 Physics Mountain 8/1/2022 60 26 Active 024 IL USA 20 Physics Central 9/1/2023 70 27 Active 025 BC Canada 30 Chemistry Pacific 4/23/2022 70 28 Training 026 ON Canada 10 Biology Eastern 9/1/2020 50 29 Inactive 027 CA USA 0 Biochemistry Pacific 3/28/2022 70 30 Active 028 GA USA 30 Physics Eastern 7/15/2022 85 31 Training 029 GA USA 5 Chemistry Eastern 7/20/2020 60 32 Active 030 TX USA 2 Biology Central 8/1/2022 65 33 Inactive 031 CA USA 0 Chemistry Central 3/30/2022 60 34 Active 032 UT USA 15 Biochemistry Mountain 6/1/2018 65 35 Active 033 CA USA 5 Biochemistry Pacific 8/1/2023 70 36 Active 034 NY USA 25 Physics Eastern 3/30/2022 60 37 Inactive 035 AL USA 0 Biology Mountain 7/1/2022 60 38 Inactive 036 UT USA 0 Biology Central 3/28/2022 65 39 Training 037 NY USA 5 Biology Eastern 3/28/2022 50 40 Inactive 038 CA USA 0 Chemistry Eastern 8/1/2023 65 41 Active 039 PA USA 40 Physics Eastern 7/20/2022 85 42 Inactive 040 GA USA 0 Biology Central 7/12/2023 65 43 Active 041 MD USA 12 Chemistry Eastern 4/11/2022 60 44 45 46 Step 1: Create Pivot Table (select data -> Insert -> Pivot Table) Step 2: Select variable of interest 47 Step 3: Select dependent variables 48 49 50 Expertise Biochemistry f Preferred Hours 4.17% 51 Biology 20.42% 52 Chemistry 36.67% 53 Physics 38.75% 54 Grand Total 100.00%