Forum Discussion
Two-Way Tables
Would like to know how to generate a two-way table to display: Count of students by Gender and Origin
Excel spreadsheet attached for reference.
svaydtla not sure what exactly you want but in the attached I created 2 total columns. 1 for all unique Gender and 1 for all unique Origins and then countif for each. But the easier way that also give a full table of every combination is to do a pivot table of this information. Also in the attached and done using these steps:
a) highlighted those 2 columns
b) selected Insert pivot table and selected cell where to put it
c) dragged gender and origin to rows and columns boxes and then origin (or gender) to the Values box
d) right click on pivot table and selected Pivot Table Options and clicked tab for totals and selected to show Grand totals for rows and columns
1 Reply
svaydtla not sure what exactly you want but in the attached I created 2 total columns. 1 for all unique Gender and 1 for all unique Origins and then countif for each. But the easier way that also give a full table of every combination is to do a pivot table of this information. Also in the attached and done using these steps:
a) highlighted those 2 columns
b) selected Insert pivot table and selected cell where to put it
c) dragged gender and origin to rows and columns boxes and then origin (or gender) to the Values box
d) right click on pivot table and selected Pivot Table Options and clicked tab for totals and selected to show Grand totals for rows and columns