Quantile - Percentile

Data System Architecture


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.

Response Time Percentile


## 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)")


Percentile Ggplot

Documentation / Reference

Discover More
Data System Architecture
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...
Card Puncher Data Processing
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 ...
Response Time Of System
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...
Data System Architecture
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...
Data System Architecture
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...
Data System Architecture
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
Data System Architecture
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....
Card Puncher Data Processing
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...
Analytic Function Process Order
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...
Thomas Bayes
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,...

Share this page:
Follow us:
Task Runner