Questions tagged [percentile]

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

A closely related concept is "quantile". See .

739 questions
-3
votes
1 answer

Formula: PERCENTRANK IF

I have a date column and a column that states "Include" or "Don't Include." I want to calculate the Percentile of each row in my data set given that they are marked to be included. Any thoughts on how to group them?
RCarmody
  • 712
  • 1
  • 12
  • 29
-3
votes
1 answer

How to implement percentile in Hive?

Can anyone please tell me ,how to implement Percentile in Hive? I tried with percentile function,but not able to get the expected result. Example code will greatly help.
Shan
  • 1
  • 1
  • 1
-4
votes
1 answer

Calculating percentile ranks of the last element of each column in a dataframe in Python

I have a DataFrame df. This dataframe has 1000 rows and 20 columns. Rows are dates and 20 columns are different shares. This is 1000 dates of stock prices from old to new (last row is todays price). I want to calculate for each column, the…
Mohit
  • 3
  • 3
-5
votes
2 answers

How to get percentile in java

I have a list where I want to get percentile. HashMap test=new HashMap(); test.put(100,"Amit"); test.put(101,"Vijay"); test.put(102,"Rahul"); test.put(103,"Amit"); test.put(104,"Vijay"); …
Shakti Sharma
  • 2,131
  • 3
  • 18
  • 23
1 2 3
49
50