I'm looking to analyze survey answers I received (attached). It
is the essay type answers that need help.
There were four questions that asked about technology,
financing, monthly costs and one open-ended question. There is about 120
answers to each question and I'd like to get results summarized by the industry
that answered. For example...government employees hated technology, while
business owners loved it, and zoologists were neutral.
I'd also like to capture themes if they exist. Such as
the business owners who loved technology also said 3D printing was the
solution, while zoologists said technology might be OK, but the cost really
needs to come down first.
The answers aren't long (about 40 pages of reading
total), so I can just read them to do this, but learning a new software skill
would be great. I did get the main spreadsheet loaded just fine and the data is
there (just two columns, the industry and the answer). I did get #of answers by industry and the Wordcloud
to work, but the Wordcloud was a mess and didn't pull words from the answers, it just
plotted the answers.
So far, I must not have located the right video
tutorials. Perhaps someone can point me in the direction of a good one you have
for this concept (analyze essay answers)? I searched the questions here and found some answers, but they seemed tooo complex for this simple operation.
In the end visualization would be great as well, but
not essential. We are trying to communicate the info to people in the main
field, but who may not have knowledge in this subset of the field. Make sense?
Thanks in advance for your input.
Kelly