I cannot thank you enough for doing this video! I had not the slightest clue how to use the Excel Spreadsheet for data analysis! This makes so much sense now! Thank you, thank you, thank you!
I'm doing qualitative analysis for a survey I created for my dissertation. I'm more comfortable with Excel than fancier software like NVivo and the way you explained things was super easy to understand. Thank you so much!
Thank you so much for the video. I was having difficulty doing the qualitative analysis through Nvivo. This method is best suited for my research and you explained it really well.
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++💥
Thanks for the video - can anyone explain to me how you would use a pivot table and then create a chart to explore matches against multiple themes? Taking the themes here as an example, how would would you plot on a graph incidences in which people who referred to 'space' also referred to 'food', or any other two themes here...
when you were finding the percentage per each theme in the pivot table, you could have anchored the calculation so you wouldn't have to manually change it.
I stumbled up on this video and found it very helpful. Is this part of a statistics course? Are you a professor? I'd like to learn more about analyzing qualitative data and the skills I need to develop in Excel. Thank you so much for this video!
These are filters, Keenan. If you stand on the row you want to use a filter to search in your data, go stand on this row, go to data, and click on filter (with a funnel picture on it). This will give you the ability to filter your data for the specific data you are looking for (e.g. names, numbers, terms, etc.)
Brilliant technique. Thanks. Is there a way by which I can see all the respondents comments under a theme? I have nearly 200 comments. When I present, I also need to put the quotes for various themes in my report. Is there a way to do this without hassle?
@kenclaassen7408 there are indeed better ways providing that you have access to more sophisticated (and often expensive) programs. This was an attempt to make this type of analysis more accessible and less frightening to people who may be new to it.
I cannot thank you enough for doing this video! I had not the slightest clue how to use the Excel Spreadsheet for data analysis! This makes so much sense now! Thank you, thank you, thank you!
Thanks so much. Quantifying responses with themes and counting them in excel. Straight to the point!!!
I'm doing qualitative analysis for a survey I created for my dissertation. I'm more comfortable with Excel than fancier software like NVivo and the way you explained things was super easy to understand. Thank you so much!
Thank you very much for this help, it is really brilliant! 'Opens Excel', straight back to the video for assistance.
Thank you so much for the video. I was having difficulty doing the qualitative analysis through Nvivo. This method is best suited for my research and you explained it really well.
Thanks Madam. You are a good teacher that can make anyone learn very easily from your video presentations.
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 SO MUCH for this video, it finally made thematic analysis click for me!
You are doing great job, it makes my analysis very easy
Thank you Trixie! This is very helpful!!
thank you this helped so much with visualizing how i should organize data in excel
you're a lifesaver! thank you so much
Thanks much for your lesson, really helpful...
I felt it was pretty spot on...you saved me a lot of time...Kudos to the good work..Cheers!!
Thanks!
This video is so helpful,, thank you so much
Thank you for teaching this tip.
Are these videos your own? Why did you stop making? It's helpful!!!! Like crazy.. Thank you so much.
Thanks for the video - can anyone explain to me how you would use a pivot table and then create a chart to explore matches against multiple themes? Taking the themes here as an example, how would would you plot on a graph incidences in which people who referred to 'space' also referred to 'food', or any other two themes here...
enjoy to watch your video
Very helpful. Thank you.
I wish I could give you 2 likes for this. Thank you so so much very helpful
Thank you for this helpful video.
thank you so much for making this example.
Great job, madam!
when you were finding the percentage per each theme in the pivot table, you could have anchored the calculation so you wouldn't have to manually change it.
I stumbled up on this video and found it very helpful. Is this part of a statistics course? Are you a professor? I'd like to learn more about analyzing qualitative data and the skills I need to develop in Excel. Thank you so much for this video!
Thank you!! very helpful!!
Thank you for sharing this video, very helpful!
Question - What are the drop down arrows seen in each cell of the first row indicating?
These are filters, Keenan. If you stand on the row you want to use a filter to search in your data, go stand on this row, go to data, and click on filter (with a funnel picture on it). This will give you the ability to filter your data for the specific data you are looking for (e.g. names, numbers, terms, etc.)
Thanks much for this video I am stats challenged and doing a qualitative research
Nice. I found this useful, may relate czcams.com/video/kdbJk_jzeHQ/video.html
Brilliant technique. Thanks. Is there a way by which I can see all the respondents comments under a theme? I have nearly 200 comments. When I present, I also need to put the quotes for various themes in my report. Is there a way to do this without hassle?
THANKING YOU FROM DAR ES SALAAM,
TANZANIA
great and informative
Thanks.
Lame! Why would you do this manually, there is surely a better way to do Qualatative analysis en masse
@kenclaassen7408 there are indeed better ways providing that you have access to more sophisticated (and often expensive) programs. This was an attempt to make this type of analysis more accessible and less frightening to people who may be new to it.