missing value analysis using spss

Finding and Replacing missing values using SPSS

Spread the love
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  

Missing value analysis using spss is a procedure of finding, replacing or coding missing values of a data set using spss. Spss is a simple statistical analytics tool which help us to perform various data analytics task.

Missing values analysis using spss

How can we find missing values?

  1. To find the missing values we have to go “Menu bar” and click on ,
               “Analyze”→”Descriptive statistics”→”Frequencies”
     Then there open a new box named “Frequencies” , now  we have to double click on the every variable and click on “ok”.
Missing value analysis by statisticalaid.com
Finding missing values


                                                                      ↓

spss data set (missing value analysis)



3. Now we can see the output window with frequencies of the variables.
If we have any missing value , we can see the number of missing in “missing sector”

 

output of missing value analysis
Finding missing values


4. Now we have to replace the missing values. For replacing the missing values we have go to “Menu bar” and click on “Transform”→”Replace missing values”, then there open a new box named “Replace missing values” and double click on the variable which contains missing value. for example
“age of the students in year” and “grade point average of the student”,
5. Then we have to enter a new variable name for each variable(which contains missing value) in the “name” section and go to “method” section and select “median” and click on “change” 
And finally click on “ok”

replacing missing values
Replacing missing values


                                                                                ↓

replacing missing value analysis
Replacing missing values

6. Finally new variable creates and there is no missing values left.

new variable
Replacing missing values

By using this process we can easily replace missing values for any length of data set.
There is also an alternative way to find missing values.

Alternative way to find missing values in a data set:

1. First we have to go to the Analyze section and click on it, then we have to follow the following instruction as in the images.

spss data set
Go to analyze

 

missing value analysis using spss
Select missing value analysis
variable list
Select all the variables
missing value analysis
click on “ok”

Missing value analysis using spss (result)

missing value analysis using spss
Output window


Finally, we can see there exit two missing values in two variable. Now we have to follow the instruction (discuss in the first section) to code/replace the missing values.

How to analyze data using SPSS (for beginners)-part 1
How to analyze data using SPSS (part-2), how to input data in SPSS
How to analyze data using SPSS (part-3), how to import data in SPSS from excel file
How to analyze data using SPSS (part-4), how to sort data in SPSS
How to analyze data using SPSS ( part-5) how to merge file in SPSS?
How to analyze data using SPSS ( part-6), how to merge file in SPSS
How to analyze data using SPSS (part-7), Finding missing values, Replacing missing values, Coding missing values in SPSS
How to analyze data using SPSS (part-8), variable transformation, Recoding variables in spssUnivariate Analysis (data analysis using spss part-9)
Bivariate analysis| How to analyze data using spss (part-10)
Normality check| how to analyze data using spss (part-11)

Leave a Reply

Your email address will not be published. Required fields are marked *

Releated

normality check using spss

Normality checking of a data set using spss

Spread the love
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  

Spread the love          Normality checking is a procedure of check the normality of our working data set. Basically we check the normality using histogram. If the shape of the histogram is bell shaped then the data set follow the normal distribution. We also use the normality table including kolmogrov-smirnov test and shapiro-wilk test value. If the […]

bivariate analysis

Bivariate analysis using spss (data analysis part-10)

Spread the love
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  

Spread the love          Bivariate analysis using spss is very simple procedure of finding the association between two variables. Spss is a very simple data analytics tool by which we can perform our analysis very easily. Bivariate Analysis What is bivariate analysis? Bivariate analysis is the analysis of two random variable and find their association. For bivariate […]

univariate analysis using spss

Univariate analysis using spss (data analysis part-9)

Spread the love
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  

Spread the love          We conduct Univariate analysis using spss to find the characteristics of this variable. Spss is a simple statistical analytics tool which is very easy to use and maintain. What is univariate analysis using spss? It is the analysis of one random variable such as descriptive statistics (mean, variance etc.). We have the following […]