Back to blog
·3 min read

Frequency table for your thesis: how to build it and present it in APA

Before testing hypotheses, the results chapter describes who you surveyed and how they answered. That’s done with frequency tables: how many people fall into each category of gender, age, major or variable level. It’s the simplest part of the statistics, but also where committees find the most formatting mistakes.

Which columns it needs

  • Frequency (f): how many people chose each option.
  • Percent (%): the frequency divided by the whole sample.
  • Valid percent: the frequency divided by those who answered that question. It’s the one that matters when there are blank answers.
  • Cumulative percent: the running sum of valid percentages. It only makes sense for ordered variables, such as levels or age ranges.

SPSS shows all four columns. In a thesis, the APA table usually carries only the frequency and valid percent; add the cumulative one if it helps read levels.

What to do with blank answers

If 150 people took the survey but 6 left the income question blank, you have two possible percentages. The percentage over 150 understates every category; the valid percentage, over 144, describes those who did answer. Use the valid one and add a note saying how many cases were excluded. Never fill blanks with zeros: that changes both the frequencies and the mean.

Frequencies or descriptives

Categorical variables (gender, major, site) always go in a frequency table. So do numeric ones with few values, like a 1 to 5 Likert item. But a variable with many distinct values, such as exact age or a scale’s total score, produces a huge and unhelpful table. For those, report descriptives: mean, standard deviation, minimum and maximum. Another option is to group them into ranges or levels with cutoffs and then tabulate the levels.

If your numeric data are skewed (income, for example), also report the median. The mean moves a lot with a few extreme values.

How to present it in APA 7

  • At the top, the table number in bold (Table 1) and below it the title in italics, for example: Distribution of Participants by Gender.
  • Only three horizontal lines: top, below the headers and bottom. No vertical lines.
  • Percentages with one decimal place.
  • A total row at the end and, if there were blanks, a note: Note. Six cases without a response are excluded.
  • You can combine several demographic variables in one table, with each variable’s name as a subheading.

How to write it up

The text doesn’t repeat the whole table: it highlights what matters. For example: “Of the 150 participants, 62.5% were women and the mean age was 21.3 years (SD = 2.3). Most were Psychology students (38.0%)”. For study variables, describe the predominant level: “46.7% of teachers showed a medium level of work stress”.

Build it in seconds

Copy the columns from Excel or Google Sheets, with names in the first row, and paste them into the calculator. You get an SPSS-style frequency table for each variable, descriptives for the numeric ones, APA tables in Word and a sentence for your thesis.

After describing the sample comes hypothesis testing:

Which statistical test to use in your thesis