READ THIS!! If you replicate the Excel file the way he does in the video, you simply need to insert (copy and paste) these formulas in these cells to make it work: (1) in Cell E2 --> =A1, (2) in Cell E4 --> =UNIQUE(B2:B8), (3) in Cell G4 --> =COUNTIF(B2:B8,E4), and (4) in Cell H4 --> =COUNTIF($B$2:$B$8,E4)/COUNTA($B$2:$B$23). You can modify the Excel file later to suit your own needs without messing up the formulas. In other words, if you add columns, the formulas will adjust accordingly. Good luck!
Well, this is just cruel. I got so excited about this beautiful template, but can't seem to access it anywhere. Please oh please Mr. One Year Dissertation - let us know where we can get this? It would save me so much time. 😩
What if someone lists multiple things in one response e.g. in your last example, what if one respondent had said "atmosphere and blue glass"? Do you then tally 1 point in each category? Is that not then duplicating the weight of that respondents opinion?
i have used 2 approaches (depending on study objectives, and typically budget) - only count the first mentioned 'thing', as typically people list the most significant 'thing' first. or if objective/budget allow, count both/all as separate entries, sometimes allocating less of a point to things mentioned later
how to make this table in a spreadsheet?
Thanks, this video was very helpful.
READ THIS!! If you replicate the Excel file the way he does in the video, you simply need to insert (copy and paste) these formulas in these cells to make it work: (1) in Cell E2 --> =A1, (2) in Cell E4 --> =UNIQUE(B2:B8), (3) in Cell G4 --> =COUNTIF(B2:B8,E4), and (4) in Cell H4 --> =COUNTIF($B$2:$B$8,E4)/COUNTA($B$2:$B$23). You can modify the Excel file later to suit your own needs without messing up the formulas. In other words, if you add columns, the formulas will adjust accordingly. Good luck!
Have you published this coding scheme in a research paper? secondly, how to create the first excel sheet where you have incorporated the data?
Hello, is this also called thematic analysis?
In fact you did everything except showing us how to create the automatic table you're using! So, we get this. It's marketing!
Can you please tell how to create table, which formula did you use to count automatically?
where can this time-saving spreadsheet be purchased?
Well, this is just cruel. I got so excited about this beautiful template, but can't seem to access it anywhere. Please oh please Mr. One Year Dissertation - let us know where we can get this? It would save me so much time. 😩
Can you attach link to your spread sheet so we can download, and follow your format? Thank you and God bless
How to do the table in excel????
I didn't hear how to create that table on excel please can you help🙏
Brilliant
How about if I have a thousand responses? Do I need to check one by one?
Do you have anything more complex and realistic as an example
What if someone lists multiple things in one response e.g. in your last example, what if one respondent had said "atmosphere and blue glass"? Do you then tally 1 point in each category? Is that not then duplicating the weight of that respondents opinion?
i have used 2 approaches (depending on study objectives, and typically budget) - only count the first mentioned 'thing', as typically people list the most significant 'thing' first. or if objective/budget allow, count both/all as separate entries, sometimes allocating less of a point to things mentioned later
@@KKmovesToMars Thanks
Is this Qualitative research study ?
I can't seem to get the link to work to purchase this spreadsheet.
TH-cam won't let me comment a URL. Just delete the spaces if you want to access either resource
have you managed to find the spreadsheet?
Hello, is this still available to purchase?
How do I cite this video? I need the Arthur name atleast