Free Tally Chart Maker and Frequency Table Generator
This tally chart maker draws every mark in groups of five and builds the frequency tables that go with them: relative and cumulative frequency, grouped classes with boundaries and midpoints, the mean read from the table, and blank tally sheets to print. For math class, field counts and lab surveys.
One category and its count per line, separated by a comma, tab or semicolon. Paste two columns from Excel or Google Sheets into the tally chart maker; a heading row is skipped.
The tally chart maker read 5 categories, 40 observations.
The tally chart maker runs in your browser: no sign-in, no upload, free to download.
Relative frequency is frequency ÷ n, so House sparrow is 12 ÷ 40 = 0.300. Cumulative frequency adds each row to the rows above it and ends at n = 40.
Tally chart styles
Four finishes from the AI tally chart generator, each on its own count from the tally chart maker: travel to school as an anchor chart, 60 dice rolls as a worksheet, eye colour with icons, and birds at a feeder in a field notebook. Take a card to load the prompt that drew it.
Tally chart examples
Six tally chart examples from the AI tally chart generator: an anchor chart of travel to school, a dice-roll frequency table, eye colour with icons, a bird count in a field notebook, a tally chart beside its bar graph and a grouped frequency table of pulse rates. Each card holds the prompt that drew it, with counts taken from the tally chart maker.
An anchor chart from the tally chart maker's counts.
A worksheet table with the tally chart maker's relative frequencies.
Icons beside each row, tallies as the tally chart maker counts them.
A one-hour bird count from the tally chart maker in a field notebook.
The tally chart maker's counts as tally marks and as bars.
Classes and midpoints, as the Grouped tab of this frequency table maker builds them.
What is a tally chart?
A tally chart is a table that counts how often each category occurs by drawing one stroke per observation, with every fifth stroke drawn across the four before it, and then writes each count as a number in a frequency column. Add relative and cumulative frequency columns and the same table is a frequency table, the summary statistics courses build every later chart from.
About this tally chart maker
- The tally chart maker reads one category and its count per line, or counts a pasted raw list of words or numbers for you.
- The tally chart maker draws every tally in groups of five, as five-bar gates or as the 正 character, and the strokes in each row always equal its frequency.
- The tally chart maker adds relative frequency, percent, cumulative frequency and cumulative relative frequency columns beside the tally.
- The tally chart maker's Grouped frequency table tab sorts numbers into classes by Sturges' rule, a number of classes or a class width, with boundaries and midpoints.
- The tally chart maker's summary gives the mode, and for numeric data the mean and median read from the frequency table, with the working shown.
- Tally charts, frequency tables and blank tally sheets from the tally chart maker download as PNG, SVG or PDF, print, or copy into Excel, with no sign-in.
How to draw tally marks in groups of five
Draw one upright stroke for each observation, and draw every fifth stroke diagonally across the four before it, so the strokes close into a group of five called a five-bar gate. Reading a tally is then counting gates in fives and adding the strokes left over: three gates and two strokes make 17. The tally chart maker draws every row this way, and the stroke count in each row always matches the number in its frequency column.
Five-bar gate
Four upright strokes, the fifth across them. The usual tally in English-speaking schools, and the default in the tally chart maker.
正, used in China, Japan and Korea
Tallies there form the character 正, which has five strokes, so one finished character means five. A partial character shows how many of its strokes are written: 3 is the top bar, the centre stroke and the short middle bar. Pick 正 under Tally marks in the tally chart maker.
Dot and line, used in forestry
Dots count 1 to 4 at the corners of a square, lines join them for 5 to 8, and two diagonals make 9 and 10, so each finished box is ten. The tally chart maker does not draw this one.
How to make a tally chart and frequency table
- 1
Enter the data in the tally chart maker
Type one category, count per line, such as Bus, 15, or switch to Raw list to count and paste the observations themselves (bus, walk, bus, car…). The tally chart maker merges spellings that differ only in capitals and counts each category.
- 2
Check each tally in the tally chart maker against the total
The tally chart maker draws each row's tally in groups of five, so 12 reads as two crossed gates and two strokes. The frequencies must add up to n, the number of observations, which the Total row prints.
- 3
Add relative and cumulative frequency in the tally chart maker
In the tally chart maker, turn on Relative frequency to divide each count by n, Percent to multiply that by 100, and Cumulative frequency to add each row to the rows above it. The last cumulative frequency equals n.
- 4
Download or print from the tally chart maker
Save the tally chart as PNG, SVG or PDF, print it, or copy the columns into Excel. The Grouped frequency table and Blank tally sheet tabs download the same way.
How do you find relative and cumulative frequency?
Relative frequency is a category's frequency divided by the total number of observations; cumulative frequency is the running total of the frequencies down the table. OpenStax defines cumulative relative frequency as the accumulation of the relative frequencies, so its last entry is 1, the whole data set.
- Relative frequency = frequency ÷ n
- Percent = relative frequency × 100
- Cumulative frequency = this row's frequency + every row above it
- Cumulative relative frequency = cumulative frequency ÷ n
Worked example in the tally chart maker, 60 rolls of a die
A fair die lands on each face about one time in six, a relative frequency near 0.167. Sixty rolls gave the counts in the table, and the tally chart maker worked out every other column from those six numbers: face 4 came up 12 times, 12 ÷ 60 = 0.200, and by face 4 the cumulative frequency is 9 + 11 + 8 + 12 = 40 of the 60 rolls.
Why a relative frequency column can add to 0.999 or 1.001. Each row is rounded on its own, so the rounding errors pile up: the pulse table below adds to 0.999 because 4 ÷ 30 = 0.1333 appears twice and rounds down both times. The tally chart maker prints the real sum in the Total row and says why; tick Make relative frequencies add to exactly 1 and it moves the rounding by at most one unit in the last decimal place so the column adds to 1.000, at the cost of two equal counts sometimes printing different values.
How to make a grouped frequency table with class width and boundaries
When the data hold too many different values to tally one by one, group them into equal classes: take about k = ⌈log₂ n⌉ + 1 classes (Sturges' rule), divide the range by k and round up to a convenient class width, then tally each value into its class. Here are the steps for the resting pulse of 30 students, the Pulse preset of the tally chart maker's Grouped frequency table tab.
- 1
Find the range
The 30 pulse rates run from 60 to 88 bpm, so the range is 88 − 60 = 28. The tally chart maker reports both ends as soon as the values are pasted.
- 2
Choose the number of classes
Sturges' rule gives k = ⌈log₂ 30⌉ + 1 = 5 + 1 = 6 classes. Statistics courses accept anything from about 5 to 15; fewer hides the shape, more leaves classes nearly empty. The tally chart maker uses this rule unless you give a number of classes or a width.
- 3
Work out the class width
Whole numbers need classes that cover range + 1 values, here 29. 29 ÷ 6 = 4.83, rounded up to a convenient width of 5, so the classes are 60–64, 65–69 and so on to 85–89. The tally chart maker rounds the same way under Sturges' rule.
- 4
Write the boundaries and midpoints
Class limits are the smallest and largest values a class can hold, 60 and 64. Class boundaries sit halfway between one class's upper limit and the next class's lower limit, 64.5, so the classes meet without gaps. The midpoint is (60 + 64) ÷ 2 = 62. The tally chart maker prints both columns.
- 5
Tally each value, then count
Tally the 30 pulse rates into their classes and write the frequencies 3, 4, 6, 12, 4 and 1. They add up to 30, the number of students; the tally chart maker does this step as soon as the numbers are pasted.
UK exam papers write the same classes as 60 ≤ p < 65, 65 ≤ p < 70: no gaps between classes, so the boundaries are the class ends themselves and the midpoint of the first class is 62.5. Switch Class notation to Intervals in the tally chart maker to get that form.
The bars of a histogram stand on exactly these boundaries. Send the table from the tally chart maker to the histogram maker with the button and it arrives as classes with their counts, 60–64: 3, 65–69: 4, ready to draw.
How to find the mean, median and mode from a frequency table
Mean = Σ(x × f) ÷ n, where x is each value and f its frequency; the median is the value in position (n + 1) ÷ 2, found by reading down the cumulative frequency column; the mode is the value with the highest frequency. The tally chart maker works all three out whenever every category is a number, and shows the arithmetic under the table.
Siblings of 25 students in the tally chart maker
| Number of siblings (x) | Frequency (f) | x × f | Cumulative frequency |
|---|---|---|---|
| 0 | 5 | 0 | 5 |
| 1 | 9 | 9 | 14 |
| 2 | 7 | 14 | 21 |
| 3 | 3 | 9 | 24 |
| 4 | 1 | 4 | 25 |
| Total | 25 | 36 |
Mean. Σ(x × f) = 0 + 9 + 14 + 9 + 4 = 36, and 36 ÷ 25 = 1.44 siblings, the Mean in the tally chart maker's summary.
Median. With n = 25 the median is the 13th value. The cumulative frequencies run 5, 14, 21…, so the 6th to 14th values are all 1, and the median is 1, as the tally chart maker reports.
Mode. 1 sibling, the highest frequency at 9, which the tally chart maker lists as the mode.
Grouped data use the midpoints
The mean of a grouped frequency table is an estimate, because every value in a class is counted as if it sat on the midpoint. For the pulse table, Σ(f × midpoint) = 3 × 62 + 4 × 67 + 6 × 72 + 12 × 77 + 4 × 82 + 1 × 87 = 2,225, and 2,225 ÷ 30 = 74.17 bpm; the 30 raw values average 74.2. The 15th and 16th values both fall in 75–79, so that is the median class, and with 12 students it is also the modal class. The tally chart maker prints the same estimate and both classes under a grouped table.
Frequency table worksheet questions with answers
Five questions written the way statistics worksheets and homework sets ask them. Each answer is worked; load the data into the tally chart maker to check the table.
1.A frequency table of grades has five classes: A 6, B 11, C 14, D 5 and F 4. What is the relative frequency of grade C, and what fraction of the class got a C or better?
Show the answer
The relative frequency of C is 14 ÷ 40 = 0.350. n is 6 + 11 + 14 + 5 + 4 = 40, the Total row of the tally chart maker. A C or better is the cumulative frequency through C, 6 + 11 + 14 = 31, so the cumulative relative frequency is 31 ÷ 40 = 0.775.
2.Complete the relative frequency table below for how 40 students travel to school: walk 9, bus 15, car 12, bike 4.
Show the answer
Divide each frequency by 40: walk 0.225, bus 0.375, car 0.300, bike 0.100. The column adds to exactly 1.000 because every count divides by 40 without rounding, which the Total row of the tally chart maker confirms.
3.The frequency table shows the results of a survey of 50 students' favourite fruit: apple 14, banana ?, grapes 9, orange 7, strawberry 12. How many chose banana, and what percent is that?
Show the answer
Banana is 50 − (14 + 9 + 7 + 12) = 50 − 42 = 8 students, which is 8 ÷ 50 = 0.16, or 16%. Check in the tally chart maker: the frequencies now add to 50.
4.Make a grouped frequency table with a class width of 10 for these 20 test scores: 58, 72, 85, 91, 67, 74, 63, 88, 79, 55, 70, 82, 76, 69, 94, 61, 73, 84, 77, 66. Which is the modal class, and what is the estimated mean?
Show the answer
The classes are 50–59: 2, 60–69: 5, 70–79: 7, 80–89: 4 and 90–99: 2, so the modal class is 70–79. The midpoints are 54.5, 64.5, 74.5, 84.5 and 94.5, so Σ(f × midpoint) = 109 + 322.5 + 521.5 + 338 + 189 = 1,480 and the estimated mean is 1,480 ÷ 20 = 74. The 20 raw scores average 74.2: grouping loses a little detail. Load the scores to see the tally chart maker's grouped table with these midpoints.
5.What number does this tally show?
Show the answer
18: three groups of five are 15, and three single strokes make 18. Count the crossed gates first, then the strokes after them, as in every row of the tally chart maker.
Tally chart vs frequency table vs bar graph
A tally chart records counts while data are being collected, a frequency table states the finished counts as numbers with their relative and cumulative frequencies, and a bar graph shows the same counts as bars for readers to compare. In the tally chart maker the first two are one table: the tally column next to the frequency columns.
| Tally chart | Frequency table | Bar graph | |
|---|---|---|---|
| Counts written as | Strokes in groups of five | Numbers in a column | Bar heights on an axis |
| When it is used | While observations come in | Once counting is finished | When the counts are shown to others |
| Usual columns | Category, tally, frequency | Category or class, frequency, relative and cumulative frequency | One bar per category on an axis from 0 |
| Total read by | Counting gates of five | The Total row, n | Adding the bar heights |
| Grouped numbers | One row per class | Classes with boundaries and midpoints | A histogram, bars touching |
| Made here with | The tally chart maker | The tally chart maker, frequency columns on | The bar graph maker |
Two more ways to show the same counts: a dot plot stacks one dot per value over a number line, and a stem and leaf plot sorts numbers into rows while keeping every digit. Send a finished tally chart to the bar graph maker with the button under the tally chart maker's figure.
Frequency table maker vs Excel and Google Sheets
Excel and Google Sheets count categories with COUNTIF and classes with FREQUENCY, but neither draws tally marks or writes the relative and cumulative columns for you. The steps below make the frequency table in a spreadsheet; the tally chart maker does it from the same pasted column.
How to make a frequency table in Excel
- 1
List each category once in column D and enter =COUNTIF(A:A, D2) beside the first one, then fill it down; the counts are the frequency column the tally chart maker writes for you.
- 2
For numbers in classes, type each class's upper limit in a column and enter =FREQUENCY(A2:A31, F2:F7). Microsoft 365 fills the results in one step; older versions need Ctrl+Shift+Enter. The extra last value counts anything above the top class.
- 3
Divide each frequency by the total for relative frequency, and add each row to the cell above for cumulative frequency; the tally chart maker switches both columns on in one click.
In Google Sheets
- 1
=COUNTIF(A:A, D2) works as in Excel for categories.
- 2
=FREQUENCY(A2:A31, F2:F7) returns the class counts, plus one more for values above the last limit.
- 3
Insert a pivot table with the column as Rows and COUNTA as Values to count every category at once, or paste the column into the tally chart maker's Raw list.
| This tally chart maker | Excel | Google Sheets | |
|---|---|---|---|
| Tally marks | Drawn in fives or as 正 | Not built in | Not built in |
| Counting a raw list | Paste it; categories found and counted | COUNTIF per category, or a PivotTable | COUNTIF per category, or a pivot table |
| Relative and cumulative frequency | Switch the columns on | Your own formulas | Your own formulas |
| Grouped classes | Sturges' rule, a class count or a width | FREQUENCY with the upper limits you type | FREQUENCY with the upper limits you type |
| Output | PNG, SVG, PDF, print, Copy for Excel | Workbook | Spreadsheet |
Copy for Excel in the tally chart maker puts the whole frequency table on the clipboard as tab-separated columns, so it pastes into Excel or Google Sheets cell by cell.
Tally chart maker FAQ
What is the difference between a tally chart and a frequency table?+
A tally chart records each observation as a stroke while counting; a frequency table writes the finished counts as numbers, often with relative and cumulative frequency. Most school tally charts already carry a frequency column, which is why the tally chart maker draws both in one table; switch the tally column off and it works as a frequency table maker.
Why are tally marks grouped in fives?+
Groups of five can be counted at a glance, where a long row of single strokes has to be counted one by one. The fifth stroke crosses the four before it, so 23 reads as four gates and three strokes. The tally chart maker draws every tally that way, or as the 正 character, five strokes to a group.
Can the tally chart maker count a list for me?+
Yes. Switch to Raw list to count and paste the observations, separated by commas, new lines or spaces. The tally chart maker finds each category, merges spellings that differ only in capitals (Dog, dog), counts them and draws the tally. A column of numbers pasted from a spreadsheet is counted by value.
How do you find relative frequency?+
Divide each frequency by the total number of observations: 12 birds out of 40 is 12 ÷ 40 = 0.300, or 30%. The relative frequencies of a table add to 1, though rounding each row can leave 0.999 or 1.001. The tally chart maker prints the real sum in the Total row.
What does cumulative frequency tell you?+
How many observations fall in a row or any row above it, so the last cumulative frequency is n. In a grouped frequency table it answers questions such as how many students have a pulse below 75 bpm (13 of 30 in the pulse table), and it locates the median class: the first class whose cumulative frequency reaches n ÷ 2. The tally chart maker's Cumulative frequency column shows both.
How many classes should a grouped frequency table have?+
About ⌈log₂ n⌉ + 1, Sturges' rule: 6 classes for 30 values, 7 for 40 to 64, 8 for 65 to 128. Round the class width up to a convenient number so the classes cover the whole range. The tally chart maker uses Sturges' rule unless you give a number of classes or a class width.
How do you find the mean from a frequency table?+
Multiply each value by its frequency, add the products and divide by n: Σ(x × f) ÷ n. For grouped data use each class midpoint as x, which gives an estimate. The tally chart maker shows this working under any table whose categories are numbers.
How do you turn a tally chart into a bar graph?+
Draw one bar per category as tall as its frequency, on an axis that starts at 0, with gaps between the bars. In the tally chart maker, the Draw as a bar graph button sends the categories and counts to the bar graph maker, which draws them.
What is a two-way frequency table?+
A table that counts two categorical variables at once, one in the rows and one in the columns, with each cell holding the count for that pair. Its relative frequencies can be taken of the grand total, of each row or of each column. The tally chart maker counts one variable at a time; for two, count each pair as one category (Year 7 boys, Year 7 girls).
Is the tally chart maker free, and can I print a blank tally sheet?+
Yes. The tally chart maker runs in your browser with no sign-in, and the Blank tally sheet tab prints a recording sheet with the categories filled in and empty tally and frequency columns. Add empty rows for categories you expect to meet, and a name and date line for a class or a field survey.
Sources
- Tally marks — Wikipedia
- 1.3 Frequency, Frequency Tables, and Levels of Measurement — OpenStax, Introductory Statistics 2e
- The Choice of a Class Interval, J Am Stat Assoc 21:65–66 (1926) — Sturges HA
- FREQUENCY function — Microsoft Support
Keep exploring
Our other diagram tools, and the guides behind them.
Count your data in the tally chart maker
The tally chart maker draws tally marks in fives and every frequency column from your own data, free in the browser, or the same counts as an anchor chart, worksheet or notebook page from the AI tally chart generator.
Back to the tally chart maker