Lab Manual Practical 1
Lab Manual Practical 1
Lab Manual Practical 1
(Lab Manual)
Academic Year: 2020-21 EVEN SEMESTER
Programme(UG/PG) : UG
Semester : 4th
Objectives:
1. The Students will able to understand the basic introduction to many of the functions in SPSS
2. Train students regarding concept and structure of recording data entry in Spss.
3. Enable the Students to create a SPSS file and how to enter data in SPSS.
Course Outcomes:
1. Students will understand about the basic Introductory part and Get knowledge about SPSS.
2. Students will able to learn the practical aspect and Data entries in SPSS.
3. Students will learn the how to enter data in SPSS software.
Procedure:
Introduction: SPSS (Statistical Package for Social Sciences) is a versatile and responsive program designed
to undertake a range of statistical procedures. SPSS software is widely used in a range of disciplines and is
available from all computer pools within the University of South Australia.
It’s important to note that SPSS is not only statistical software – there are many others that you may
come across if you pursue a career that requires you to work with data. Some of the common
statistical packages include Stata and SAS (and there are many others).
2. Output window : This window is used to show the results that have been output from your data
analysis. Depending on the analysis that you are carrying out this may include the Chart Editor
Window or Pivot Table Window.
3. Syntax window : This window shows the underlying commands that have executed your data
analysis. If you are a confident coder this is where you can amend the code or write your own from
scratch and then run your own custom analysis on your data set.
4. Script window :Scripts can be used to customize operations within a particular stream and they are
saved with that stream. Scripts can be used to specify a particular execution order for the terminal
nodes within a stream. It is mainly used for coding and programming.
If SPSS Statistics is already open, you can create a new file as follows:
Click File > New > Data on the main menu, as shown below:
You have now created a new file and can enter data and define your variables. If you need help with
this, you can learn how to do this in our Entering Data in SPSS Statistics guide.
Here is an example of what properly formatted data looks like in Excel 2010:
Once the data in your Excel file is formatted properly it can be imported into SPSS by following these
steps:
1. Click File > Open > Data. The Open Data window will appear.
2. In the Files of type list select Excel (*.xls, *.xlsx, *.xlsm) to specify that your data are in an
Excel file. If you do not specify the type of file that you wish to open, your file will not
appear in the list of available files. Locate and click on your file. The file name will appear in
the File name field. Click Open.
In the screenshot example above, “Excel” is selected as the file type, so only Excel files in the
current folder are visible.
3. If you are using SPSS Version 25, the Read Excel File window will appear.
In the Worksheet dropdown menu, select the sheet from your Excel workbook that contains
your data. (If you have not assigned names to the sheets in your Excel workbook, the labels you see
here will usually be Sheet1, Sheet2, Sheet3, etc.) You can only import one sheet from your Excel
file at a time.
If your variable names are in the first row of data, select the Read variable names from the
first row of data check box.
The options Remove leading spaces from string values and Remove trailing spaces from
string valuesonly affect variables that are imported as strings. The former will remove any
whitespace characters that appear at the start of the string, and the latter will remove any whitespace
characters at the end of the string. This is optional, but is often convenient, since leading and trailing
spaces can appear invisible to the user, but cause SPSS to think that otherwise identical strings are
distinct.
You may also specify the range of rows/columns to import if you wish. It is suggested to keep
the default value unless you have a reason for altering it.
Click OK when you are finished.
4.If you are using SPSS version 24 or earlier, you will instead see the Opening Excel Data Source
window:
The meaning of Read variable names from the first row of data checkbox, the Worksheet
dropdown, and the Range box are the same as above. The Maximum width for string columns
option determines how wide a string variable should be; it is suggested to keep the default
value unless you have a reason for altering it.
Now the data will appear in SPSS. Here is an example of how sample data appear in SPSS once the data
have been imported: