View Single Post
  #16   Report Post  
Posted to microsoft.public.excel.programming
Hari Prasadh Hari Prasadh is offline
external usenet poster
 
Posts: 63
Default Genarating count of unique words in a cell or cells

Hi Myrna,

Just to give you an idea, I analyse MR data.

So if a question is asked -- "Please describe this product" -- and if one
respondent says "It's very Beautiful" and if another respondent says "It's a
thing of beauty".
For me end meaning of both the sentences is same. So, before loading to
SPSS( statistics software) I would assign a code ( numerical equivalent to a
particular verbal response) which is equal for both the responses. (I would
like to perform analysis starting from simple like how many rated product
being a beauty etc. to more complex depending on client requirements).

So, what I meant was to have a dictionary (in soft format having nouns
adjectives of every word) against which I could check and programmatically
manipulate the same. For me in this case (programming has been fine because
of Tim W's help) but now Iam on another barrier which is to get a list of
all words in let's say English language.

Please note the above question was just a sample, a respondent could use
multiple "adjectives" or "nouns" to describe the product. Like for Apple
I-pod they may say "It's a thing of beauty, very cool, so many options...."
etc.

Thanks a lot,
Hari
India

"Myrna Larson" wrote in message
...
if a word"beautiful" and "beauty" appears in the
target array, then for me both are one and the same


You may not have much company in that opinion. Beautiful is an adjective,
beauty is a noun. You can't take a sentence and that uses one of these
words
and replace it with the other and end up with something that is
gramatically
correct.