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.
Open spss go to “Menu Bar” and select-
|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)”
|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”,
|Opening excel data source|
And finally our excel file is imported 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)