Free Average Calculator
Paste a list of numbers to get the mean, median, sum, count, minimum and maximum.
Loading the editor…
How to use this tool
Paste numbers straight from a spreadsheet, a report or a list of post stats, separated by commas, spaces or new lines. The calculator returns the average (mean), the median, the sum and the count, plus the smallest and largest values, and shows how the average was worked out.
- 01
Paste your numbers
Separate them with commas, spaces, semicolons or new lines. Negative numbers and decimals with a dot are fine.
- 02
Read the results
The mean, median, sum, count, smallest and largest values update as you type.
- 03
Copy the summary
Press Copy to paste the figures and the calculation into a spreadsheet, report or message.
Mean and median
• Mean (the usual “average”) = sum of all values ÷ number of values. • Median = the middle value after sorting. With an even count it is the average of the two middle values. The mean uses every value, so one very large or small number pulls it a long way. The median ignores how extreme the outliers are, which makes it better for skewed data such as views per video.
Which one should you report?
If one viral post got 200,000 views and the rest got around 3,000, the mean views will look much higher than a typical post. Report the median for a “typical” result and the mean when you need totals to add up, such as average revenue per order. Showing both, as this calculator does, tells the full story.
Pasting numbers from spreadsheets
Copy a column from Excel or Google Sheets and paste it straight in; each cell lands on a new line. Commas are treated as separators, so write decimals with a dot (12.5) and remove thousands separators (1200, not 1,200).
Weighted averages
A simple average treats every value equally. If values have different weights, such as engagement rates from accounts with very different follower counts, multiply each value by its weight, add the results and divide by the sum of the weights. A weighted average often gives a fairer overall rate.
Frequently asked questions
How do I calculate the average?
Add all the numbers and divide by how many there are. For 12, 18 and 9: (12 + 18 + 9) ÷ 3 = 13.
What is the difference between mean and average?
In everyday use, average means the arithmetic mean. Median and mode are other kinds of average that describe the middle and the most common value.
How do I find the median?
Sort the numbers and take the middle one. With an even count, average the two middle numbers. The calculator does this for you.
How should I separate the numbers?
Use commas, spaces, semicolons or new lines, in any mix. A column pasted from a spreadsheet works too.
Why are my thousands numbers split?
Commas count as separators, so 1,200 becomes 1 and 200. Remove thousands separators before pasting.
Can I use negative numbers and decimals?
Yes. Enter negatives with a minus sign and decimals with a dot, such as −3.5.
How many numbers can I enter?
The box holds up to 4,000 characters, which fits several hundred numbers, plenty for a month of daily stats or a list of post views.
How do I calculate an average percentage?
If the percentages come from groups of different sizes, add the underlying counts and divide totals instead of averaging the percentages, or use a weighted average.
Are my numbers stored?
No. The calculation runs in your browser and nothing is sent to SocQ or saved.
Is the average calculator free?
Yes. It’s free with no signup and no limit.
For developers
Average metrics across many public posts
SocQ APIs return public posts from Instagram, TikTok, YouTube and LinkedIn with their views, likes and comments, so you can calculate mean and median performance for whole accounts without copying numbers by hand.
Keep working with free tools
View all tools- FREECalculator
Free Percentage Calculator
Work out X% of Y, what percent X is of Y, or the total when you know a part and its percentage.
- FREESocial Media
Free Average View Duration Calculator
Find how long a typical view lasts from total watch hours and views.
- FREECalculator
Free Percentage Change Calculator
Get the percentage increase or decrease between two values, plus the difference and the formula.
- FREESocial Media
Free Engagement Rate Calculator
Calculate engagement from your own statistics and copy the rate together with the exact formula.