Analyzing text data?

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?
 
J

Jerry W. Lewis

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
 
Top