A A A
Manual Event (Session ID,DateTime,Event) = mpi2tmufpd14e9vjijuruuqkj4 20210805114629 /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
Is there any specific service for victims of family violence in Hong Kong?
Is there any specific service for victims of family violence in Hong Kong?
Lau WL
5 August 2021
2Replies,0Months ago
Like
Share
Whtasapp
Following the previous post, how many cases are served each year in refuge centers for women?
Following the previous post, how many cases are served each year in refuge centers for women?
Lau WL
5 August 2021
3Replies,0Months ago
Like
Share
Whtasapp
How many refugee centers for women are there in Hong Kong?
How many refugee centers for women are there in Hong Kong?
Sandy Lau
5 August 2021
3Replies,0Months ago
Like
Share
Whtasapp
What are the organizations that provide SPeaR?
What are the organizations that provide SPeaR?
Sandy Lau
5 August 2021
3Replies,0Months ago
Like
Share
Whtasapp
Featured Posts
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,22Months 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,22Months ago
Like
Share
Whtasapp
Ask for more information about the logic model
I have watched the cartoon of the logic model and it is really useful for our programme evaluation. May I obtain some further references of the logic model? Thanks!
Marleen
5 October 2019
3Replies,22Months ago
Like
Share
Whtasapp
Seek for advice on Programme evaluation
Hi! We work for the ethical minority group in Hong Kong. The ultimate goal of our organisation is to make changes to public policies, such as to the education system or medical service. We spe ...
Aurielle Lee
2 October 2019
4Replies,22Months ago
Like
Share
Whtasapp