Crosstabs for non-numeric value frequencies

[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

 

[Shane Devenshire]

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.

 

[David Schwartz]

You should use a pivot table

as I discussed in your last post.

Well, as I said, they seem to assume quantitative data. Is this not
true?

 

[Harlan Grove]

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.

....

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.