Part 2: Using Excel for Open-ended Question Data Analysis

[@carolynheine1305]

This video has been incredibly helpful! I have to code 800 free responses to a survey and several of those responses include multiple themes. I have no experience doing any kind of analysis and this has been a life saver!!! This video is succinct but detailed enough to demonstrate the topic adequately. You are an excellent instructor!

[@jacquelineclarke]

Thank you Carolyn. I'm really glad it was so helpful! Hope all goes well with your research

[@GUZUMERCY]

Very interesting knowledge, thank you

[@ranjinimalhotra7646]

Thank you so much, this was so very helpful for an assignment on qualitative analysis that had not been sufficiently explained!

[@HeavenWarner]

I just found your part 1 of this series last week and part 2 came just in time...thank you!

[@marcieee584]

This and part 1 were very helpful by the way; so so appreciated!!!

[@livairirali1940]

Since i do not know how to do coding and analysis for my research findings I left my research untouched until got your video. thanks very much

[@rajanvk939]

excellent this was exactly I was looking for analyzing the open-end questions. Thank You very much

[@jacquelineclarke]

Glad it was helpful!

[@SaminaAKhan-ck1oj]

Great video. Simple and precise explanations. Thank you 😊

[@johng5295]

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++💥

[@jacquelineclarke]

Glad it was helpful!

[@ratnafrentynurkhalim6068]

Great! It's very helpful! Thank you

[@jacquelineclarke]

Glad it was helpful!

[@abcdefghijkl5412]

Jacqueline, you're the best. Too many thanks. What about if the data is collected from a focus group discussion where you don't count the number of respondents? How do you analyse such data in MS Excel?

[@jacquelineclarke]

Bahati, for focus groups, we're not usually trying to report on the number of responses because you're using a small sample. Here are some resources that may be helpful: www.sagepub.com/sites/default/files/upm-binaries/11007_Chapter_7.pdf. www.cambridge.org/core/services/aop-cambridge-core/content/view/E5A028A3DA12A038A7D49566F73416B8/S0029665104000874a.pdf/focus-group-interview-and-data-analysis.pdf

[@abcdefghijkl5412]

@@jacquelineclarke received with thanks

[@eltonhammond4823]

Awesome video, thanks!

[@neonskuller]

Thank you that was of a big help!

[@jacquelineclarke]

You're welcome! Glad it was useful

[@ShriramKoushik]

really proved to be useful thanks for the video

[@alkimistish]

Thank you, it helps me a lot!!! Just one question- do you have some reference (article, authors, or which theory model) to cite while using this technique? Based on which theory is based this? (just to proper cite it). Thank you, thank you.

[@jacquelineclarke]

Alkimistish, I don't have a specific reference but this type of analysis is referred to as Descriptive Analysis. Searching for this term will help you to find a source that works best for you.

[@alkimistish]

Thank you for yours replay. :)

[@anisfarhah1481]

Thank you!!

[@OrChanthachak]

this helps me a lot

[@aquatikcamel4034]

Hi! This is a very easy video to follow along and understand, but I had a question. Suppose I want to compare the responses according to the gender or maybe different age groups, how would I go about that? Thank you in advance 🔥👍

[@jacquelineclarke]

Hi, you could use a pivot table in Excel to do this. Sorry, I don't have a video for pivot tables but there are lots available on KZbin

[@aquatikcamel4034]

@@jacquelineclarke Thank you for responding Jacqueline 👍

[@edebedeb462]

Thank you so much , it was ver helpful

[@samanthacole8342]

Hi. How do calculate Mean and Standard Deviation using this same example?

[@jacquelineclarke]

For standard deviation you can use this formula support.microsoft.com/en-au/office/stdev-function-51fecaaa-231e-4bbb-9230-33650a72c9b0

[@jacquelineclarke]

For Mean you can use this formula support.microsoft.com/en-gb/office/average-function-047bac88-d466-426c-a32b-8f33eb960cf6

[@lovejoseph1899]

Is it relevant to include my spreadsheet in my thesis?

[@jacquelineclarke]

I would ask your adviser. They should have a better idea of what's expected/the norm for your department

[@liliadali6734]

