Forum Discussion
Putting words into categories and showing the category rather than the word in each cell
Siobhan- Line-feeds are invisible characters and cause the responses to be display on separate rows within one cell.
Regarding Sheet3, are the three words (like in A2) always belonging to the same group, e.g. 1, 2 or 3? If so, you can write a formula like in G2 and G3 in the attached workbook. It will extract the first word and looks up the corresponding value from the table in Sheet4.
Riny_van_Eekelen Oh I see! The responses will always show in one cell as this is how PsychoPY converts the responses into data. The neutral words will always belong to a specific group, same with the other word list groups but some of the responses won't always be in the same group for example, people could recall words from group 1, 2 and 3. So with the example sheet I would want the words table, carpet and chair in one group and the words feeling, cry and love in another group, both groups with different numerical value that attaches to the responses. So in the response cell where there is "chair, carpet, table" all of those words would belong to group 1 and therefore show as "1"s rather than the word. But for the actual experiment excel sheet it will need 3 different groups of words and the responses to align with the 3 different numbers of the groups. I feel like this may be impossible to do!
Thank you! Siobhan:)
Riny_van_Eekelen Thank you so much! I will follow the instructions and have a go! I really appreciate your help 🙂
Riny_van_Eekelen Have added some instructions to your file in the shaded area below the table. Hopefully, it enables you to clean up the participants' responses and find the word groups for further analysis.
Siobhan- As long as the structure of the data is the same, it shouldn't be too difficult. You'll have a list of words, each assigned to a group number. And you have responses in a slightly odd way. I feel we are over-thinking here. Can you, on the basis of your file, show how you want to summarise the data? And best to use an example that is representative for a real life situation.
Riny_van_Eekelen The formation of the data file depends on how I make the experiment, so the data file for that practice one will not look the same as the data file for my real one but it is generally the same. It will just have different wordItems and responses and the responses may be in a different column. Yes column X is the responses of the participant, so I would want to assign the wordItems into categories and each category have a numerical value that can be attached on to the responses, so that in the column for the responses it will detect what category the word belongs to and then assigns it the same numerical value as the category. This is in order for me to correlate the data, as I can't conduct statistical analysis with the words.
Basically, I would need each response to change to either 1,2,3 based on which category they come from so that I can create a pivot table or use Jamovi for example to see how many times someone recalled a word from a specific category, and to do this I believe I will have to change the word to a number! And no need for apologies, its totally fine, I am sorry if I am confusing you!
Siobhan- So, file you attached is how it always looks like (i.e. column order/headers) and the cell att the bottom in column X is what? Is this the respons for participant 1?
I'm sure it's all clear in your head, but not in mine. Based on the data set, what needs to be matched with what and with what logic? Sorry, if I'm slow!
Riny_van_Eekelen Yes that makes perfect sense, It will be a lengthy process but if that is what I have to do then so be it! I just don't know how to attach a value onto the words so that they can show up as a number rather than the word... The combined excel file is all of the practice PsychoPY experiment data (In the combined sheet), I shall however attach a single data set too! If it would be more helpful I can create my actual experiment and use the actual word stimuli, this will take me a while though so I wouldn't be able to attach any data from it today!
Thanks, Siobhan:)
Siobhan- I guess you need to split the responses into separate words so that you can lookup the corresponding value for each of them. Possible, but you it would be helpful if you could upload a sample of the file from PsychoPY?