FREE MATH / DATA TOOL

Statistics Calculator

Calculate mean, median, mode, variance, standard deviation, quartiles, range, and IQR outliers from typed values or uploaded Excel, CSV, and TXT files.

Calculator Inputs

Choose how you want to analyze values

Count
Mean
Median
Std. Deviation

Detailed Results

Statistical summary

Data Quality

Outliers

Distribution Preview

Intro

This statistics calculator turns numeric datasets into clear summaries. You can paste values manually or upload Excel, CSV, and TXT files for fast column-based analysis.

How to use

  1. Choose Manual Values, Excel Upload, CSV Upload, or TXT Upload.
  2. Enter values or upload a supported file.
  3. For Excel or CSV files, select a numeric column.
  4. Choose Sample or Population variance.
  5. Click Analyze and review the dashboard.

What this calculator computes

The tool calculates count, sum, mean, median, mode, minimum, maximum, range, variance, standard deviation, Q1, Q3, IQR, lower fence, upper fence, and outliers.

Supported input formats

Manual and TXT values can be separated by commas, line breaks, or a mix of both. CSV files use the first row as headers. Excel files use the first row of the selected sheet as headers.

Manual values guide

Paste values like 12, 18, 20, 25 or place each number on its own line. Decimals and negative numbers are supported. Empty entries are ignored.

Excel and CSV column selection guide

After upload, the calculator scans columns and shows columns that contain numeric values. Numeric-looking text is converted to numbers, while blanks and non-numeric rows are reported in the data quality panel.

TXT file guide

TXT files work like manual input. Use comma-separated values, one value per line, or mixed formatting. The file is read for the current request only.

Formula explanations

Mean is the sum divided by count. Median is the middle value after sorting. Variance measures average squared distance from the mean. Standard deviation is the square root of variance.

Outlier detection explanation

Outliers use the IQR method: lower fence = Q1 - 1.5 × IQR and upper fence = Q3 + 1.5 × IQR. Values outside those fences are flagged as outliers.

Sample vs population standard deviation

Sample standard deviation divides variance by n - 1 and is useful when your values are a sample from a larger group. Population standard deviation divides by n and is used when your values are the full population.

FAQ

Can I use decimals? Yes, decimals and negative values are supported.

What happens to text values? They are ignored and counted in the data quality panel.

Are uploaded files stored? No. Files are read from the active request and are not permanently saved.