Hello,
I had an earlier post similar to this, however as I began scoring I realized I missed an important factor that changes everything. This is going to be a really complicated forumla, and I'm looking for a place to begin more than anything.
**See attached file.
This is a simplified version of what I am working with (due to privacy laws). What I need to do is evaluate whether the response in C contains the word in D as well as if it was answered in the order given (not case sensitive). For example A (trial1) would recieve a value "TRUE" next to "dog" and "cat" because they were answered correctly in the order given.
However I'm not sure how to handle the "order" when they are out of order and not all words were recalled. For example in A (trial 3) "smile" "red" and "cloud" were all recalled in order, but since "New York" was recalled first they would technically be wrong if I assigned a PLACE for each word.
I'm not even sure if this really makes sense or is possible... So any advice would be appreciated. I'm also willing to do some manual work because each subject has the same number of rows, so once I figure it out for subject 1 I can fill down.
Bookmarks