title: correlate a demographic column with answers from multiple columns
body: <p>I have a spreadsheet from a Google Consumer Survey. The survey captured demographics as well as the responses to a question. Acceptable responses could have chosen zero or more 'answers'. The response for each answer is in a unique column. For example,</p>
  
  <hr>
  
  <p>user id | gender |  age  | income | answer 1 | answer 2 | answer 3 |</p>
  
  <hr>
  
  <p>0001    | Female | 20-30 | 50-75  | [empty]  |  Right   |  Never   |</p>
  
  <hr>
  
  <p>0002    | Male   | 20-30 | 30-50  |  Up      |  Left    |  [empty] |</p>
  
  <hr>
  
  <p>I would like to know how to correlate a column of demographic info with each of the possible answers. For example, I want to be able to answer questions like, <code>Were males more likely than females to choose X for answer 1?</code> and <code>Which age group was more likely to choose Y for answer 2?</code></p>
  
  <p>I prefer an answer using Google Sheets functions, but I am open to learning other ways to understand the data. Thank you for any help!</p>