Analyze Text from Survey Answers
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.