SOLVED

Two-Way Tables

Copper Contributor

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. 

1 Reply
best response confirmed by svaydtla (Copper Contributor)
Solution

@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 best response

Accepted Solutions
best response confirmed by svaydtla (Copper Contributor)
Solution

@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 

View solution in original post