How to Create a Frequency Table in SPSS (Using the Frequencies Procedure)

How to create a frequency distribution table in SPSS is illustrated. Creating tables in both ascending and descending order is shown.
Video Transcript: Here we have a variable, scores, and we have 10 people on this variable. And notice here on this variable the smallest value is the value of 6, and the highest value is a value 10. To obtain a frequency distribution table on this variable, we want to go to Analyze and then Descriptive Statistics and then we'll select Frequencies. The Frequencies dialog box opens. We want to select the variable scores, and move it over to the Variable(s) box by clicking on the right arrow button. And then really that's about it for now, click OK. And then the output window opens, and in the output we see here our table, Scores. Notice that we have the scores, they're ordered from lowest to highest, so 6 through 10. And then in the next column we have the frequency. So we can see here there's three values of 6, one value of 7, three values of 8, 1 value of 9, and two values of 10. We also have the percentage reported, so 30% of all of the values, had a value of 6, or 6 occupied 30% of the dataset. Nine represented 10% of the data set, and so forth. And then, finally, we have the cumulative percent column, which may be of interest, particularly if you're in an introductory statistics course. In many frequency tables, you're asked to calculate the cumulative percentage. So if you are, that's what this column will do. And it tells you the percentage, as it accumulates, as you go to the top. So, for example, this 100% here indicates that the values of 10 and below, so in other words, all of the values, represent 100% of the data, or the values there. A nine and below represents 80% of the values, and so forth. And I'm not taking into account real limits here when I say that, so that's of relevance to you just make that note to yourself. OK now what if we wanted to have these values, say you wanted them to be in reverse order. Instead of from lowest to highest, you'd like it to be from highest to lowest. So instead of 6, 7, 8, 9, 10, we wanted let's say 10, 9, 8, 7, 6. Well to do that, we'll just rerun our analysis. We'll go to Analyze, Descriptive Statistics, and then Frequencies. And here we'll select, under Format, we're just going to select Descending values. So go ahead and click on Descending values. Click Continue and then click OK. And here we see that now our values are in descending order, so 10, 9, 8, 7, 6, and we see the frequencies here. And this table will agree with this table, of course, because we're looking at the same data. So we have two values of 10, and so on. The only thing is when you order your values from highest to lowest, the cumulative percentages are reversed, and typically the cumulative percentage is read this way in this table, where 100% indicates the highest score. Notice it's reversed here, so keep that in mind if you do order your values from highest to lowest. This concludes the tutorial on obtaining frequency distribution tables in SPSS.
RUclips Channel: / statisticsinstructor
Channel Description: For step by step help with statistics, with a focus on SPSS. Both descriptive and inferential statistics covered. For descriptive statistics, topics covered include: mean, median, and mode in spss, standard deviation and variance in spss, bar charts in spss, histograms in spss, bivariate scatterplots in spss, stem and leaf plots in spss, frequency distribution tables in spss, creating labels in spss, sorting variables in spss, inserting variables in spss, inserting rows in spss, and modifying default options in spss. For inferential statistics, topics covered include: t tests in spss, anova in spss, correlation in spss, regression in spss, chi square in spss, and MANOVA in spss. New videos regularly posted. Videos series coming soon include: multiple regression in spss, factor analysis in spss, nonparametric tests in spss, multiple comparisons in spss, linear contrasts in spss, and many more. Subscribe today!
RUclips Channel: / statisticsinstructor
Lifetime access to SPSS videos: tinyurl.com/m25...
How to create a bar chart in SPSS: • How to Create a Bar Ch...
Histogram in SPSS video: • Create a Histogram in ...
Add variables together in SPSS using the compute procedure: • Add Variables together...
Likert scales -- part 1: • Likert Scales and Codi...
Stem and Leaf plot in SPSS: • How to Create and Inte...
RUclips Channel: / statisticsinstructor

[@paulagabier7493]

Please help! How do I get the frequencies to print out the value labels even when their frequencies are zero? In other words, if I have Agree strongly, agree somewhat, disagree somewhat and disagree strongly, if no one disagreed strongly, it does not even print disagreed strongly with 0%. Do you know how I can get ALL variables to print, even if the frequency is zero? Thank you!