Skip to main content

Descriptive Statistics using SPSS: Frequency Distribution Table

In this tutorial we are going too discuss on frequency analysis under descriptive statistics using univariate analysis in SPSS. 

Univariate analysis involves analysis of a single variable.
For example, 
i. formation of frequency distribution table for a single variable "religion" or "marital status" or "ethnicity" etc.
ii. calculation of measures of central tendency (mean, median, mode) for a single variable "height in centimeter" or "weight in grams" or "income in dollars" etc.

In this tutorial, we are dealing with the first part of univariate analysis i.e. frequency calculation. To carry out such analysis, first of all, let us open the sample dataset (that is available in the installation directory when we install the software as shown in the following snapshot). 

Let us try on “demo.sav” file from the installation directory. Remember that the SPSS data files have the extension “.sav”. We may also import files created in other software such as excel or notepad. We may also carry out the analysis in our dataset that we create after entering our own data (click here to see steps for data entry)

Steps of generating frequency distribution table

To do frequency analysis, first of all, we have to determine the variable for which we have to carry out the frequency analysis from our data-set. It depends on our study objectives.
To carry out the frequency analysis, we have to carry out the following steps.

i. Click on Analyze in the menu bar
ii. click on Descriptive Statistics
iii. click on Frequency

iv. A dialog box appears from which we have to select the desired variable from a list of variables and move to right and then click "ok". 

Optional intermediate step: We may also click on "paste" to generate the syntax before clicking on ok. That will open up the syntax editor window. But, if we want to directly create output without syntax, we may directly click "ok". However, recording the syntax has some advantages like we can directly create output from syntax without repeating the entire steps in case we make some changes in our data set. Clicking on paste generates the following window:

Then we select the desired syntax and click on run as shown in the form of green triangular icon in above picture

v. After that the frequency distribution table will be created in a new window which is called “output viewer window”. 

vi. The output can be saved for future reference and the tables can be exported to other software such as Microsoft word or excel.

vii. Interpreting the output: In the output, frequency is the number of observations of a category. From the above figure, 3224 is the number of unmarried persons, 3176 is the number of married and 6400 is the total. Since there are no any missing observations, the value of "percent" and "valid percent" is same. "percent" is calculated out of sample size and "valid percent" is calculated out of total valid responses after excluding the cases whose responses for a particular variable are missing. The "cumulative percent" is the sum of all percentage values up to that category of a variable from top to bottom as shown in the picture. 

Good luck and see you in the next tutorial.


  1. Your article has piqued a lot of positive interest. I can see why since you have done such a good job of making it interesting. frequencies of notes


Post a Comment

Popular posts from this blog

Median test between 2 or more independent groups in SPSS

Multiple response analysis using SPSS

Creating date variable and calculating between two dates in SPSS