# Quantile - Percentile

A percentile is a 100-quantile.

For instance:

• A child whose height is in the 70th percentile is taller than 70% of the children of their same age.
• A 40th percentile would be a value in which 40% of the numbers are less than that observation.

## Example

``````## Add the percentile to the data.frame
res_succes\$percentile <- ecdf(res_succes\$TOTAL_TIME_SEC)(res_succes\$TOTAL_TIME_SEC)
## Plot it
ggplot(res_succes, aes(x=percentile*100, y=res_succes\$TOTAL_TIME_SEC, colour = factor(res_succes\$PRESENTATION_NAME))) +
geom_jitter(alpha = 0.5)
+ labs(x="Percentile",y="Total Time (Sec)")```
```

where:

## Documentation / Reference

Discover More
Distribution - Quantile Analysis

A quantile is a statistic that identifies the data that is less than the given value (ie that fall at or below a score in a distribution). A quantile function will always rank the data before giving any...
Oracle Database - Histogram Analytic

How to build an histogram in Oracle (and binning) You create equi-width (all bin have the same distance) histogram with the WIDTH_BUCKET function. where: column is a date or number column ...
Performance - (Latency|Response time|Running Time)

Latency is a performance metric also known as Response time. Latency (Response Time) is the amount of time take a system to process a request (ie to first response) from the outside or not, remote or...
Quantile - (Median|Middle)

The median is a measure of center. The middle number of a set of data is the median. This measure is resistant. The median is a 50th percentile (or “middle” quartile). Half of the data is below the...
Quantile - Functions

This page regroups all known quantile function. Specific Oracle function with Quantile. Oracle has also the ntile function. MEDIAN PERCENTILE_DISC (Oracle) is an inverse distribution function...
Quantile - Ntile (N Quantile)

Ntile (ie Nquantile) The Ntile function bins a data set in bucket of equal frequency. Each bucket has the same amount of observations. 4tile is a quartile 100tile is a percentile
Quantile - Quartile

A quartile is a specialized quantile. It divides the data into 4 approximately equal groups. The first and third quartile (or the 25th and 75th percentiles) are two very commonly used percentiles....
R - Summary

summary statistics function summary is a generic function used to produce result summaries of the results of various model fitting functions. The function invokes particular methods which depend...
SQL Function - Window Aggregate (Analytics function)

Windowing functions (known also as analytics) allow to compute: cumulative, moving, and aggregates. They are distinguished from ordinary SQL functions by the presence of an OVER clause. With...
Statistics - ( Spread | Variability ) of a sample

An important element of a data set is how it is spread. Variability is measure that describes the range and diversity of scores in a distribution Measures of spread: , inter-quartile range,...