How it works
Split the observed range into equal-width bins, using left-inclusive/right-exclusive intervals except that the last bin includes the maximum.
Input definitions
- Numeric observations
- Plain text; maximum 200,000 characters.
- Equal-width bin count (1–100)
- Enter the value in the labeled unit.
A worked example
- Numeric observations
- 1,2,3,4,5,6,7,8,9,10
- Equal-width bin count (1–100)
- 5
Assumptions & limits
At most 10,000 finite observations and 100 bins. Equal-width numeric bins, not categories or an automatic optimal bin rule.
Sources & review
Maintained by AnsRio. Methods and examples use automated checks; this does not imply independent professional certification.
Method updated 2026-10-17. Content checked against the stated method and examples. Our verification approach.
Common questions
Which bin contains a value exactly on a boundary?
Interior boundaries belong to the bin on their right. The maximum observation is included in the last bin. Identical observations are summarized as one zero-width bin.
How does Histogram bin and frequency table work?
Split the observed range into equal-width bins, using left-inclusive/right-exclusive intervals except that the last bin includes the maximum.
What are the limits of Histogram bin and frequency table?
At most 10,000 finite observations and 100 bins. Equal-width numeric bins, not categories or an automatic optimal bin rule.
How do I keep the full worksheet?
Run the tool and choose Download file. The on-page table is a preview and may show only the first 20 rows; the downloaded file contains the full result. CSV downloads escape spreadsheet formula prefixes. Inputs and files are processed on your device.