A A A
Manual Event (Session ID,DateTime,Event) = 3g25h81o2fejjbl55b8ks3k31b 20211128004914 /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
Someone told me that a pretest is a more important component of a quasi-experimental design. Could you please elaborate more for me, taking the older adult group as an example?
Someone told me that a pretest is a more important component of a quasi-experimental design. Could you please elaborate more for me, taking the older adult group as an example?
Rebecca@yahoo.com.hk
27 November 2021
3Replies,0Months ago
Like
Share
Whtasapp
The current restrictions and rules on public gatherings may make older adults more isolated. Therefore, we hope to understand the potential difference in the subjective feelings of social isolation between community-dwelling and institutionalized elders. But the reality does not allow us to adopt randomization. Could you please give us some advice?
The current restrictions and rules on public gatherings may make older adults more isolated. Therefore, we hope to understand the potential difference in the subjective feelings of social isolatio ...
Rebecca@yahoo.com.hk
27 November 2021
3Replies,0Months ago
Like
Share
Whtasapp
There are many dropout cases in my samples of older adults living in the community. I wonder can I use the pretest score to examine differences among the remaining group members?
There are many dropout cases in my samples of older adults living in the community. I wonder can I use the pretest score to examine differences among the remaining group members?
Emilia@gmail.com
27 November 2021
3Replies,0Months ago
Like
Share
Whtasapp
If our team plans to conduct a longitudinal study to examine the impacts of a program for older adults, may I ask the function of its pretest?
If our team plans to conduct a longitudinal study to examine the impacts of a program for older adults, may I ask the function of its pretest?
Emilia@gmail.com
27 November 2021
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
6Replies,3Months 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,3Months 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,25Months 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,25Months ago
Like
Share
Whtasapp