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!
Cleaning Data - Case-Mean Substitution IF
Re: Cleaning Data - Case-Mean Substitution IF
yeah, this is a tricky one. how many items in the measure?
jonathon
jonathon
Re: Cleaning Data - Case-Mean Substitution IF
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?
Is there a way I can make a filter to determine how much missing data I have?
Re: Cleaning Data - Case-Mean Substitution IF
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
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