XLSTAT - Quantiles

Quantiles and percentiles

Quantiles are defined by ordering data into q equally sized data subsets and noting the boundaries. The kth q-quantile for a random variable X is the value x such that the probability that the random variable will be less than x is at most k / q and the probability that the random variable will be more than x is at most (q − k) / q.

Let 0 < q < 1. The q-quantile of a variable X is given by:

P(X≤x)≥q and P(X≥x)≥1-q

There are q − 1 of the q-quantiles, one for each integer k satisfying 0 < k < q.

A percentile is a quantile based on a 0 to 100 scale.

XLSTAT quantile tool

XLSTAT quantile tool calculates quantiles and displays univariate plots for a set of quantitative variables. XLSTAT offers you five methods to calculate quantiles.

While you can select several samples at the same time, XLSTAT calculates all the descriptive statistics for each sample independently.

Quantiles are useful because they are less sensitive to outliers and skewed distributions.

Confidence interval for quantiles

You can obtain confidence intervals associated to the quantiles. Two intervals are available:

  • Confidence interval based on the normal distribution
  • Distribution free confidence interval

Additional available plots

In addition to the quantile plots, XLSTAT gives you the possibility to plot several charts:

  • Cumulative histogram
  • Box plot
  • Scattergrams: These univariate representations give an idea of the distribution and possible plurality of the modes of a sample. All points are represented together with the median.


This analysis is available in the XLStat-Basic 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


Like us on Facebook Facebook

Get in Touch

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