Data:

Question:

Student Gender 1 M 2 F 3 M 4 6 7 F 8 F 9 10 F 11 M 12 M 13 F 14 M 15 M 16 M 17 M 18 M 19 M 20 M 21 M 22 M Nationality USA USA South Korea USA India Thailand Taiwan Taiwan USA India USA India China Mexico USA USA USA India Canada USA USA USA India USA USA USA USA India China USA Taiwan USA China China China China China China USA Japan M M M F M M 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 M M M M M M F The file PO3_33.xlsx indicates the gender and nationality of the MBA incoming class at the Kelley School of Business at Indiana University. Recode Nationality so that all nationalities with a count of 1 are listed as other. Then, using Pivot Table, create a crosstab of Gender versus the recoded Nationality and an associated column chart. a. Express the counts as percentages of row totals. Round your answers to one decimal place, if necessary. Gender Male Female Grand Total Count Nationality China India Taiwan % % % % % % % % % % % % USA Other % % % Grand Total % % % Choose the appropriate column chart. (i) (ii) Count 100.0% Count 100.0% 80.0% 60.0% Gender llall - Llull M 40.0% IF 20.0% 0.0% China India Taiwan USA Other China India Taiwan USA Other Recoded Nationality Recoded Nationality (iii) Count 50.0% 45.0% 40.0% 35.0% 30.0% 25.0% Gender 45.0% 40.0% 35.0% 30.0% 25.0% 20.0% 15.0% 10.0% 5.0% 0.0% 20.0% 15.0% 10.0% 5.0% 0.0% China USA Other b. Express the counts as percentages of column totals. Round your answers to one decimal place, if necessary. Gender Count Nationality China Female Grand Total Male % India % % Taiwan % % % % USA % % Other % % % Grand Total % Choose the appropriate column chart. (i) Count (ii) Count 50.0% 100.0% 45.0% 80.0% Gender 60.0% Gender IM 40.0% 35.0% 30.0% 25.0% 20.0% 15.0% 10.0% 5.0% 0.0% 40.0% F 20.0% China India Taiwan China India Taiwan Other Recoded Nationality Recoded Nationality (iii) (iv) Count 100.0% 80.0% Count 50.0% 45.0% 40.0% 35.0% 30.0% 25.0% 20.0% 15.0% 10.0% 60.0% = [Lil Gender Gender IM IM 40.0% IF IF 20.0% 5.0% 0.0% 0.0% China India Taiwan USA Other China India Taiwan USA Other Recoded Nationality Recoded Nationality