Descriptive Statistics Calculator: Mean, Median, SD, Quartiles and More
Paste a column from Excel and instantly get every summary statistic you need for a thesis table, plus a histogram and a box plot you can download.
- PriceFree, no login or sign-up needed
- Your dataProcessed in your browser, never uploaded
- Works onPhone, tablet or computer, any modern browser
- Made byDr. Muhammad Aammar Tufail, Codanics
- Published14 November 2026
- Last updated16 November 2026
📚 How to cite this tool
This tool is free. If it helped your thesis, paper, report or assignment, please cite it. It keeps the tools free and helps other students find them.
Tufail, M. A. (2026). Descriptive statistics calculator [Online tool]. Codanics. Retrieved 16 November 2026, from https://codanics.com/tools/descriptive-statistics-calculator/
In-text citation: (Tufail, 2026) · Narrative: Tufail (2026)
The access date is today’s date, filled in automatically. Author: Muhammad Aammar Tufail. Published 14 November 2026.
How to use the descriptive statistics calculator
- Paste your numbers into the box, or use Paste from Excel or Upload CSV / Excel to pick a column from your spreadsheet. Example data is loaded so you can see how it works.
- Optionally type the variable name, which is used in the summary sentence and chart labels.
- Click Calculate to see the full summary table, a histogram and a box plot.
- Copy the table into Excel, copy the sentence into your results, or download the charts as PNG or SVG.
What each statistic tells you
| Statistic | What it means | When to report it |
|---|---|---|
| Mean and SD | The average and how spread out values are around it | Roughly symmetric data without strong outliers |
| Median and IQR | The middle value and the range of the middle 50% | Skewed data, or data with outliers |
| Standard error (SE) | How precisely the sample mean estimates the population mean | Error bars and confidence intervals, not for describing spread |
| Skewness | Asymmetry: positive means a long right tail | Checking normality before a t-test or ANOVA |
| Kurtosis (excess) | Heavy (> 0) or light (< 0) tails compared with a normal curve | Checking normality |
Formulas used
Frequently asked questions
What is the difference between sample and population standard deviation?
The sample SD divides by n − 1 and is what you almost always want when your data are a sample from a larger population. The population SD divides by n and is only correct when you have measured every member of the population.
Why do my quartiles differ from SPSS?
There are several ways to calculate quartiles. This tool uses linear interpolation (R’s default and Excel’s QUARTILE.INC). SPSS uses a weighted average method, so small differences are normal, especially with small samples.
How do I know if my data are normally distributed?
Look at the histogram and the skewness and kurtosis values. Values of skewness between about −1 and +1 are usually acceptable for t-tests and ANOVA. For a formal test, use Shapiro–Wilk in R, SPSS or JASP.
What should I do with outliers?
First check whether they are data entry errors. If they are real, keep them and consider reporting the median and IQR, or run the analysis with and without them (a sensitivity analysis). Never delete outliers just because they make results look worse.
Can I paste data from Excel or upload a file?
Yes. Copy a column in Excel and paste it into the box, or click Paste from Excel or Upload CSV / Excel to load a whole sheet and choose the column. Files are read in your browser and are never uploaded or stored.
Is my data private?
Yes. Calculations happen in your browser, and nothing is uploaded.
Do I need to log in or create an account to use the descriptive statistics calculator?
No. There is no login, no sign-up and no email required. Open the page and start using it straight away, for free, on any device.
How do I cite this tool in my thesis or paper?
Use the citation box on this page. In APA 7th edition: Tufail, M. A. (2026). Descriptive statistics calculator [Online tool]. Codanics. Retrieved [date you used it], from https://codanics.com/tools/descriptive-statistics-calculator/. BibTeX, RIS (EndNote, Mendeley, Zotero), MLA, Harvard, Chicago and Vancouver formats are also available.
Free guides and courses from Codanics
More free tools
See all free Codanics tools → · Codanics on YouTube · WhatsApp channel

