SPSS is a popular statistical software package commonly used for the social sciences. A frequency distribution table can give you an idea about the spread of your data in a glance. They are commonly introduced in elementary statistics and AP statistics, although you may have encountered them in basic math classes. Frequencies form the foundation of further study in statistics, like probabilities and distribution tables. They take seconds to create in SPSS once you have entered your data into a worksheet. SPSS uses the Frequency command to populate frequency tables.
How to Make an SPSS Frequency Table: Steps:
Watch the video or read the steps below:
Sample problem: You are studying people in a group home and want to look at their ages at a glance. Create an SPSS frequency table for the following ages: 2,3,4,6,8,44,34,33,45,56,57,56.
Step 1: Type your data into an SPSS worksheet. If you haven’t already done so, click “File,” then click “New,” then click “Data.” You may need to check the “Type in data” radio button. Make sure you enter your data into columns.
Step 2: Click “Analyze,” then mouse over “Descriptive Statistics” and then click “Frequencies.”
Step 4: Click the “Display Frequency Tables” check box and then click “OK.” SPSS will calculate the frequency table and display the results in a separate window. Included are frequencies, cumulative frequencies and percents.
Tip: “Variables” in SPSS are very similar to Column Headings in Microsoft Excel. SPSS will automatically name variables for you with something generic (like VAR0001). To change the variable name to something more meaningful (like “Age,”) click the “Variable View” button at the bottom of the worksheet. Type over the variable name and then return to data view by clicking the “Data View” button at the bottom of the sheet.
If you prefer an online interactive environment to learn R and statistics, this free R Tutorial by Datacamp is a great way to get started. If you're are somewhat comfortable with R and are interested in going deeper into Statistics, try this Statistics with R track.Comments are now closed for this post. Need help or want to post a correction? Please post a comment on our Facebook page and I'll do my best to help!