How to import excel data on SPSS | Statistical Analysis | Part-1| Lecture 69 | Dr. Muhammad Naveed

How to import data on SPSS:
Many researchers do their data collection in Microsoft Excel. It will be vital that we can import data from Microsoft Excel into SPSS. This is a common practice in statistics and one that will be useful for anyone using SPSS.

SPSS offers four programs that assist researchers with their complex data analysis needs.
Statistics Program
SPSS’s Statistics program provides a plethora of basic statistical functions, some of which include frequencies, cross-tabulation, and bivariate statistics.

Modeler Program
SPSS’s Modeler program enables researchers to build and validate predictive models using advanced statistical procedures. IBM SPSS Modeler is a data mining and text analytics software application from IBM. It is used to build predictive models and conduct other analytic tasks. It has a visual interface that allows users to leverage statistical and data mining algorithms without programming. 

Text Analytics for Surveys Program
SPSS’s Text Analytics for Surveys program helps survey administrators uncover powerful insights from responses to open-ended survey questions. a survey text coding application that provides for meaningful analysis of responses to open-ended questions. With this product, anyone performing survey research can quickly transform unstructured survey responses into quantitative data.

Visualization Designer
SPSS’s Visualization Designer program allows researchers to use their data to create a wide variety of visuals like density charts and radial boxplots from their survey data with ease.

Variable View
Name: This is a column field, which accepts the unique ID. This helps in sorting the data. For example, the different demographic parameters such as name, gender, age, and educational qualification are the parameters for sorting data.The only restriction is special characters which are not allowed in this type.
Label: The name itself suggests it gives the label. Which also gives the ability to add special characters.
Type: This is very useful when different kinds of data are getting inserted.
Width: We can measure the length of characters.
Decimal: While entering the percentage value, this type helps us to decide how much one needs to define the digits required after the decimal.
Value: This helps the user to enter the value.
Missing: This helps the user to skip unnecessary data which is not required during analysis.
Align: Alignment, as the name suggests, helps to align left or right. But in this case, for ex. Left align.
Measure: This helps to measure the data being entered in the tools like ordinal, cardinal, and nominal.
The data has to enter in the sheet named “variable view”. It allows us to customize the data type as required for analyzing it.
To analyze the data, one needs to populate the different column headings like Name, Label, Type, Width, Decimals, Values, Missing, Columns, Align, and Measures.
These headings are the different attributes that, help to characterize the data accordingly.
Data View
The data view is structured as rows and columns. By importing a file or adding data manually, we can work with SPSS.

About Dr. Muhammad Naveed
(Associate Professor, HoD, Biotechnology, University of Central Punjab, Lahore)
Dr. Muhammad Naveed obtained a Ph.D. degree in Biotechnology (Genomics & Bioinformatics) from Quaid-e-Azam University, Islamabad with distinction. He has won Ph.D. indigenous & IRSIP scholarships from HEC. He has done Pre-Doc research at the University of Ghent, Belgium. HEC awarded him the best Ph.D. (IRSIP) Scholar of the year in 2013 & QAU honored him as “Distinguished Alumni” in 2017. He is doing research projects in Bioinformatics & Molecular Biotechnology. He has supervised 45 MSc., and 52 MPhil. & 01 Ph.D. He has published 84 Research articles with 363 impact factor and 1300 citations, 01 book, and 03 book chapters. He has been awarded distinguished “Researcher of the Years (2016, 2018 & 2019)” by UoG and UCP.
#spss #dataimport #data