Open Qstat
Charts
StatisticsDescriptive Statistics
Qstat Desktop
English

Descriptive Statistics Calculator

Summarize several columns at once. 16 descriptive statistics are shown side by side for each column (or group), and the center, spread and shape of the distribution are interpreted in plain sentences.

1Data Table

Paste a table copied from Excel into a cell (Ctrl+V). Click a column header (A, B…) before pasting to use the first line as column names. Double-click a header to rename it, right-click to insert/delete rows and columns, and formulas such as =A1*2 work too.

2Descriptive Statistics Options

Select the columns to describe (multiple allowed):

How to calculate descriptive statistics

  1. Copy the measurement columns to summarize (and a group column if needed) together with the header.
  2. Click the column header (A) in the data table and paste - the first line becomes the column name. You can also open a CSV or Excel file.
  3. Select the columns to describe, and a group column to split the results by group.
  4. Press Analyze and check the table and interpretation. Right-click the table to copy it for pasting into Excel.

Statistics calculated

N (valid values), number of missing values, mean, median, mode, standard deviation, variance, minimum, maximum, Q1 (first quartile), Q3 (third quartile), IQR, coefficient of variation CV (%), skewness, kurtosis and the 95% confidence interval of the mean.

The standard deviation and variance are sample statistics (divided by n-1), quartiles use linear interpolation, skewness and kurtosis are moment-based (kurtosis is 0 for a normal distribution), and the confidence interval uses the t distribution. The mode is the most frequent value, or the smallest value when every value occurs once.

Missing values and groups

Non-numeric or blank cells are counted as missing and excluded (up to the last data row of the column). With a group column, the statistics are calculated separately for each 'column (group)' and placed side by side in one table.

How to read descriptive statistics

  • The interpretation reports the mean and standard deviation of each column (group) and calls the distribution skewed to the right/left when the absolute skewness exceeds 1.
  • With two or more, it compares the highest and lowest means and the ratio of their standard deviations.
  • The coefficient of variation (CV) is the spread relative to the mean, useful for comparing data measured in different units.

Frequently asked questions

Is the standard deviation divided by n or n-1?

The sample standard deviation (n-1) is used, the same as Excel's STDEV.S.

Can I move the results to Excel?

Yes. Right-click the result table and choose 'Copy table (paste into Excel)' to paste it with the cells split.

My kurtosis is negative.

It is excess kurtosis (0 for a normal distribution), so a negative value means lighter tails and a flatter shape than normal.

Is my data sent to a server?

No. All calculations run inside your browser and nothing is transmitted or stored.

Other chart tools

Normality Test (Anderson-Darling)Test for normality with the Anderson-Darling A², p-value and a histogram.Confidence Interval CalculatorCalculate the confidence interval of the mean and change the level instantly.Box Plot MakerCompare medians, quartiles and outliers of several groups side by side.

Need process capability, control charts or DOE?

The Qstat desktop program offers about 250 analysis features: histograms and box plots plus process capability (Cp, Cpk), control charts, measurement system analysis (MSA), design of experiments (DOE), regression and machine learning.

Try Qstat free for 30 days