Forum Discussion
Putting words into categories and showing the category rather than the word in each cell
Siobhan- Thanks for the example sheets, but I'm not really following your intentions.
E.g. on Sheet3 in the Combined file, why are the three words (Item and Response) in one cell, separated by a line feed? On Sheet1, what is the meaning of RRRR or FFFF attached to each word in column B? On the sheet named "combined", how do all the numbers relate to Sheet1 and/or Sheet3?
Morning Riny_van_Eekelen. Sorry for the confusion! I'm not sure what you mean by word item and response being separated by a line feed, sorry I am new to excel! But on sheet 3 in the response section where the 3 responses are all in one cell, this is how the responses show up on excel from the data. Sheet 1 is how PsychoPY automatically downloads the data, but I do not need all of the information on that sheet for example "info key" or "welcome screen" I literally just need the participants response, so the following sheets are where I have edited all of the other data out. - It doesn't relate at all to the word stimuli sheet as the combined one was just a practice to see how the data shows up, the F and R are elements of the research which can just be ignored if that's okay:) - unless you need to know what they are of course. But I'm hoping to not have to have the "R"s and "F"s on the stimuli list, going to try find an alternative way around it in PsychoPY. - Say if the practice experiment was the real one, the stimuli which is the worditem, is what is being asked to recall in the test afterwards and the response cells are what they have recalled - these responses all go into one cell, I wish to know how I can make it so that the stimuli (word item) is grouped into 3 groups 1,2,3, and then take on that numerical value instead of the written word so that when I have my real data I can somehow change the written responses to fit in line with the 1,2,3. -e.g. say chair is a wordItem, and in the response cell someone has wrote chair, I would want the word item to be 1 instead of chair and then the response of chair to also take on that number, that way I am working with numbers and I can still establish what word group the word has come from (individual words aren't needed, it is more the group they belong to). I apologise for the lengthy message, I wanted to try and explain for you to gain clarification! Thank you for your time! I really appreciate it:)
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:)
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?