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



Import Data from Excel:

-Open spss go to "Menu Bar" and select-
                      "File""Open""Data"
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









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 spss
Univariate analysis| how to analyze data using spss (part-9)
Bivariate analysis| How to analyze data using spss (part-10)


For more updates please visit my blog.

Post a Comment

0 Comments