A A A
Manual Event (Session ID,DateTime,Event) = 8g6lhe8uqo9n32id9jsrlhrjnm 20240229122108 /sc/communities/missing-value-analysis/

Missing value analysis

Share:
Whtasapp
主題討論

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!

最近的活動討論

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

討論:Poverty, Social Disadvantage, and Social Protection
May
2019年11月29日
Missing value analysis

About missing value analysis, what are the relevant options?

Reply
Like
Share
Whtasapp
Jason Jiang
2020年2月20日

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

回覆
Like
分享
Whtasapp
Hobbs
2020年2月10日

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

回覆
Like
分享
Whtasapp
Dr. MEL
2019年11月29日

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

回覆
Like
分享
Whtasapp
May
2019年11月29日

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

回覆
Like
分享
Whtasapp
Dr. MEL
2019年11月29日

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

回覆
Like
分享
Whtasapp
May
2019年11月29日

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

回覆
Like
分享
Whtasapp
Dr. MEL
2019年11月29日

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.

回覆
Like
分享
Whtasapp
May
2019年11月29日

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

回覆
Like
分享
Whtasapp
Dr. MEL
2019年11月29日

You are welcome May!

回覆
Like
分享
Whtasapp
May
2019年11月29日

Thanks a lot!!

回覆
Like
分享
Whtasapp
Dr. MEL
2019年11月29日

you can transform “system missing” into 999

回覆
Like
分享
Whtasapp
May
2019年11月29日

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

回覆
Like
分享
Whtasapp
May
2019年11月29日

Thanks a lot.

回覆
Like
分享
Whtasapp
Dr. MEL
2019年11月29日

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.

回覆
Like
分享
Whtasapp
最新討論帖
更多的討論帖
Can I participate in the “life ambassadors” initiative for life education as a volunteer?
Can I participate in the "life ambassadors" initiative for life education as a volunteer?
DomingoYan
2024年2月9日
3個回覆,0個月前
Like
分享
Whtasapp
What kind of forms can be employed in the community for life education?
What kind of forms can be employed in the community for life education?
DomingoYan
2024年2月9日
3個回覆,0個月前
Like
分享
Whtasapp
I wish to volunteer in the field of life education. Have you got any suggestions?
I wish to volunteer in the field of life education. Have you got any suggestions?
Armand
2024年2月9日
3個回覆,0個月前
Like
分享
Whtasapp
Hello, my friend plans to commit suicide. Exists a suicide crisis center in Hong Kong that can provide assistance?
Hello, my friend plans to commit suicide. Exists a suicide crisis center in Hong Kong that can provide assistance?
Armand
2024年2月9日
3個回覆,0個月前
Like
分享
Whtasapp
精選討論帖
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
2021年8月26日
7個回覆,30個月前
Like
分享
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
2021年8月20日
3個回覆,30個月前
Like
分享
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
2019年10月15日
0個回覆,52個月前
Like
分享
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
2019年10月9日
4個回覆,52個月前
Like
分享
Whtasapp