Hello Jacqueline, Could you please tell me which version of Excel did use for the analysis. I use Excel 2007, and when it comes to do the frequency operation using the "COUNTIF" function, Excel opens an error message.

[@jacquelineclarke]

Lilian, I think COUNTIF is available in all versions of Excel, I just tried it in the online version and it worked. Here's a resource that may be helpful support.office.com/en-us/article/COUNTIF-function-e0de10c6-f885-4e71-abb4-1f464816df34

[@liliadali6734]

Hi again, I fixed the problem thanks to you Jacqueline. The link you sent me was very helpful, and I watched again your tutorial, which helped me have a better idea about the issue. Thank you sooooooooooooo much for your time and for your help. God bless you ^_^

[@sumaiyaafrin9645]

Hello. Thank You for your video. It is really helpful. Can you kindly tell me what is the name of this kind of analysis? Can this be called content analysis? I have a paper submission due next week. I want to follow this method of analysis but, need an exact name of this process to mention in the analysis part that what kind of analysis I did. I'd really appreciate an answer. Thanks in Advance.

[@jacquelineclarke]

This type of analysis is referred to as descriptive analysis. You can find more information here: www.socialresearchmethods.net/kb/statdesc.htm

[@sumaiyaafrin9645]

Thank You so much for your reply. I really appreciate it. Thanks a lot.

[@marcieee584]

What if we want to break the data even further by geographical location? Let's say that an earlier multiple choice question in the survey was "what dorm are you living in"

[@jacquelineclarke]

The responses to the question "what dorm are you living in" would be entered in the Data tab. After coding the answers to the open-ended question, I would add this as a new column in the Data tab. Then I would use a pivot table to cross tabulate the responses from the two questions. I do not have a pivot table video but perhaps this one may be helpful kzbin.info/www/bejne/ppaxhaNrm9p-fMk

[@NezukoKamado-vl4io]

I have a question why did you numbered the responses to 1-15? You are analyzing number 6? Thank you for a great video. I am new in learning research and my professor ask us to analyze an open-ended question and I am a little confused.

[@jacquelineclarke]

Nikka Rose, the first step in data analysis is writing a number on the completed questionnaires you have collected from respondents. In this demonstration, there were 15 completed questionnaires. When you enter the data in the spreadsheet, you enter the number of the questionnaire and then you enter the answer to Question 6 from that questionnaire. We do this so that if there is an error with the data entry or if we want to check that the data entry is accurate, we can compare the spreadsheet with the actual questionnaires.

[@NezukoKamado-vl4io]

Thank you for replying. I am a student and a beginner in learning research. Our professor ask us to construct a survey and interpret it. I am searching for references to help me in analyzing my data and I happened to stumbled upon your video. It is very informative. Thanks a lot Ma'am!

[@jacquelineclarke]

I'm glad you found it helpful. Part 1 of the video is available here kzbin.info/www/bejne/r4iliYlsapasmpY

[@ny7260]

hi..if the respondents leave it blank or just write 'none'/'no comment', do we need to add another code for it?

[@jacquelineclarke]

No, you don't need to add a code for "none/no comment"

[@raindropsofsky]

What is the purpose of adddingg dollar signs to the cell?

[@jacquelineclarke]

Here is a tutorial that I think will answer your query. www.ablebits.com/office-addins-blog/2015/11/25/relative-absolute-reference-excel/

[@shakshikataria8921]

Why your number of entertainment divided by total is different like it's 3 but when you click it is showing 16 !!! And in my laptop, this formula of calculating frequency is not working it's showing error or #name.

[@jacquelineclarke]

What you're seeing in video is not the number 16. You're seeing i6 (I6). Because I used the "=", I am asking Excel to take the contents from i6 and use it for this new cell. The contents in i6 is "3" so when I hit "enter" Excel obeys the command and displays the contents of i6. I'm not sure why the formula is not working. Here is the Microsoft Office support page for this formula support.office.com/en-us/article/countif-function-e0de10c6-f885-4e71-abb4-1f464816df34

[@shakshikataria8921]

@@jacquelineclarke hey thanks your video is very helpful

[@cleaneat_shealthyrecipes5701]

thank you

[@shravangattu5783]

🙏

[@jacquelineclarke]

You're welcome!