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.

Note:

• 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.