Forum Discussion
Putting words into categories and showing the category rather than the word in each cell
Siobhan- Perhaps the attached workbook will help you solve your problem. If not, please upload an example of your workbook so that we can have a look at it.
Good evening, Riny_van_Eekelen. Thank you again! And thank you so much for making that workbook and giving up your time! Unfortunately, it is not working for me when I use those formulas. I'll attach the workbook with my word stimuli, there are 3 different categories of words as you will see each word list has 36 words and I need the "neutral" words to show as 1, "emotional" words as 2 etc.
Essentially, I am conducting a memory recall test so these words will show on the screen and afterwards each participant will need to write as many words as they can remember and these written responses show in one cell and as text format but I need to somehow assign the worded responses to a number so I can correlate the responses. I thought giving each category of words a number would help me do this but I have been trying to figure it out all day and no luck! I have made a practice experiment using less words to see how the data file would look. I shall attach that too so you can get a general idea of what my data will look like in the real experiment. - On the third sheet of the combined_recall file I have gave a brief explanation of what I mean.
Thanks again! Kind regards, Siobhan 🙂
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.