Very useful, short, precise and gives the answers to qualitative analysis right away without a person having to go through all the literature. Amazing!
Very useful, easy and quick process to analyse open-ended questions, even for beginners in Excel. I am really thankful to this video because I am a beginner in Excel and doing calculation for the first time. This video helped me in analysing datas of the researh questions in short time. Please keep uploading other videos regarding data analysis. Thank you! :)
Part 1 and Part of your videos are absolutely fantastic. I have been searching over the last couple of days for SIMPLE easy ways to teach my students to analyse survey responses. I am so, so glad for your 2 videos.
I cannot thank you enough. I pray that my teaching will improve to reflect the clarity, patience, care. I learnt the outcomes and much more. You are an amazing teacher. Best wishes.
Thanks Jacqueline this is giving so much help to my thesis. I was searching for here and there to find the easier way to count the open-ended questionnaire as the students gave various responses to my questionnaire. This video is easy to understand :)
OMGGG... Jacqueline; you just made my life easy... amazingggggggggggggggg girl... that's so easy and without any technical software or so.. thanks a bunch
Dear Jacqueline, Thank you so much for sharing your class course work on u-tube! I am writing up the results section of my dissertation, I analysed the questionnaire data through SPSS which was fine as we had been taught how to use this as part of our course. However, I had two open-ended questions which also needed analysed, I down loaded Nvivo on to my computer and spent a couple hours looking at the tutorials and lost the will to live! I decided to search on Google "how to analyse open-ended questions" and to my great relieve your tutorial came up 5th or 6th on the first page! Excellent tutorial, at just the right speed to take it in, no fuss, straight forward and a lovely accent/voice to go with it! Thank you so much! My tutor loves my graphes! :)
Thank you sooooo much Jacqueline for this video. It really helped me to correctly interprete open-ended questions for a questionnaire I gave to my students some time ago. God bless you ^_^
1. The tutorials are part of a 3rd-year course on research concepts in a 4-year degree program. 2. Since we are looking for themes related to how the students feel rather than what action will be required, my preference would be to focus on themes that capture student feelings rather than actions that could be taken to address shortcomings. 3. The main determining factor when deciding on whether to include an open-ended question is: will the responses help to address the purpose/goal of the survey? A secondary determining factor is: does the researcher have the resources to analyze the results? For a survey with thousands of responses, the surveyor could use qualitative research software for the data analysis. Several options are available.
I haven't had to use qualitative software for the course I teach. Here's a possible place to start to find one that would work for you blog.hubspot.com/service/qualitative-data-analysis-software
Thanks in a million. Great content. Awesome. Very well explained. I couldn't find this explanation--simply put anywhere else. Great teachers are hard to find. Grade: A++💥
Thank you. It's my first time doing analysis of open-ended/codable fields. This is rough when you have hundreds of responses to go through as you have to assess yourself. You think there may be some way to use the find and replace function and the wildcards *?~ to speed up coding the data like you did?
+kaseybutternut Possibly. I haven't tried that approach. Here's a link to using wildcards with the IF function that may be helpful. answers.microsoft.com/en-us/office/forum/officeversion_other-excel/wild-card-characters-in-if-formula/8d882e94-7c44-436e-86d7-8748cd398ff8?auth=1
Thanks for clarifying my thoughts. Because I work with large qualitative data from open-ended questions. Most of the time, the responses are more than the number of participants so I have been wondering if the results will be accepted if the frequency of responses is more than the reported number of participants. That does not matter after watching the video once the total percentages is 100!
My question then is, do you then say percentage of responses or percentage of respondents knowing the counts (or responses) are more than the participants? In part 1, I see it more of percentage of respondents and part two, percentage of responses. Please clarify
Jacob, if there is question for which you have multiple responses from participants, then I would refer to the "responses" when reporting the results of that question. For a question in which each participant has only one response, I would refer to "respondents" when reporting the results of that question.
@@jacquelineclarke Many thanks! If you use responses where there are multiple responses, is it okay if you have total responses more than the number of participants in the study? I get a bit uncomfortable seeing responses more than the participants even though the percentage is 100 anyway.
Yes, it's ok. But when you are reporting the findings in a situation in which there are more responses than respondents then you definitely want to refer to "responses" rather than participants. Also, when reporting my findings, I would usually avoid referring to the number of responses or participants since this is not as useful as reporting on percentage of responses or percentage of participants. If you use the number, e.g. 15 respondents said xxxx, it's harder for your reader to interpret your findings because they have to constantly remember what the total number of respondents to your survey was.
I love this video - thanks for posting. I just didn't understand where you got the 111 number and the 16 number from when you were working out the percentage of the Entertainment theme.
Those aren't numbers. They are the cell addresses - i16 and i10. Instead of typing in the numbers, I am using the cell address to create the formula. This means that if the content in the source cell changes (i16 or i10), the result (percentage in this case) is automatically updated. Here's some info from MS that may be helpful support.microsoft.com/en-us/office/use-cell-references-in-a-formula-fe137a0d-1c39-4d6e-a9e0-e5ca61fcba03
Also, I feel as though "bigger student lounge" and "more computer labs" could have been in their own category to do with changes to building/construction
Great video! How do you find frequency and proportion if there are multiple codes per response? For example if one response involved live music and transportation the codes would be "e" and "t". How do you deal with this?
Good question. The numbering system refers to the questionnaires rather than the responses and is used for back checking purposes, i.e. if for some reason you need to check that the responses have been entered correctly, you can go back and check the entered response against the appropriate questionnaire (each questionnaire should be numbered). But the numbers are not relevant for calculating frequency and proportion. In a case where there are two responses on a questionnaire, insert a row under the appropriate questionnaire number and enter the additional response (so you know which questionnaire the response is related to). Tally the total number of responses - in this case it would be 16 instead of 15. Report the proportion as a percentage of the total number of responses. To check that the totals are correct, I would add a tally of the number of responses in Column D.
Thank you for showing this, I have been looking for it! Unfortunately, I have a large number of responses so placing a code on each response would take a lot of time, do you have a tip for it?
Sorry for three comments in a row, but also, what if the survey had brought in thousands of responses to an open-ended question and there isn't time to go through all of them and categorise them? Or is it that an open-ended question wouldn't be included in a survey intended to bring in a high number of responses?
Thank you for the feedback, Hamdi. The video zooms in from the 2:50 min mark and onwards. If you're able to see this view clearly, you may wish to change the video settings to 720p (if not already selected) - click on the gear at the bottom of the screen, choose Quality, select 720p.
Is there a quicker way to identify common themes when the sample size is larger...? I have 181 responses all captured and in excel already. Do I have to go through and theme every response or is there a way to do it faster?
Hi Robyn. Sorry about the delay in getting back to you. I'm not aware of a way to do it faster in Excel. That's the challenge with open-ended questions. Respondents can write anything down. We have to use our interpretation to categorize them into themes that make sense for our research.
I understand that this is a descriptive analysis of qualitative data. Is there a book we can refer to when describing the method that you show in this video? Many thanks for the video - it makes analysis easier to understand and do!
E Carson, most research textbooks will explain how to analyze qualitative research (look for themes, etc.). I am not aware of a textbook that walks you through the steps for using Excel to analyze qualitative research.
Thank you for taking time to answer. I have 2 follow-up questions: (1) Who would you recommend as closest to your methodology: Glaser & Strauss (The Discovery of Grounded Theory, 1967), Strauss & Corbin (Basics of Qualitative Research, 1990), or Creswell, Qualitative Enquiry & Research (2nd ed), 2007, or someone else? Keeping in mind that they did not show how to do this in Excel! (2) Is it ok to cite your video? If so, what citation would be best? Thanks!
I'm not familiar with those sources so can't say which is the closest. Yes, you can cite the video. www.easybib.com/guides/citation-guides/apa-format/youtube-video/
Just to add my two cents. It appears Glaser & Strauss is closest in terms of the methodology. This excel method allows the researcher to move from data to theory so new theories or themes as it were can emerge which primarily is the basis for their grounded theory argument. Themes are grounded in the theories they emerged from.
Hi Jacqueline Thank you for this video. Its really helpful while interpreting data having open-ended questionnaires. I've writing theses for my degree in sociology and want to use this method but I'm required to cite ' the method, I'm using with regards to data analysis'. Is this your own method of analysis data or you adopted from some else where. If this is yours, then please help me cite this in my research or if it isn't then mention the source so that I could cite. Await your response! Thank you
Hi Saquib, the statistical method is referred to as Descriptive Analysis. I think the closest to data analysis method may be grounded theory: www.sxf.uevora.pt/wp-content/uploads/2013/03/Glaser_1967.pdf
Hello there Jacqueline. Got a question for you: Is there to do the whole questions in one only sheet, instead of one question per sheet? You are a START! Thanks for posting this, as I think you are being super useful in my masters degree on data analytics, as I need to do a final results on opened questions and I am taking your full advise, as you are doing it on your tutorial. I have 28 questions to do, and doing one by one, I think it is a killer task, and I was wondering if there is anything that could make it all in one go... Let me know, and thanks a million for posting this !!! Dan xx (I have also subscribed)
Hello Dan, Sorry for the delay in getting back to you. You could do more than one question on a worksheet. I just find it easier to navigate/find if I do one question per worksheet. Once you start writing up your results, you want to be able to go back forth between questions as quickly as possible.
@@jacquelineclarke Thanks Jacqueline for your reply. Don't worry for the delay... Things happen.... I hope I can manage when I reach my 3r question on the master's. Many thanks for posting that!! Dan xx
Hi. I have a question though. What if there were answers that belong to two (or more) themes? Example, one student answered "more parking and free food". Should I just choose to put it on one theme or should I make another theme that perhaps says "Food & Transportation". Thank you!!
Hi Jacqueline, kindly advise what to do in the situation the open ended question has a long answer touching multiple themes? what is the optimal way to present that information?
+h3ll022 It depends on your research study. I would "break" the answer and apply each part of the answer to theme that it applies to. I would then count each "break" as a separate response. In this case, it is more important to me to capture the actual responses rather than the number of responses (how many people responded to the survey). If it is more important to your research study that you capture the number of responses, then you have to choose which theme to apply the answer to. You could only use the first part of the response using the logic that this seems to be the most important aspect for the responder since this is the first thing he/she wrote.
Very useful, short, precise and gives the answers to qualitative analysis right away without a person having to go through all the literature. Amazing!
Didn't know it was this easy to analyse open ended questions on excel. Now i can explain better in my analysis. Thanks for this excellent video
girl you saved my life istg...
This was the most easiest way someone has explained bar charts.
Keep going.You're doing amazing
Thank you! Will do!
Thank you. I barely finished watching the video and I knew how to start my analysis. this really helped me.
Extremely helpful, easy to understand and precise. Thank you very much!
Very useful, easy and quick process to analyse open-ended questions, even for beginners in Excel. I am really thankful to this video because I am a beginner in Excel and doing calculation for the first time. This video helped me in analysing datas of the researh questions in short time. Please keep uploading other videos regarding data analysis. Thank you! :)
Part 1 and Part of your videos are absolutely fantastic. I have been searching over the last couple of days for SIMPLE easy ways to teach my students to analyse survey responses. I am so, so glad for your 2 videos.
Glad it was helpful!
I cannot thank you enough. I pray that my teaching will improve to reflect the clarity, patience, care. I learnt the outcomes and much more. You are an amazing teacher. Best wishes.
You are so welcome
Very nicely presented, awesome! Thanks Jackqueline.
Thanks Jacqueline this is giving so much help to my thesis. I was searching for here and there to find the easier way to count the open-ended questionnaire as the students gave various responses to my questionnaire. This video is easy to understand :)
I'm glad to hear that the video is useful. Good luck on your thesis!
It is very very useful for me. You saved my terrible life. Thank you so much
OMGGG... Jacqueline; you just made my life easy... amazingggggggggggggggg girl... that's so easy and without any technical software or so.. thanks a bunch
You're welcome! Glad it was useful!
That was comprehensible. Good job!
Awesome, preciate this much....finally done with my dissertation. Thanks tikhe
She made it so easy unlike other videos
This was extremely helpful, thank you
Excellent presentation and extremely useful - Many Thanks!
Dear Jacqueline,
Thank you so much for sharing your class course work on u-tube!
I am writing up the results section of my dissertation, I analysed the questionnaire data through SPSS which was fine as we had been taught how to use this as part of our course. However, I had two open-ended questions which also needed analysed, I down loaded Nvivo on to my computer and spent a couple hours looking at the tutorials and lost the will to live! I decided to search on Google "how to analyse open-ended questions" and to my great relieve your tutorial came up 5th or 6th on the first page! Excellent tutorial, at just the right speed to take it in, no fuss, straight forward and a lovely accent/voice to go with it! Thank you so much! My tutor loves my graphes! :)
Penelope MacLellan Hawkes Great to hear that the video was helpful. Thank you. Good luck with your dissertation!
Thank you for this video! I've used it as a reference for grad school when doing my descriptive analysis and for my job. Excellent video!!
Glad it was helpful!
Been searching for a tutorial like this for days. Thank you.
Glad I could help!
This has been extremely helpful thank you !!
This saved my life and my time. You did way better than my prof at Grad school. Thank you
You're welcome!
Thanks so much..easy to follow and precise!
Thank you for sharing this important video,its real helpfull
Very useful, short and precise video
this is so helpful, thanks Jacqueline
Thank you sooooo much Jacqueline for this video. It really helped me to correctly interprete open-ended questions for a questionnaire I gave to my students some time ago.
God bless you ^_^
You're welcome. So glad you found it useful
Thanks for the video.... now i can analyze my data
Thank you very much! This has helped me a lot.
This is amazing. Thank you!
Extremely helpful, easy to understand. Thank you so much!
Glad it was helpful!
thanks a lot for uploading this video!!
Thanks a lot! This would greatly help me for my assignment.
So detailed! Very useful!! Thank you so much!!
Glad it was helpful!
1. The tutorials are part of a 3rd-year course on research concepts in a 4-year degree program. 2. Since we are looking for themes related to how the students feel rather than what action will be required, my preference would be to focus on themes that capture student feelings rather than actions that could be taken to address shortcomings. 3. The main determining factor when deciding on whether to include an open-ended question is: will the responses help to address the purpose/goal of the survey? A secondary determining factor is: does the researcher have the resources to analyze the results? For a survey with thousands of responses, the surveyor could use qualitative research software for the data analysis. Several options are available.
Thanks, very useful! But what if you have 1,000 rows to analyze? @Jacqueline C
I would use a qualitative research software application rather than Excel.
@@jacquelineclarke what is the name of the software? I hope you have time to make tutorial. Thanks in advance
Hi.. can i ask what is the exact term for this technique?? Is it content analysis but quantitative.
I haven't had to use qualitative software for the course I teach. Here's a possible place to start to find one that would work for you blog.hubspot.com/service/qualitative-data-analysis-software
This tutorial is so good. I am lucky to find this one!
Glad it was helpful!
Great... easy to understand for a common human
Awesome! ^^ Thank You for this Video
never mind i read the previous responses thank u
this was sooooooooo helpful. thanks!
Thanks in a million. Great content. Awesome. Very well explained. I couldn't find this explanation--simply put anywhere else. Great teachers are hard to find. Grade: A++💥
Glad it was helpful!
Thank you! It's very useful.
Very helpful and easy to understand, thank you!
Glad it was helpful!
Hmmm, so simplified and interesting!!! Thanks 👍🏾
Glad you liked it!
Thank you excellent presentation !!!
Glad you liked it!
save the day. awesome presentation. tks a lot.
Glad it helped!
thanks so much! great help
very helpful. thanks
Very helpful. Thank you.
You're welcome!
You helped me a lot.Thanks
Happy to help
Thank you so much!
Thanks. This was very helpful
I'm glad it was helpful!
Very good tutorial
Excellent Madam. I loved it..............
Thank you!
This was really helpful. Thank you.
Very helpful, thanks
Glad it was helpful!
Thank you. It's my first time doing analysis of open-ended/codable fields. This is rough when you have hundreds of responses to go through as you have to assess yourself. You think there may be some way to use the find and replace function and the wildcards *?~ to speed up coding the data like you did?
+kaseybutternut Possibly. I haven't tried that approach. Here's a link to using wildcards with the IF function that may be helpful. answers.microsoft.com/en-us/office/forum/officeversion_other-excel/wild-card-characters-in-if-formula/8d882e94-7c44-436e-86d7-8748cd398ff8?auth=1
Thanks a Million!
You do all Jacqueline, you saved me
Very helpful
Great thanks🤗
My pleasure 😊
Great tutorials
Glad you like them!
Thanks its helpful for me
Glad to hear that
very useful thank you so much
You are most welcome
Very informative
Question: are these tutorials based on Data Analysis as a course for a specific qualification? Or just the concept in general?
Thank you so much.
You're welcome!
Wow really helpful 👍 thanks a lot mam ☺️
Most welcome 😊
Amazing. Thank you
You're welcome, Lyndsey!
Well, grateful!
Thank you very much
You are welcome
Thank you :)
Thanks for clarifying my thoughts. Because I work with large qualitative data from open-ended questions. Most of the time, the responses are more than the number of participants so I have been wondering if the results will be accepted if the frequency of responses is more than the reported number of participants. That does not matter after watching the video once the total percentages is 100!
My question then is, do you then say percentage of responses or percentage of respondents knowing the counts (or responses) are more than the participants? In part 1, I see it more of percentage of respondents and part two, percentage of responses. Please clarify
Jacob, if there is question for which you have multiple responses from participants, then I would refer to the "responses" when reporting the results of that question. For a question in which each participant has only one response, I would refer to "respondents" when reporting the results of that question.
@@jacquelineclarke Many thanks! If you use responses where there are multiple responses, is it okay if you have total responses more than the number of participants in the study? I get a bit uncomfortable seeing responses more than the participants even though the percentage is 100 anyway.
Yes, it's ok.
But when you are reporting the findings in a situation in which there are more responses than respondents then you definitely want to refer to "responses" rather than participants.
Also, when reporting my findings, I would usually avoid referring to the number of responses or participants since this is not as useful as reporting on percentage of responses or percentage of participants. If you use the number, e.g. 15 respondents said xxxx, it's harder for your reader to interpret your findings because they have to constantly remember what the total number of respondents to your survey was.
Thank you so much
You're most welcome!
This is great and your explanation is very clear and concise. Does this analysis tool approach have a name?
This is descriptive analysis
Thank you!!!!
You're welcome!
interesting presentation
Glad you liked it
I love this video - thanks for posting. I just didn't understand where you got the 111 number and the 16 number from when you were working out the percentage of the Entertainment theme.
Those aren't numbers. They are the cell addresses - i16 and i10. Instead of typing in the numbers, I am using the cell address to create the formula. This means that if the content in the source cell changes (i16 or i10), the result (percentage in this case) is automatically updated. Here's some info from MS that may be helpful support.microsoft.com/en-us/office/use-cell-references-in-a-formula-fe137a0d-1c39-4d6e-a9e0-e5ca61fcba03
@@jacquelineclarke Thanks very much for the explanation. Much appreciated.
thanks a million,
You're welcome! Glad it was useful!
Also, I feel as though "bigger student lounge" and "more computer labs" could have been in their own category to do with changes to building/construction
Great video! How do you find frequency and proportion if there are multiple codes per response? For example if one response involved live music and transportation the codes would be "e" and "t". How do you deal with this?
Good question. The numbering system refers to the questionnaires rather than the responses and is used for back checking purposes, i.e. if for some reason you need to check that the responses have been entered correctly, you can go back and check the entered response against the appropriate questionnaire (each questionnaire should be numbered). But the numbers are not relevant for calculating frequency and proportion.
In a case where there are two responses on a questionnaire, insert a row under the appropriate questionnaire number and enter the additional response (so you know which questionnaire the response is related to). Tally the total number of responses - in this case it would be 16 instead of 15. Report the proportion as a percentage of the total number of responses. To check that the totals are correct, I would add a tally of the number of responses in Column D.
Can you please upload a video on how did you handle question 3
Thank you for showing this, I have been looking for it! Unfortunately, I have a large number of responses so placing a code on each response would take a lot of time, do you have a tip for it?
Using Excel's verbatim feature may be helpful. Here's some tips on how to use this function measuringu.com/code-verbatim/
Sorry for three comments in a row, but also, what if the survey had brought in thousands of responses to an open-ended question and there isn't time to go through all of them and categorise them? Or is it that an open-ended question wouldn't be included in a survey intended to bring in a high number of responses?
Thanks for this. What if you have multiple codes per response? e.g. student wants a lounge with food services - code would be both F and E.
Thanks
Part 2 of the tutorial shows how to address multiple response. ruclips.net/video/J_whxIVjNiY/видео.html
It's very helpful but please zoom little so we can see what you write in details thank you
Thank you for the feedback, Hamdi. The video zooms in from the 2:50 min mark and onwards. If you're able to see this view clearly, you may wish to change the video settings to 720p (if not already selected) - click on the gear at the bottom of the screen, choose Quality, select 720p.
I have a question please, what do you do when you have multiple themes in one quote??
@Marouan, the Part 2 video addresses this ruclips.net/video/J_whxIVjNiY/видео.html&lc=UgzZaWvkJ1aF3am2kPR4AaABAg
Thank you...can you please suggest about how to do analysis of an inventory in excel?
I haven't used excel for this purpose. Here's a website that might be helpful! chandoo.org/wp/abc-inventory-analysis-using-excel/
Hi Jacqueline, could you please share with me the other parts. Thank you very much for the lecture.
Here you go ruclips.net/video/J_whxIVjNiY/видео.html&lc=Ugyow5pR9iG3m8h877B4AaABAg
Is there a quicker way to identify common themes when the sample size is larger...? I have 181 responses all captured and in excel already. Do I have to go through and theme every response or is there a way to do it faster?
Hi Robyn. Sorry about the delay in getting back to you. I'm not aware of a way to do it faster in Excel. That's the challenge with open-ended questions. Respondents can write anything down. We have to use our interpretation to categorize them into themes that make sense for our research.
Thank you. Yes I went through and tagged them all individually.
I understand that this is a descriptive analysis of qualitative data. Is there a book we can refer to when describing the method that you show in this video? Many thanks for the video - it makes analysis easier to understand and do!
E Carson, most research textbooks will explain how to analyze qualitative research (look for themes, etc.). I am not aware of a textbook that walks you through the steps for using Excel to analyze qualitative research.
Thank you for taking time to answer. I have 2 follow-up questions:
(1) Who would you recommend as closest to your methodology: Glaser & Strauss (The Discovery of Grounded Theory, 1967), Strauss & Corbin (Basics of Qualitative Research, 1990), or Creswell, Qualitative Enquiry & Research (2nd ed), 2007, or someone else? Keeping in mind that they did not show how to do this in Excel!
(2) Is it ok to cite your video? If so, what citation would be best? Thanks!
I'm not familiar with those sources so can't say which is the closest.
Yes, you can cite the video. www.easybib.com/guides/citation-guides/apa-format/youtube-video/
Just to add my two cents. It appears Glaser & Strauss is closest in terms of the methodology. This excel method allows the researcher to move from data to theory so new theories or themes as it were can emerge which primarily is the basis for their grounded theory argument. Themes are grounded in the theories they emerged from.
Hi Jacqueline
Thank you for this video. Its really helpful while interpreting data having open-ended questionnaires. I've writing theses for my degree in sociology and want to use this method but I'm required to cite ' the method, I'm using with regards to data analysis'. Is this your own method of analysis data or you adopted from some else where. If this is yours, then please help me cite this in my research or if it isn't then mention the source so that I could cite. Await your response! Thank you
Hi Saquib, the statistical method is referred to as Descriptive Analysis. I think the closest to data analysis method may be grounded theory: www.sxf.uevora.pt/wp-content/uploads/2013/03/Glaser_1967.pdf
Hello there Jacqueline.
Got a question for you: Is there to do the whole questions in one only sheet, instead of one question per sheet?
You are a START! Thanks for posting this, as I think you are being super useful in my masters degree on data analytics, as I need to do a final results on opened questions and I am taking your full advise, as you are doing it on your tutorial. I have 28 questions to do, and doing one by one, I think it is a killer task, and I was wondering if there is anything that could make it all in one go...
Let me know, and thanks a million for posting this !!!
Dan
xx
(I have also subscribed)
Hello Dan,
Sorry for the delay in getting back to you. You could do more than one question on a worksheet. I just find it easier to navigate/find if I do one question per worksheet. Once you start writing up your results, you want to be able to go back forth between questions as quickly as possible.
@@jacquelineclarke Thanks Jacqueline for your reply. Don't worry for the delay... Things happen.... I hope I can manage when I reach my 3r question on the master's. Many thanks for posting that!! Dan xx
Hi. I have a question though. What if there were answers that belong to two (or more) themes? Example, one student answered "more parking and free food". Should I just choose to put it on one theme or should I make another theme that perhaps says "Food & Transportation".
Thank you!!
Hi Regeil, see Part 2 for the answer to your question: ruclips.net/video/J_whxIVjNiY/видео.html&lc=Ugyow5pR9iG3m8h877B4AaABAg
How to do coding if I get two different responses from same person ?
Please see Part 2 of the tutorial ruclips.net/video/J_whxIVjNiY/видео.html
thank u very much. please teacher we need other tutorial if there is more than one responses .
Mohammed, here is the video for more than one response. ruclips.net/video/J_whxIVjNiY/видео.html
thanks teacher.
It is really help full.
Can I also make it in Excel 2016? Every version should be serve as convenient for data analyssisss.
Yes, you can also do these steps in Excel 2016
Hi Jacqueline, kindly advise what to do in the situation the open ended question has a long answer touching multiple themes? what is the optimal way to present that information?
+h3ll022 It depends on your research study. I would "break" the answer and apply each part of the answer to theme that it applies to. I would then count each "break" as a separate response. In this case, it is more important to me to capture the actual responses rather than the number of responses (how many people responded to the survey). If it is more important to your research study that you capture the number of responses, then you have to choose which theme to apply the answer to. You could only use the first part of the response using the logic that this seems to be the most important aspect for the responder since this is the first thing he/she wrote.
+Jacqueline Clarke tq!!!
Hi, can ask what is the exact term of this technique??
This is referred to as descriptive analysis
What if the same respondent had more than one response (mention two or more points)?
Part 2 of the tutorial shows how to address multiple response. ruclips.net/video/J_whxIVjNiY/видео.html
brilliant tutorial thank you (maybe avoid wearing ?bracelet as noise picked up by microphone) :)
Thanks for the suggestion :)