Crosstabs for non-numeric value frequencies

  • Thread starter Thread starter David Schwartz
  • Start date Start date
D

David Schwartz

I've got some survey data in which respondents chose among different
text descriptors. I want to create a table where the frequency of the
different responses are tallied by a couple of different grouping
variables. Can I use a pivot table for this? They seem to assume
quantitative data.

Regardless of the answer to this question, can you provide a hint as
to the most straightforward method of creating the crosstab tables?



TIA,
David
 
Hi,

Excel has replaced the CrossTab tool with the Pivot Table tool, in fact they
did that in version 5 if my memory serves me. You should use a pivot table
as I discussed in your last post.
 
Shane Devenshire said:
Excel has replaced the CrossTab tool with the Pivot Table tool, in fact they
did that in version 5 if my memory serves me.  You should use a pivot table
as I discussed in your last post.
Click to expand...
....

OP mentioned pivot tables, and crosstabs are standard STATISTICAL
tools. See

http://en.wikipedia.org/wiki/Cross_tabulation

Better not to respond at all than to combine carelessness and
ignorance in the same response.
 
Back
Top