Cleaning Data - Case-Mean Substitution IF

[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!

[jonathon]

yeah, this is a tricky one. how many items in the measure?

jonathon

[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?

[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