A A A
Manual Event (Session ID,DateTime,Event) = 3k1u2auso93ljdn455jtn9rm5h 20220526213437 /communities/missing-value-analysis/

Missing value analysis

Share:
Whtasapp
Topic Discussions

Hello! I’m Dr. MEL. Nice to meet you! I’m absolutely excited that we are going to start this beautiful learning journey together and I’m sure you will find it fruitful and fulfilling. Feel free to share your thoughts here!

Recent Activity Discussions

Got questions? Simply post them and let’s discuss! 

Discussion thread: Poverty, Social Disadvantage, and Social Protection
May
29 November 2019
Missing value analysis

About missing value analysis, what are the relevant options?

Reply
Like
Share
Whtasapp
Jason Jiang
20 February 2020

Imputation or Removing Data

Before jumping to the methods of data imputation, we have to understand the reason why data goes missing.

1)Missing at Random (MAR): Missing at random means that the propensity for a data point to be missing is not related to the missing data, but it is related to some of the observed data

2)Missing Completely at Random (MCAR): The fact that a certain value is missing has nothing to do with its hypothetical value and with the values of other variables.

3)Missing not at Random (MNAR): Two possible reasons are that the missing value depends on the hypothetical value (e.g. People with high salaries generally do not want to reveal their incomes in surveys) or missing value is dependent on some other variable’s value (e.g. Let’s assume that females generally don’t want to reveal their ages! Here the missing value in age variable is impacted by gender variable)

In the first two cases, it is safe to remove the data with missing values depending upon their occurrences, while in the third case removing observations with missing values can produce a bias in the model. So we have to be really careful before removing observations. Note that imputation does not necessarily give better results.

Reference: https://towardsdatascience.com/how-to-handle-missing-data-8646b18db0d4

Replies
Like
Share
Whtasapp
Hobbs
10 February 2020

I face this problem quite a lot!! Thanks for the information!

Replies
Like
Share
Whtasapp
Dr. MEL
29 November 2019

You can use the syntax in the syntax window.

For opening a new syntax window, please click
• File > New> Syntax to open a new syntax window
• Type (or copy and paste) the syntax in the syntax window.
• Click “RUN” on the toolbar

Replies
Like
Share
Whtasapp
May
29 November 2019

I am new to SPSS. Where can I use the syntax?

Replies
Like
Share
Whtasapp
Dr. MEL
29 November 2019

Yes, the syntax is:
RECODE var 1 TO var 100 (SYSMIS=999) (ELSE=COPY).

Replies
Like
Share
Whtasapp
May
29 November 2019

Thanks a lot. Apart from click those tabs, may I know the relevant syntax?

Replies
Like
Share
Whtasapp
Dr. MEL
29 November 2019

Sure. The following are the steps:
• Transform
• Recode into same variable (choose all 100 variables)
• Old and new values: When you click, a new window where you can specify how to transform the values will appear. You can choose to transform ‘system missing’ into 999.

Replies
Like
Share
Whtasapp
May
29 November 2019

May I know the steps in details and how to convert blank spaces for 100 variables at the same time?

Replies
Like
Share
Whtasapp
Dr. MEL
29 November 2019

You are welcome May!

Replies
Like
Share
Whtasapp
May
29 November 2019

Thanks a lot!!

Replies
Like
Share
Whtasapp
Dr. MEL
29 November 2019

you can transform “system missing” into 999

Replies
Like
Share
Whtasapp
May
29 November 2019

How can I transform blank spaces in SPSS data into one missing value?

Replies
Like
Share
Whtasapp
May
29 November 2019

Thanks a lot.

Replies
Like
Share
Whtasapp
Dr. MEL
29 November 2019

The “Exclude cases listwise” option consists of cases in the analysis only if they have full data on all of the variables.

The “Exclude cases pairwise” option only excludes the cases if they are missing the data required for the specific analysis.

For some statistical procedures, the “Replace with mean” option is available. It calculates the mean value for the variable and gives every missing case this value.

Replies
Like
Share
Whtasapp
Latest Posts
More posts
Hi there. I hope to find an assessment tool to evaluate the severity of a person’s substance abuse and provides a comprehensive overview of a person’s addiction-related issues. Do you have any recommendations?
Hi there. I hope to find an assessment tool to evaluate the severity of a person’s substance abuse and provides a comprehensive overview of a person’s addiction-related issues. Do you have any rec ...
Judy
12 May 2022
3Replies,0Months ago
Like
Share
Whtasapp
Hey. When I need to decide who will be involved in the evaluation team, who should I take into consideration?
Hey. When I need to decide who will be involved in the evaluation team, who should I take into consideration?
Judy
12 May 2022
3Replies,0Months ago
Like
Share
Whtasapp
It is said that a treatment evaluation should also include activities evaluations. Would you please kindly give me a clue about it?
It is said that a treatment evaluation should also include activities evaluations. Would you please kindly give me a clue about it?
Anton CHOW
12 May 2022
3Replies,0Months ago
Like
Share
Whtasapp
Hi, friend! Following my previous question, regarding step 1 “Engage people affected by the program and/or evaluation”, could you please give me more information about what does it mean?
Hi, friend! Following my previous question, regarding step 1 "Engage people affected by the program and/or evaluation", could you please give me more information about what does it mean?
Anton CHOW
12 May 2022
3Replies,0Months ago
Like
Share
Whtasapp
Featured Posts
Hi, I realized that it seems the concept “outcome” is different from the term “output”. Taking the grandparent training project as an example, what is the “outcome’ referable?
Hi, I realized that it seems the concept "outcome" is different from the term "output". Taking the grandparent training project as an example, what is the “outcome’ referable?
CouldYip
26 August 2021
7Replies,9Months ago
Like
Share
Whtasapp
I have designed a large-scale survey about the life satisfaction of low-income families in Hong Kong. Is it appropriate to use the electronic survey through mobile phones?
I have designed a large-scale survey about the life satisfaction of low-income families in Hong Kong. Is it appropriate to use the electronic survey through mobile phones?
Realistic
20 August 2021
3Replies,9Months ago
Like
Share
Whtasapp
Questions about program evaluation and impact assessment (PE & IA)?
Dear MEL participants, Hello everyone! We are going to meet Prof. Aron Shlonsky this week (17&18 Oct). Do you have any problems or issues in program evaluation and impact assessment? Pleas ...
meladmin
15 October 2019
0Replies,31Months ago
Like
Share
Whtasapp
Question about the programme evaluation
Can someone recommend me a basic guide book for programme evaluation? We are an NGO in mainland China and providing services for young drug abusers in rural China. We learnt about your pro ...
Jessica
9 October 2019
4Replies,31Months ago
Like
Share
Whtasapp