A A A
Manual Event (Session ID,DateTime,Event) = 2us5v0kbjkbctbsvn2nqv730ln 20240419003041 /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
最新討論帖
更多的討論帖
If I were to create a graph showcasing caregiving hours for parents in Hong Kong, would it be appropriate to use the caregiving hours on the X-axis and frequency on the Y-axis?
If I were to create a graph showcasing caregiving hours for parents in Hong Kong, would it be appropriate to use the caregiving hours on the X-axis and frequency on the Y-axis?
sum
2024年4月19日
3個回覆,0個月前
Like
分享
Whtasapp
Histograms and graphs appear similar, but what is the primary distinction between them?
Histograms and graphs appear similar, but what is the primary distinction between them?
sum
2024年4月19日
3個回覆,0個月前
Like
分享
Whtasapp
Building on the previous post, can you provide any insight on whether a bar graph would be an appropriate method to represent the educational attainment of parents?
Building on the previous post, can you provide any insight on whether a bar graph would be an appropriate method to represent the educational attainment of parents?
chowchow
2024年4月19日
3個回覆,0個月前
Like
分享
Whtasapp
May I know if it’s possible to use graphs to present the evaluation results?
May I know if it's possible to use graphs to present the evaluation results?
chowchow
2024年4月19日
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個回覆,32個月前
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個回覆,32個月前
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個回覆,54個月前
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個回覆,54個月前
Like
分享
Whtasapp