Computing variables when some case data is missing

Discuss the jamovi platform, possible improvements, etc.
Post Reply
jbasch
Posts: 2
Joined: Wed Apr 14, 2021 8:27 pm

Computing variables when some case data is missing

Post by jbasch »

Hi. I noticed when computing a new variable in jamovi that the program does not use cases with missing data. Is there a way to toggle this on. For example, if I'm trying to create a sum score but impute missing data using the participants mean score with the following formula: total score = mean(var1, var2, var3, ...)*number of variables, it only creates scores on the new variable for cases that have no missing data. I'm not sure if this is a limitation of jamovi or I'm missing a setting or command that allows computation with cases with missing variables. As you can see in my example there are times when you would want to do this. If it's a limitation I respectfully request that this be considered a feature request for addition in future releases.
Thanks!
User avatar
jonathon
Posts: 2613
Joined: Fri Jan 27, 2017 10:04 am

Re: Computing variables when some case data is missing

Post by jonathon »

try this:

MEAN(var1, var2, var3, ignore_missing=1)

jonathon
jbasch
Posts: 2
Joined: Wed Apr 14, 2021 8:27 pm

Re: Computing variables when some case data is missing

Post by jbasch »

That does it. Thanks!
Post Reply