Free Likert scale calculator
Paste answers, choose one or more columns of a CSV file, or enter counts per label. Answers can be numbers or labels such as “Agree”. Get the distribution, median, mode, mean, top 2 box and bottom 2 box of each statement, and a diverging stacked bar chart. No signup. All processing is in your browser.
Answer labels
Each label is read as the number of its point. Letter case and extra spaces do not matter. To give a point more than one label, separate the labels with a semicolon. Numbers such as 4, and text such as “4 - Agree”, are read as points automatically. When you change the scale, the labels go back to the default agreement labels.
Put one answer on each line. For more than one statement, copy the columns from a spreadsheet and paste them: each column is one statement. Row 1 can have the statement names.
Your browser reads the file on this device. Each statement is one column, with one row for each person.
Enter the number of answers for each point. The columns are the points of the scale, from 1 on the left. An empty field counts as 0.
Correct this input, then calculate again:
Your results
Summary of each statement
Count and percentage of each label
Labels that do not match
What this Likert scale calculator does
A Likert item is a statement that people rate on an ordered list of labels, usually from “Strongly disagree” to “Strongly agree”. This calculator takes the answers to one or more statements and gives the results for each statement: n, the count and percentage of each label, the median, the mode, the mean, the top 2 box and the bottom 2 box. It also draws a diverging stacked bar chart that you can download as a PNG or SVG file, and you can download the table as a CSV file. Your answers and files stay in your browser.
For examples of Likert statements, labels for other scale types and a worked example of how to read the results, read our guide Likert scale: definition, examples and how to read the results.
How the calculator reads your answers
Each answer becomes the number of its point on the scale. The calculator accepts three types of answer:
- A whole number from 1 to the number of points, for example 4.
- A label from the answer labels, for example “Agree” or “agree”.
- A number and a label, for example “4 - Agree” or “4. Agree”. The label must be the label of that number, or a label that is not in the answer labels.
These are the default agreement labels. You can change them in Answer labels, for example for a satisfaction scale.
| Point | 5-point scale | 7-point scale |
|---|---|---|
| 1 | Strongly disagree | Strongly disagree |
| 2 | Disagree | Disagree |
| 3 | Neither agree nor disagree; Neutral | Somewhat disagree |
| 4 | Agree | Neither agree nor disagree; Neutral |
| 5 | Strongly agree | Somewhat agree |
| 6 | Agree | |
| 7 | Strongly agree |
A blank cell is not an answer. The calculator counts blank cells separately. A cell with other text, or a number outside the scale, is not counted, and the calculator lists it with its row number.
How each result is calculated
n is the number of answers on the scale for one statement. Blank cells and cells that do not match are not in n. The percentage of each label is its count divided by n.
Median = the middle answer when the answers are in order. If n is even, the median is the mean of the two middle answers.
Mode = the point with the most answers. If two or more points have the same highest count, the calculator shows all of them.
Mean = the sum of the points of all answers ÷ n
Top 2 box = answers in the two highest points ÷ n × 100
Bottom 2 box = answers in the two lowest points ÷ n × 100
Worked example
10 people answer one statement on a 5-point agreement scale. The answers are 1 Strongly disagree, 2 Disagree, 2 Neither agree nor disagree, 3 Agree and 2 Strongly agree. Two other cells are blank.
- n = 1 + 2 + 2 + 3 + 2 = 10. The 2 blank cells are not in n.
- In order, the answers are 1, 2, 2, 3, 3, 4, 4, 4, 5, 5. n is even, so the median is the mean of answer 5 and answer 6: (3 + 4) ÷ 2 = 3.5, between Neither agree nor disagree and Agree.
- The mode is 4 (Agree), with 3 answers.
- Mean = (1 × 1 + 2 × 2 + 3 × 2 + 4 × 3 + 5 × 2) ÷ 10 = 33 ÷ 10 = 3.3
- Top 2 box = (3 + 2) ÷ 10 = 50%
- Bottom 2 box = (1 + 2) ÷ 10 = 30%
How to read the diverging stacked bar chart
Each bar is one statement, and each part of the bar is one label. The negative labels go to the left of the centre line, and the positive labels go to the right. On a 5-point or 7-point scale, the middle label is split in two halves on the line. A bar that goes far to the right shows strong agreement. A bar with long parts on both sides shows a statement that divides people, even when its mean is near the middle.
Compare the bars only when the statements use the same scale and the same labels.
How to use the calculator
- Select the scale: 5 points or 7 points. If your labels are not agreement labels, open Answer labels and change them.
- Choose the tab that matches your data: Paste, CSV file or Counts per label. For a CSV file, select the columns to use, one for each statement.
- Select Calculate. Read the chart and the tables. If cells do not match a label, the list shows each one with its row number. Add the missing labels and calculate again.
- Download the chart as PNG or SVG, or download the table as CSV.
Likert scale calculator FAQ
Should I report the median or the mean?
Likert answers are ordinal: the order of the labels is known, but the distance between two labels is not. For this reason, some experts have argued for the median. Gail Sullivan and Anthony Artino write that a frequency distribution of responses is likely more helpful than a mean. The calculator shows the median, the mean and the share of each label, so you can choose. If you use the mean, show it with the shares.
What is a top 2 box score?
It is the percentage of answers in the two highest points of the scale, for example Agree and Strongly agree on a 5-point agreement scale. The bottom 2 box score is the percentage in the two lowest points. Do not compare these scores between scales with different numbers of points, because the two highest points of a 7-point scale are a smaller part of the scale.
Why is my median 3.5?
When n is even, the median is the mean of the two middle answers. If the two middle answers are 3 and 4, the median is 3.5. The table shows the two labels, for example “between Neither agree nor disagree and Agree”.
What happens to blank cells and labels that do not match?
A blank cell is not an answer. The calculator counts blank cells in a separate column and does not put them in n. A cell that is not a number on the scale and not one of the answer labels is not counted. The calculator lists each of these cells with its statement and row number, so you can correct the labels.
Can I use a satisfaction, frequency or likelihood scale?
Yes. Open Answer labels and replace the agreement labels with your labels, for example from Very dissatisfied to Very satisfied. Put the most negative label on point 1. The top 2 box is then the two most positive labels.
Which CSV files can I use?
Use a text file with values separated by commas, semicolons or tabs, for example a response export from a form tool. If you use a spreadsheet, export the sheet as CSV first. Each statement must be one column, with one row for each person. A heading row is accepted, and the calculator uses the headings as statement names.
Is my data sent to a server?
No. The calculation and the chart run in your browser, and this page does not send or save your answers or files. The site uses Plausible analytics to count page visits. Plausible does not receive what you enter.
Do I need an account?
No. The calculator is free and needs no signup.