Average Calculator (Mean, Median, Mode & Range)
Compute arithmetic mean, median, mode, range, standard deviation, and variance instantly. Includes weighted average calculation, dynamic box-and-whisker plot visualizations, and step-by-step mathematical proofs.
Separate numbers by commas, spaces, or newlines.
Box-and-Whisker & Distribution Diagram
Statistical Summary Cheat-Sheet
Quick Answer & Key Statistical Formulas
Direct Answer: To calculate the average (arithmetic mean), add all numbers together and divide by the total count: Mean = (Σx) / n. The median is the middle value when sorted (or the average of the two middle values if count is even). The mode is the most repeated number. The range is maximum minus minimum. For example, for numbers [10, 20, 30, 40, 50]: Mean is 30, Median is 30, and Range is 40.
Comprehensive Guide to Descriptive Statistics
Descriptive statistics summarize and organize characteristics of a data set. Choosing the appropriate measure of central tendency (mean vs. median) and dispersion (range, variance, standard deviation) is crucial for honest data analysis and decision-making.
Arithmetic Mean (x̄)
The balance point of the dataset. Every value contributes equally to the total sum. Best used for symmetric distributions without extreme outliers (e.g. height of adult females, machine bolt diameters).
Median ($Q_2$)
The 50th percentile rank. Completely impervious to wild outliers. If Elon Musk walks into a diner, the mean net worth of customers skyrockets into billions, but the median net worth barely moves.
Mode & Multimodality
The most popular frequency peak. Datasets can be unimodal, bimodal (two peaks, like shoe sales by gender), multimodal, or have no mode if every observation is unique.
The Empirical Rule for Normal Bell Curves (68-95-99.7%)
For data that follows a Gaussian normal distribution, the standard deviation ($\sigma$ or $s$) predicts where values fall relative to the mean:
Spreadsheet Formulas (Microsoft Excel & Google Sheets)
| Metric | Formula Syntax | Notes |
|---|---|---|
| Mean (Average) | =AVERAGE(A1:A50) | Ignores blank cells and text strings |
| Median | =MEDIAN(A1:A50) | Computes the exact 50th percentile rank |
| Mode | =MODE.MULT(A1:A50) | Returns dynamic array for multiple modes |
| Sample Standard Deviation | =STDEV.S(A1:A50) | Uses Bessel's n-1 denominator correction |
| Population Standard Deviation | =STDEV.P(A1:A50) | Uses exact N denominator for entire populations |
| Weighted Average | =SUMPRODUCT(A1:A10, B1:B10) / SUM(B1:B10) | Where A is values and B is weights |
Frequently Asked Questions
What is the difference between Mean, Median, and Mode?
The Mean is the arithmetic sum of all values divided by the count. The Median is the physical middle value when the dataset is sorted in ascending order. The Mode is the value that occurs most frequently in the dataset.
When should you use the Median instead of the Mean?
Use the median when your dataset contains extreme outliers or is heavily skewed (such as household income, real estate home prices, or net worth). The mean is easily distorted by extreme values, whereas the median reflects the experience of the typical middle observation.
What is the difference between Sample and Population Standard Deviation?
Population standard deviation (σ) is used when you have measured every single member of a group (dividing sum of squared deviations by N). Sample standard deviation (s) applies Bessel's correction, dividing by n - 1 to correct for downward bias when estimating population parameters from a sample subset.
How do you calculate a weighted average?
Multiply each individual value by its corresponding weight, sum the resulting products, and then divide by the sum of all weights: Weighted Average = Σ(w × x) / Σw. This is standard for calculating course grades and investment portfolio returns.