Instructions: Create a single pivot table to find the average for each numerical variable in the data for each different cellphone-carrier-gender combination.

D G H I J K L M 29 Signal strength 30 31 Cell Phone Survey 32 33 Gender Carrier 34 M AT&T 35 M AT&T 36 M AT&T 37 M AT&T 38 M AT&T 39 M AT&T 40 M AT&T 41 M AT&T 42 M AT&T 43 F AT&T 44 M AT&T 45 M AT&T 46 F AT&T 47 M AT&T 48 F AT&T 49 M AT&T 50 F AT&T 51 M AT&T 52 M AT&T 53 M AT&T 54 F AT&T 55 F AT&T 56 F AT&T 57 M AT&T 58 M AT&T 59 F AT&T 60 M Other 61 M Other 62 M Other 63 M Other 64 M Other 65 F Other 66 M Other 67 F Other 68 M Other 69 M Sprint 70 M Sprint 71 F Sprint 72 F Sprint 73 M Sprint 74 F T-mobile 75 M T-mobile 76 M Verizon 77 F Verizon 78 F Verizon 79 M Verizon 80 F Verizon 81 M Verizon 82 M Verizon 83 F Verizon 84 M Verizon 85 F Verizon R6 Type Basic Camera Smart Smart Basic Camera Smart Smart Camera Camera Camera Smart Camera Camera Camera Basic Camera Smart Smart Camera Smart Smart Camera Smart Camera Camera Basic Basic Basic Basic Smart Basic Camera Camera Camera Smart Smart Smart Smart Camera Basic Basic Basic Camera Camera Smart Smart Smart Basic Smart Smart Smart Usage Average Average High High Average Very high Average Very high Average Very high Average Very high Average Average Very high Low Average Very high Very high Average Very high Very High Very high Very High Very high Low Average Very high Very high Low Average Average Average Average Average Very high Very High Average Average Average Low Average Value for the Dollar Customer Service 3 3 3 5 4 5 5 4 4 5 4 2 3 3 2 2 1 3 4 4 4 2 3 3 2 4 3 3 3 3 5 5 3 5 5 2 4 3 3 4 2 4 2 4 1 3 3 3 2 4 3 4 3 5 3 4 4 3 3 3 2 3 4 3 4 3 2 3 3 3 1 4 3 3 4 2 3 3 3 5 3 3 1 3 4 4 2 1 2 4 2 3 3 3 3 3 2 3 3 4 3 4 3 5 4 3 5 3 2 5 4 3 5 4 3 4 4 3 4 4 3 3 3 3 4 3 4 3 4 3 1 3 3 4 3 2 5 5 5 4 2 4 3 3 3 4 4 2 4 5 3 LOW Very High Very High Average Very high Very high Average Average Very high Very high D G H I J K L M 29 Signal strength 30 31 Cell Phone Survey 32 33 Gender Carrier 34 M AT&T 35 M AT&T 36 M AT&T 37 M AT&T 38 M AT&T 39 M AT&T 40 M AT&T 41 M AT&T 42 M AT&T 43 F AT&T 44 M AT&T 45 M AT&T 46 F AT&T 47 M AT&T 48 F AT&T 49 M AT&T 50 F AT&T 51 M AT&T 52 M AT&T 53 M AT&T 54 F AT&T 55 F AT&T 56 F AT&T 57 M AT&T 58 M AT&T 59 F AT&T 60 M Other 61 M Other 62 M Other 63 M Other 64 M Other 65 F Other 66 M Other 67 F Other 68 M Other 69 M Sprint 70 M Sprint 71 F Sprint 72 F Sprint 73 M Sprint 74 F T-mobile 75 M T-mobile 76 M Verizon 77 F Verizon 78 F Verizon 79 M Verizon 80 F Verizon 81 M Verizon 82 M Verizon 83 F Verizon 84 M Verizon 85 F Verizon R6 Type Basic Camera Smart Smart Basic Camera Smart Smart Camera Camera Camera Smart Camera Camera Camera Basic Camera Smart Smart Camera Smart Smart Camera Smart Camera Camera Basic Basic Basic Basic Smart Basic Camera Camera Camera Smart Smart Smart Smart Camera Basic Basic Basic Camera Camera Smart Smart Smart Basic Smart Smart Smart Usage Average Average High High Average Very high Average Very high Average Very high Average Very high Average Average Very high Low Average Very high Very high Average Very high Very High Very high Very High Very high Low Average Very high Very high Low Average Average Average Average Average Very high Very High Average Average Average Low Average Value for the Dollar Customer Service 3 3 3 5 4 5 5 4 4 5 4 2 3 3 2 2 1 3 4 4 4 2 3 3 2 4 3 3 3 3 5 5 3 5 5 2 4 3 3 4 2 4 2 4 1 3 3 3 2 4 3 4 3 5 3 4 4 3 3 3 2 3 4 3 4 3 2 3 3 3 1 4 3 3 4 2 3 3 3 5 3 3 1 3 4 4 2 1 2 4 2 3 3 3 3 3 2 3 3 4 3 4 3 5 4 3 5 3 2 5 4 3 5 4 3 4 4 3 4 4 3 3 3 3 4 3 4 3 4 3 1 3 3 4 3 2 5 5 5 4 2 4 3 3 3 4 4 2 4 5 3 LOW Very High Very High Average Very high Very high Average Average Very high Very high