XLSTAT - Descriptive Statistics

Tutorial
View a tutorial

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 Qualitative 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

Summary for the variables:

  • No. of categories
  • Mode
  • Mode frequency
  • Mode weight
  • % mode
  • Relative frequency of the mode

Statistics table for each category:

  • 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 variables Charts 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

XLSTAT

This analysis is available in the XLStat-Base addin for Microsoft Excel


About KCS

Kovach Computing Services (KCS) was founded in 1993 by Dr. Warren Kovach. The company specializes in the development and marketing of inexpensive and easy-to-use statistical software for scientists, as well as in data analysis consulting.

Mailing list Join our mailing list

Home | Order | MVSP | Oriana | XLStat
QDA Miner | Accent Composer | Stats Books
Stats Links | Anglesey

Share: FacebookFacebook TwitterTwitter RedditReddit
Del.icio.usDel.icio.us Stumble UponStumble Upon

 

Like us on Facebook

Get in Touch

  • Email:
    sales@kovcomp.com
  • Address:
    85 Nant y Felin
    Pentraeth, Isle of Anglesey
    LL75 8UY
    United Kingdom
  • Phone:
    (UK): 01248-450414
    (Intl.): +44-1248-450414