Darko_Giac
06-13-2019, 06:41 AM
Hi All,
I currently have a fairly large data set of dichotomized data points denoting a right (1's) and wrong response (0's)
I currently have a custom function that will start summing correct responses, but stop summing after a respondent has received four (or more) 0's in a row
What I am looking to do next is write a macro that will re-code all of the responses after the participant has reached the four-0's-in-a-row cut-off to 0's (even if they got some questions correct after they answered four or more in a row incorrectly).
I've attached a workbook which will hopefully clarify the issue, but any help/advice would be greatly appreciated!
Darko
I currently have a fairly large data set of dichotomized data points denoting a right (1's) and wrong response (0's)
I currently have a custom function that will start summing correct responses, but stop summing after a respondent has received four (or more) 0's in a row
What I am looking to do next is write a macro that will re-code all of the responses after the participant has reached the four-0's-in-a-row cut-off to 0's (even if they got some questions correct after they answered four or more in a row incorrectly).
I've attached a workbook which will hopefully clarify the issue, but any help/advice would be greatly appreciated!
Darko