Jump to content

Word frequencies - one count per respondant

Guest Pete

Recommended Posts

Is there any way to run a word frequency count where I count only one instance of a word for every respondent?

I have imported my data from an excel file, with one column of free text responses.  I want to count how many participants have mentioned a word (whether they mention it once or many times), rather the total number of times the word has been mentioned.


Link to post
Share on other sites

Hello Pete,

It is possible to obtain that results you would like to have.

Let's say you would like to see how many times the word "water" has been used by your participants.

First, make a text search query for the word "water" and save your result as a node.

Then, perform a matrix query with your cases on the row and node for water is on the column. Provided matrix table will show you the frequencies of water in each respondent's content.

Hope this helps,



Link to post
Share on other sites
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...