data analysis on fields with words not numbers

R

Rebecca

How can I get the total number and percentage of for each different
word in a column which has several word descriptions? What function do
I use?
 
D

DaveB

Are they all single words per cell or is it more of a sentence per cell? If
they are just single words you can use this function:

Assume your range is A1:A100
=countif(A1:A100,"<word you want to search for>")/COUNTA(A1:A100)
 
R

Rebecca

DaveB

Well some are single but some are a short phrases or grouped words. I
will provide you with the 5 different kinds of word groups that can
appear in a column below. This is my dissertation and I greatly
appreciate your effort to help as this piece is over-my-head.

Rebecca

No Influence
Moderate Influence
Some Influence
Major Influence

Only a select few
No one knows
Only a select few

Homemaker/Housewife/Mother
Own Small Business
Student
Technology/Computers/Software
Civil Service/Municipal
Legal Field
Education/College/University
Health Care

"$50,001 - $60,000 "
"$20,001 - $30,000 "
"$40,001 - $50,000 "
"$40,001 - $50,000 "
"$60,001 - $70,000 "
"Less than $10,000 "
"$30,001 - $40,000 "

"Never married "
Co-habitating (live with lover/s)
Married legally
Other (please specify)
 
R

Rowan

Rebecca

Daves formula should work with phrases as well as single words. To make it
easier for you put the list of possible enteries in a range somewhere on the
sheet - say starting in C1. Then in D1 you can put the formula:

=COUNTIF($A$1:$A$100,C1)/COUNTA($A$1:$A$100)

Copy the formula down to the end of you list of possible entries.

Hope this helps
Rowan
 
Top