import data

How to import data in SPSS from excel file (data analysis part-3)

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

Spss is very easy to use because we can import any types of data set in spss. We can import data set in spss from excel, stata, R, sas etc. data analytics software.

 
Import Data in spss from Excel

Open spss go to “Menu Bar” and select-
“File”“Open”“Data”
import data in spss
Open new data set



Now there open a new box named “open data” and we have go to the “Files of type”  and select as “Excel(*.xls,*.xlsx,*.xlsm)”  


import data
selecting excel data set




Then select your target Excel file and click “open”  and there open a new box named “opening excel data source”, now we have to click on “continue”,


import data from excel
Opening excel data source




And finally our excel file is imported in spss,

import data in spss
Imported data set

The above data set is impoted from spss. First row of excel spreadsheet indicate the variables name which are automatically ditected by spss. The rest rows of excel sheet represents the data or observations. Spss is very simple data analytics software to manage, clean and analysis of data.




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 […]