i need help setting up the pivot table to get these answers. i only need to know what categories to put them under. thank you!

3 You will create pivot tables on separate tabs which answer the following questions. Each question will require a pivottable The pivot tables will be clearly labeled both in the tab and within the charting the coding tab to reflect the question the correspond with you will 4 need to wwer the precise value in the highlighted cell as well. 5 6 01. How many American Mon survived the titanie? 7 # 02. What is the average age of people from Britain in first class to one decimal place? 9 10 03. How many women were in third class, not from the America or Britain and survived? 11 12 Of How many American Men died in the Titanic? How many British women died in the Titanic 13 14 15 Variable name pclass survived Value labels 1 =1", 2= 2nd, 3 = 3 0 = Died, 1 = Survived 0 = American, 1 = British, 2 = Other Residence Name age sibsp parch Variable label Data type Class Ordinal Binary (Nominal) Country of Nominal Residence String Scale Number of siblings/ Scale (Discrete) spouses Number of parents/ Scale (discrete) children on board Ticket number String Price of ticket Scale Cabin number String Where passenger String embarked Boat identification String (if rescued) Body number (if ID died) Home town Itring Gender Binary (Nominal) Ticket fare Cabin Embarked Boat Body Home.dest 5 Gender 0 = Male, 1=Female 3 3 You will create pivot tables on separate tabs which answer the following questions. Each question will require a pivottable The pivot tables will be clearly labeled both in the tab and within the charting the coding tab to reflect the question the correspond with you will 4 need to wwer the precise value in the highlighted cell as well. 5 6 01. How many American Mon survived the titanie? 7 # 02. What is the average age of people from Britain in first class to one decimal place? 9 10 03. How many women were in third class, not from the America or Britain and survived? 11 12 Of How many American Men died in the Titanic? How many British women died in the Titanic 13 14 15 Variable name pclass survived Value labels 1 =1", 2= 2nd, 3 = 3 0 = Died, 1 = Survived 0 = American, 1 = British, 2 = Other Residence Name age sibsp parch Variable label Data type Class Ordinal Binary (Nominal) Country of Nominal Residence String Scale Number of siblings/ Scale (Discrete) spouses Number of parents/ Scale (discrete) children on board Ticket number String Price of ticket Scale Cabin number String Where passenger String embarked Boat identification String (if rescued) Body number (if ID died) Home town Itring Gender Binary (Nominal) Ticket fare Cabin Embarked Boat Body Home.dest 5 Gender 0 = Male, 1=Female 3