Analyzing text data?

  • Thread starter Thread starter cyko
  • Start date Start date
C

cyko

Thanks for the reply Jerry.

For example, to analyse the relationship between two of the 20
questions; like,

Of the respondents you replied 'Yes' to "Did you consider other
software before deciding to purchase 'XYZ Brand", the top three other
considerations were 1, 2, & 3.

That kind of thing. And, if possible adding a third question into the
mix. Such as - Of the respondents in this group who considered '1', the
dominant age group was 'X'.

Does that trigger any ideas on how it could be done?
 
You will generally get better results if you reply to messages (to keep
the tread together) instead of continuing a discussion in a new post.

SUMPRODUCT() is usually used to count based on multiple conditions. The
following counts the number of respondents that answered Yes to question
1 and answered either 1 or 2 to question 2.

=SUMPRODUCT( (q1Range="Yes") * ((q2Range=1)+(q2Range=2)) )

Use multiplication for "And" and addition for "Or"; parentheses may be
required to specify the desired meaning.

Jerry
 
Back
Top