Mean Substitution using transformed data
Posted: Sun Aug 08, 2021 11:46 am
Hi there,
I have transformed variables because the scale they were imported with was wrong (some items were scored using levels 1-7, and some had scores 10-17). So they were all transformed to make the scoring correct. But now I am using mean substitution for some missing data but when I use VMEAN($source) it unsurprisingly gives the mean using the old incorrect scores.
What code can I use to calculate the the mean of the current (transformed) column so that I can substitute NA for the mean of the transformed variable?
Please help!
Thank you
I have transformed variables because the scale they were imported with was wrong (some items were scored using levels 1-7, and some had scores 10-17). So they were all transformed to make the scoring correct. But now I am using mean substitution for some missing data but when I use VMEAN($source) it unsurprisingly gives the mean using the old incorrect scores.
What code can I use to calculate the the mean of the current (transformed) column so that I can substitute NA for the mean of the transformed variable?
Please help!
Thank you