Question

F20 BUS210 019 / 0200 Homework: Homework4 T-Mobile mathxl.com/Student/PlayerHU 1 of 2 (0 complete) Score: 0 of 1 pt 2.6.37 Construct Pivot Tables showing the counts of gender versus carrier and type versus usage in the accompanying cell phone survey data. What could be concluded from this analysis? Click the icon to view the cell phone survey data. Cell Phone Survey Construct Pivot Tables showing the counts of gender versus carrier in the cell phone survey dala (Type whole numbers.) Count of Carrier AT&T Other Sprint T-Mobile Verizon Grand Total Gender Carrier Type Usage Signal Strength F M AT&T Smart High 5 M M M AT&T Smart High 5 Grand Total M AT&T Smart Very high 5 F AT&T Smart Very high 5 M Smart Very high 3 M Sprint Smart Very high 3 F Verizon Smart Very high 4 F Verizon Smart Very high 3 M Camera Very high ) Very high 2 M AT&T Camera Average 2 M AT&T Camera Average 4 M AT&T Camera Average 3 м Other Camera Average 3 F Other Camera Average 4 F Verizon Camera Very high 4 M AT&T Basic Low 3 м Other Basic Low 4 F Basic Average 2 M Verizon Basic Low 3 M Basic Average 4 Sprint Other Verizon Print Done Enter your answer in the edit Tields and then click Check Answer 3 parts remaining TE Clear All

Answer 1

If you like my explanation, please give a "thumbs up"

A B С D Create Pivot Table ? x 1 2 3 4 5 6 7 00 Choose the data that you want to analyze Select a table or range Table/Range: Sheet169$B$2:$C$22| O Use an external data source Choose Connection. Connection name: Choose where you want the PivotTable report to be placed O New Worksheet Existing Worksheet Location: Sheet169! $0$12 9 10 Gender IM M IM F IM M F F M M M M IM F SF M M F 11 Carrier AT&T AT&T AT&T AT&T Sprint Sprint Verizon Verizon T-mobile AT&T AT&T AT&T Other Other Verizon AT&T Other Other Verizon Verizon 12 13 OK Cancel 14 15 16 17 18 19 20 21 22 M 23 24

After insertiing Pivot table, make chages as below.

A B с D E F G Н. 1 J K L M N Pivot Table Field List х 1 2 Gender EEE Choose fields to add to report: 3 M Gender Carrier M 4 5 M Count of Gender Column Labels Row Labels AT&T F F M Grand Total Other Sprint T-mobile Verizon Grand Total 1 2 3 6 7 2 2 1 2 14 8 4 2 1 5 20 6 F 7 M M 8 9 Carrier AT&T AT&T AT&T AT&T Sprint Sprint Verizon Verizon T-mobile AT&T AT&T AT&T Other F 10 F 11 M 12 13 M M 14 M 15 M 16 F Drag fields between areas below: Y Report Filter Column Labels 17 F Other Verizon AT&T Other 18 M Carrier 19 M 20 F Other Verizon 21 M 22 M Verizon Row Labels Σ Values 23 Gender Count of Gen... → 24 25 26 27 Defer Layout Update Update Sheet163 Sheet164 Sheet165 Sheet166 Sheet168 Sheet167 Sheet169 SI Ready Em 100%