Missing values

General help and assistance with jamovi. Bug reports can be made at our issues page: https://github.com/jamovi/jamovi/issues . (If you're unsure feel free to discuss it here)
lucysbridge
Posts: 3
Joined: Fri Feb 26, 2021 12:53 pm

Missing values

Post by lucysbridge »

Hi,

I already imported a data set into Jamovi and started data cleaning etc. I have now realised before I start analysis I need to add in missing values as I currently just have empty cells. I have tried setting the missing values in the option bar before just importing the .omv file I have been working on, when I do this none of the empty cells take the new value. How can I just assign a missing value across the entire data set

Hope this makes sense,
Thanks
Lucy
User avatar
jonathon
Posts: 2613
Joined: Fri Jan 27, 2017 10:04 am

Re: Missing values

Post by jonathon »

hi,

so normally, with missing values, you might load in a .csv file, and it might have all these -99 values everywhere. in this situation, you want jamovi to treat these -99 values as though there's no value there at all. so you can using the missing value system to set this up.

however, it doesn't sounds like this is your situation. if you've got empty cells, then those are missing values, and jamovi will treat them as such. so i don't think you need to do anything here -- if i understand correctly. those empty cells will be treated as missing values, and the analyses will handle them correctly without you needing to do anything.

cheers

jonathon
lucysbridge
Posts: 3
Joined: Fri Feb 26, 2021 12:53 pm

Re: Missing values

Post by lucysbridge »

Thanks Jonathon,

That is exactly the situation, I thought I would need to put a value to them as I tried using a SUM formula to add a couple of scales together and it was not doing anything, as in I would press enter and nothing happens. Do you know why else this could be occurring?

Lucy
User avatar
jonathon
Posts: 2613
Joined: Fri Jan 27, 2017 10:04 am

Re: Missing values

Post by jonathon »

so in statistics, you can think of a 'missing value' as a "don't know". so if you're summing two values, and one of them is "don't know", can you see that the result will be "don't know" as well.

however, we can pass an argument to the SUM() function which is ignore_missing. take a look at the following screenshot
Screen Shot 2021-03-02 at 21.49.27.png
Screen Shot 2021-03-02 at 21.49.27.png (594.52 KiB) Viewed 11826 times
does that address the issue?

kind regards

jonathon
User avatar
leehw
Posts: 20
Joined: Fri Nov 22, 2019 8:48 am

Re: Missing values

Post by leehw »

In SPSS it's possible to stipulate how many valid numbers there must be in the formula for it to work. Does Jamovi have anything similar?

E.g. if we want to still take a mean of 10 variables even if 1 or 2 of them are missing, but to return MISSING if any more than 2 are missing, we can do this kind of thing...

Code: Select all

MEAN.8(Vbl1, Vbl2, Vbl3, Vbl4, Vbl5, Vbl6, Vbl7, Vbl8, Vbl9, Vbl10)
It allows pro-rating for a certain percentage of missing data on psychometric scales where that's the approach suggested by the scale developers.

Is there any similar approach in Jamovi?
User avatar
MAgojam
Posts: 421
Joined: Thu Jun 08, 2017 2:33 pm
Location: Parma (Italy)

Re: Missing values

Post by MAgojam »

Hey @leehw,
you were looking for something like this:
tempsnip.png
tempsnip.png (51.33 KiB) Viewed 10319 times
Cheers,
Maurizio
Bobafett
Posts: 76
Joined: Thu Jul 18, 2019 11:33 am

Re: Missing values

Post by Bobafett »

That's a very nifty solution, Maurizio. I'll be using that feature in future!
I'd like to achieve something similar with SUM scores - is there a way to calculate a pro rata version?

I haven't looked in while, but does jamovi have any solution to missing data - like mean imputation?

Cheers!
User avatar
MAgojam
Posts: 421
Joined: Thu Jun 08, 2017 2:33 pm
Location: Parma (Italy)

Re: Missing values

Post by MAgojam »

Bobafett wrote:jamovi have any solution to missing data - like mean imputation?
You could combine it like this:

Code: Select all

IFMISS(myvarname, VMEAN(myvarname), myvarname)
Cheers,
Maurizio
User avatar
jonathon
Posts: 2613
Joined: Fri Jan 27, 2017 10:04 am

Re: Missing values

Post by jonathon »

this blog post describe mean imputation:

https://blog.jamovi.org/2018/10/23/transforming-variables.html

cheers
Bobafett
Posts: 76
Joined: Thu Jul 18, 2019 11:33 am

Re: Missing values

Post by Bobafett »

God I LOVE this forum!!!!!

Thank you so much for the tips, much appreciated :)
Post Reply