Forum Discussion
Putting words into categories and showing the category rather than the word in each cell
Hi Riny_van_Eekelen , thank you for this! I have done as you said with the words and the number I want to attach to them but when I try the lookup functions it is saying incorrect formula. I have just watched a tutorial to change them using a replace function and that has replaced the word with the number but only in the replace column and not in my word column.
Essentially I think I need to assign my 3 different word lists to 3 different numbers, so that when participants write down a specific word from say category 1, excel will show 1 instead of the word.
Thank you for your help!
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:)