Summarise continuous data by single grouping variable

Input Values


Note: This page now accepts data where either a comma (,) or point (.) is used as the decimal separator.

This utility calculates summary statistics for a column of data, grouped by a category variable.

Inputs are the desired level of confidence in the estimate and two columns of data (including a header row with labels for each column). The first column is the category variable and the second is the continuous variable.

The program outputs a range of summary statistics relating to the data for each group in the category variable and overall.


  • for groups with 3 or less observations it is not possible to calculate Shapiro-Wilks W statistic to test for normality of distribution
  • for groups with only one observation or with standard deviation = 0 histograms and quantile plots are not shown.
  • missing values in the data will be omitted from calculations.
Confidence level:
Calculate percentages:
Calculate percentages:
Digits after decimal pt:
Paste the data to be summarised in the space below and click on submit (1st column is grouping variable, second column is data):
Download example data


  Home  |   About this site  |   Glossary   |   References   |   Links  

This site was created by Ausvet with funding from a range of sources.
It provides a range of epidemiological tools for the use of researchers and epidemiologists, particularly in animal health.
Please send any comments, questions or suggestions to Evan Sergeant
© 2019 Ausvet