Top "Percentile" questions

In statistics, a percentile (or centile) is the value of a variable below which a certain percent of observations fall.

How do I calculate percentiles with python/numpy?

Is there a convenient way to calculate percentiles for a sequence or single-dimensional numpy array? I am looking for something …

python numpy statistics numpy-ndarray percentile
Calculating percentile of dataset column

A quick one for you, dearest R gurus: I'm doing an assignment and I've been asked, in this exercise, to …

r statistics percentile
nth percentile calculations in postgresql

I've been surprisingly unable to find an nth percentile function for postgresql. I am using this via mondrian olap tool …

function postgresql percentile
Eliminating all data over a given percentile

I have a pandas DataFrame called data with a column called ms. I want to eliminate all the rows where …

python pandas filtering percentile
matplotlib: disregard outliers when plotting

I'm plotting some data from various tests. Sometimes in a test I happen to have one outlier (say 0.1), while all …

python plot matplotlib percentile outliers
Map each list value to its corresponding percentile

I'd like to create a function that takes a (sorted) list as its argument and outputs a list containing each …

python numpy scipy median percentile
Calculating percentile rank in MySQL

I have a very big table of measurement data in MySQL and I need to compute the percentile rank for …

mysql rank percentile
Percentile calculation

I want to mimic the Excel equivalent PERCENTILE function in C# (or in some pseudo code). How can I do …

c# algorithm math percentile
Quartiles in SQL query

I have a very simple table like that: CREATE TABLE IF NOT EXISTS LuxLog ( Sensor TINYINT, Lux INT, PRIMARY KEY(…

mysql sql quantile percentile
Conditional array to calculate percentiles

I have some data as follows: val crit perc 0.415605498 1 perc1 0.475426007 1 perc1 0.418621318 1 perc1 0.51608229 1 perc1 0.452307882 1 perc1 0.496691416 1 perc1 0.402689126 1 perc1 0.494381345 1 perc1 0.532406777 1 perc1 0.839352016 2 perc2 0.618221702 2 perc2 0.83947033 2 …

arrays excel conditional percentile