Creating a survey/quiz
Im trying to create a survey, but have no idea how to calculate the answers:
I've made a list of categories, however there is no definite answers to the questions e.g. It isn't multiple choice for example where I have given 5 possible answers and the person can only pick from these answers, it is left to the person's own opinion. Once I have a decent number of replies I can then sort out the most popular responses. The responses are in text form. Do I have to come up with some numbers that represent each response to a given question or can excel calculate text , finding certain words in answers for example or would Access be better for this type of thing |
Creating a survey/quiz
Use COUNTIF(). Use five cell which counts the number of responses to each
question =Countif(A1:A100,"Answer 1") =Countif(A1:A100,"Answer 2") =Countif(A1:A100,"Answer 3") =Countif(A1:A100,"Answer 4") =Countif(A1:A100,"Answer 5") "tic" wrote: Im trying to create a survey, but have no idea how to calculate the answers: I've made a list of categories, however there is no definite answers to the questions e.g. It isn't multiple choice for example where I have given 5 possible answers and the person can only pick from these answers, it is left to the person's own opinion. Once I have a decent number of replies I can then sort out the most popular responses. The responses are in text form. Do I have to come up with some numbers that represent each response to a given question or can excel calculate text , finding certain words in answers for example or would Access be better for this type of thing |
Creating a survey/quiz
"Joel" wrote: Use COUNTIF(). Use five cell which counts the number of responses to each question =Countif(A1:A100,"Answer 1") =Countif(A1:A100,"Answer 2") =Countif(A1:A100,"Answer 3") =Countif(A1:A100,"Answer 4") =Countif(A1:A100,"Answer 5") "tic" wrote: Im trying to create a survey, but have no idea how to calculate the answers: I've made a list of categories, however there is no definite answers to the questions e.g. It isn't multiple choice for example where I have given 5 possible answers and the person can only pick from these answers, it is left to the person's own opinion. Once I have a decent number of replies I can then sort out the most popular responses. The responses are in text form. Do I have to come up with some numbers that represent each response to a given question or can excel calculate text , finding certain words in answers for example or would Access be better for this type of thing Thanx I'll give it a try |
All times are GMT +1. The time now is 12:21 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com