NEW
A tabular summary listing categories or intervals alongside their counts to describe how data values are distributed.
DESCRIPTION
A frequency table organizes counts across discrete values or numeric bins. It provides a foundation for descriptive statistics and quality checks. Relative frequencies and cumulative counts enhance interpretation. Frequency tables inform histograms, bar charts, and crosstabs. Proper bin selection impacts insights from continuous variables. They support profiling and anomaly detection in data pipelines. Statistical summaries (mode, median) often reference frequency structures. Clear labeling and completeness ensure usability.
ALTERNATIVE DEFINITIONS
Wikipedia
In statistics, a frequency distribution is a summary of how often different values occur, organized into a table or graph.
Introduces tabular and graphical summaries of frequencies.
LibreTexts
A frequency table lists categories or intervals and the number of observations in each.
Defines structure of categories/intervals and counts.
Penn State Eberly College of Science
A frequency table is an organized display of counts for each value or class of data.
Emphasizes organized display and class/grouping.
RELATED TERMS
Frequency Distribution Pivot Table Descriptive Statistics Relative Frequency Class Interval Mode Data Profiling
COMPETING TERMS
RELATIONS
- Broader: Table
KNOWLEDGE AREAS
Data Science Data Visualization Data Quality
TARGET AUDIENCE
Data Analyst BI Specialist Data Scientist
EXTERNAL SOURCES
- Wikipedia - Frequency distribution
- LibreTexts - Intro to frequency tables and graphs
- Penn State - Lesson on frequency tables
- NIST/SEMATECH - E-Handbook frequency distributions
TOP QUESTIONS
What is a Frequency Table in statistics?
It’s a table showing counts for each category or bin, summarizing how data values are distributed.
Category: Overview
How does a Frequency Table relate to histograms?
Histograms visualize binned counts from a frequency table, making distributions easy to inspect.
Category: Misunderstanding
What are common mistakes with Frequency Tables?
Poor binning, missing categories, and inconsistent counts can misrepresent distributions.
Category: Mistakes
Why use relative and cumulative frequency?
They normalize counts and show accumulation across bins, aiding comparison and interpretation.
Category: Relevancy
How to select bins for continuous data?
Consider data range, variability, domain context, and use rules like Sturges or Freedman–Diaconis.
Category: Requirements
What risks occur with small sample frequency tables?
Sparse counts can suggest misleading patterns. Aggregate or collect more data before conclusions.
Category: Risks
Where are Frequency Tables used in data pipelines?
In profiling, anomaly detection, and quality checks, they help identify outliers and distribution shifts.
Category: Example
How do Frequency Tables support BI reporting?
They underpin crosstabs and pivot tables, providing clear metrics for categories.
Category: Example
What is a hot topic around Frequency Tables?
Automated profiling with data quality tools that generate tables and rules programmatically.
Category: Topic