Descriptive Statistics Calculator

Descriptive statistics calculator with customization options

Statistics

Tick the boxes next to the statistics you wish to calculate.

Options

Enter data in columns
Enter data from Excel
Enter frequency table
Header: you may rename 'Name-1', 'Name-2', etc.
Data: use Enter as delimiter; you may change the delimiters on 'More options'.

How to use the descriptive statistics calculator

Comprehensive descriptive statistics calculator for numerical data and categorical data. Calculates a variety of statistics, including minimum, mean, standard deviation, quartiles, IQR, number of observations and skewness. Insert one or more columns; the descriptive statistics calculator will calculate the statistics separately for each column.

Numerical data

Quantitative data, continuous variable or ordinal variable

Categorical data

Qualitative data, categorical variable

Choose the statistics that you want to present

Numerical data

  1. Number of observations - the number of valid values
  2. Minimum - the lowest value.
  3. Maximum - the highest value.
  4. Range - the distance between the minimum and the maximum.
  5. Mean (x̄) - the average.
  6. Sum - the cumulative total of all the values.
  7. Standard Deviation (S) - the sample standard deviation. Use it when you have only a sample data.
  8. Variance (S²) - the sample variance.
  9. Standard Deviation (σ) - the population standard deviation, use it when you have the entire population data.
  10. Variance (σ²) - the population variance, use it when you have the entire population data.
  11. Sum of squares - refers to the sum of the square distances of all the values from the mean.
  12. Q1- quartile 1, the 25th percentile.
  13. Median- quartile 2, the 50th percentile.
  14. Q3- quartile 3, the 75th percentile.
  15. IQR - InterQuartile Range - the different between Quartile 1 and Quartile 3.
  16. Skewness - the symmetrical level of the probability distribution
  17. Skewness shape - text description of the skewness and the p-value of the test for a difference from normal skewness.
  18. Excess kurtosis - the kurtosis difference from the normal distribution, the Kurtosis measured the level of the tails.
  19. Tails shape - text description of the kurtosis and the p-value of the test for a difference from normal kurtosis.
  20. Outliers - using the Tukey's Fences

Numerical data

Measurements
  1. Frequency per category - counting occurrences of each value.
  2. Proportion per category - the ratio of each value from all the values
  3. Percentage per category - the percentage of each value from all the values (100*ratio)
Statistics
  1. Number of observations - the number of valid values
  2. Minimum - the lowest frequency (or ratio or percentage) .
  3. Mode - the highest value frequency.
  4. Range - the distance between the minimum and the maximum (Mode).
  5. Mean (x̄) - the average frequency, including the empty values, values that appear only on other variables.

Should you exclude outliers?

It is important to exercise caution before excluding outliers from any calculation, as they may contain valuable information. However, excluding outliers from a histogram may significantly improve its visualization, even if the outliers are valid observations. If you choose to exclude outliers, the histogram maker will generate the chart without them. This method can create a more practical histogram that better represents the distribution of the majority of the data points.