Page 1 of 1

Cleaning Data - Case-Mean Substitution IF

Posted: Wed Feb 28, 2024 2:38 pm
by somereve
Hello,

I am trying to replicate a previous study. To clean the data and deal with missing data, I need to: "As per Fogel & Kovalenko (2013) we did not remove any outliers and used case-mean substitution for missing data. To qualify for case-mean substitution, the missing data must have met the following criteria outlined by Fox-Wasylyshyn & El-Masri (2015) for self-report measures: (1) fewer than 60% of the items on a given measure for a given participant are missing (2) fewer than 15% of cases within a given measure are missing. We chose to use the aforementioned eligibility criteria to help maintain variability across measures and participants."

I am struggling to filter to use code to determine what % of each measure was answered by each individual participant to determine they answered 60% of the items for every measure/survey used.

Thank you!

Re: Cleaning Data - Case-Mean Substitution IF

Posted: Wed Feb 28, 2024 10:29 pm
by jonathon
yeah, this is a tricky one. how many items in the measure?

jonathon

Re: Cleaning Data - Case-Mean Substitution IF

Posted: Wed May 29, 2024 11:15 am
by somereve
Hi sorry for the delay in response. I have to do this for every measure to determine 60% of items have been answered for each survey. All surveys have a different amount of items (e.g., I use Diener satisfaction with life which is only 5 items, but most of my measures have more items than that

Is there a way I can make a filter to determine how much missing data I have?

Re: Cleaning Data - Case-Mean Substitution IF

Posted: Wed May 29, 2024 11:39 pm
by jonathon
hi,

let me think about this. i think it would be useful if we could provide a function to do this. i've created an issue here where you can track my progress.

https://github.com/jamovi/jamovi/issues/1501

jonathon