A A A
Manual Event (Session ID,DateTime,Event) = j1rmmn8eqrootoqhv70k7t1eil 20241105121733 /tc/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
最新討論帖
更多的討論帖
How to evaluate a program focused on physicians’ attitudes about caring for people with disabilities?
How to evaluate a program focused on physicians’ attitudes about caring for people with disabilities?
Nathan Harris
2024年11月1日
3個回覆,0個月前
Like
分享
Whtasapp
How to evaluate a program focused on using AI to support people with disability in the labor market?
How to evaluate a program focused on using AI to support people with disability in the labor market?
Nathan Harris
2024年11月1日
3個回覆,0個月前
Like
分享
Whtasapp
How to evaluate a program focused on barriers to self-employment for people with disabilities?
How to evaluate a program focused on barriers to self-employment for people with disabilities?
Elijah Clark
2024年11月1日
3個回覆,0個月前
Like
分享
Whtasapp
How to evaluate a program focused on how companies can support people with disabilities at work?
How to evaluate a program focused on how companies can support people with disabilities at work?
Elijah Clark
2024年11月1日
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個回覆,39個月前
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個回覆,39個月前
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個回覆,61個月前
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個回覆,61個月前
Like
分享
Whtasapp