Descriptive statistics (including Box plots and scattergrams)

Compute basic descriptive statistics and draw charts on a large number of variables optionally divided into subsamples with a few clicks in Excel.

A description of the sampling as well as an estimation of some statistics for the population is always useful to understand the distribution of the samples.

Available descriptive statistics in XLSTAT

XLSTAT provides the following statistics:

Quantitative data  
  • No. of values used
  • No. of values ignored
  • No. of min./max. value
  • % of min./max. value
  • Minimum/Maximum
  • 1st quartile
  • Median
  • 3rd quartile
  • Range: difference between the maximum and the minimum,
  • Sum of the weights (if any)
  • Total
  • Mean
  • Geometric mean
  • Harmonic mean
  • Kurtosis (Pearson), Skewness (Pearson)
  • Kurtosis, Skewness
  • CV (standard deviation/mean) 
  • Sample variance
  • Estimated variance
  • Standard deviation of a sample
  • Estimated standard deviation
  • Mean absolute deviation
  • Standard deviation of the mean

Qualitative data

Summary for the variables:Statistics table for each category
  • No. of categories
  • Mode
  • Mode frequency
  • Mode weight
  • % mode
  • Relative frequency of the mode
  • Frequency
  • Weight of the category
  • %: percentage of the category
  • Relative frequency of the category

Also some plots are very helpful to visualize the distribution.

Charts created for quantitative variablesCharts created for categorical variables
  • Box plots,
  • Scattergrams,
  • Strip plots,
  • Q-Q plots,
  • p-p plots,
  • Stem and leaf plots.
  • Bar charts
  • Pie charts
  • Double pie charts
  • Doughnuts
  • Stacked bars
  • Multiple bars