Stack Overflow
Stack Overflow

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
2
votes
2 answers

A replacement for qnorm?

I have this problem and I know that it can be carried out in several ways. Assume that the returns of a security X are distributed according to a normal law with mean m=0 and standard deviation s=5. What is the value at risk at 1 percent (i.e.,…
Wainer
  • 21
  • 1
2
votes
2 answers

How to remove top and bottom percentile values when both categorical and numerical columns exist in R

Consider data frame below df <- data.frame(a=c("Y", "Y","N", "Y", "N", "N"), b = c(200, 1,1.4,1.3,2,1.6), c = c(200,-200,10,12,14,15), d = c("f","f","m", "m","m","m")) a b c d 1 Y 200.0 …
Mathica
  • 1,241
  • 1
  • 5
  • 17
2
votes
1 answer

sql to find percentile by using a datetime or date column

Data: I have a table with the following 2 columns: id, and timestamp. A data example is shown below: id timestamp 1 2021-06-30 02:19:27.582 2 2021-06-25 03:20:23.324 3 2021-05-03 12:33:33.743 4 2021-07-20 23:04:42.105 ... Question: I want…
Counter10000
  • 525
  • 1
  • 8
  • 25
2
votes
1 answer

Finding the Top X percentile of values and combining all values below that percentile into an Others row per Group In R

I'm new to coding in R and I am having some trouble. I am trying to find the values in a column above a certain percentile (X%ile) per group, and then combining all rows below that percentile into a row others for every group. My situation is very…
Curious_Fish
  • 23
  • 5
2
votes
1 answer

Python - To create 2 new column with 25th and 75th percentile of several row values

Here is how my df kind of looks like (with many more rows, and many more columns): Index WTG1 WTG2 WTG3 1.5 61.25 -7.57 7.18 2 19.69 25.95 28.67 2.5 59.51 81.22 78.22 3 131.81 154.07 142.92 My objective is to…
Lolo
  • 23
  • 4
2
votes
2 answers

Return the 90th percentile values in R

For example, I have a dataset of 30-years air temperature of a city, the dataset looks like: Year Julian_date temperature 1991 1 2.1 1991 2 2.2 ... ... ... 1991 365 2.3 1992 1 …
Jellz
  • 435
  • 1
  • 7
  • 14
2
votes
2 answers

Create New Dataframe of Summary (90th Percentile) Statistics for Multiple Rows of All Columns in R

I am working on a school project and have a data set of 4,000 rows. There are 40 participants and each has about 100 rows. I want to create a data set that collapse the rows for each participant into summary statsitics, ideally the 90th percentile.…
keherder
  • 35
  • 5
2
votes
1 answer

How to make contour lines graph which colored only certain region?

I have a raster data and wants to make contour graph similar to the this question enter link description here. I got the code from here. But I want to highlight (colour) the regions which is above 75 percentile and remaining by the simple lines that…
Murray Schultz
  • 23
  • 4
2
votes
4 answers

Percentile rank over multiple partitions averages

Assume I have a table like this id cnt tier 1 100 gold 2 200 silver 3 300 bronze 4 400 bronze 5 500 bronze 6 600 gold 7 700 silver 8 800 silver 9 900 silver 10 1000 silver and if I want percentile rank over cnt within…
xiaolong
  • 3,396
  • 4
  • 31
  • 46
2
votes
1 answer

Calculated Percentile from Histogram Data Element in Anylogic

I have just started to use Anylogic / JAVA and have assembled a process flowchart with agent components. The model includes extracting Histogram Data from a number of locations throughout the flowchart. I'm aiming to get the x%th percentile value of…
Justin
  • 23
  • 3
2
votes
1 answer

Grouped percentile rank of value in rolling time window

In these sample data, users place orders of certain random values at random dates in time. I've successfully implemented a method to calculate the percentile rank of each value regarding the last 180 days of orders of that same user. However, for…
Pedro Schuller
  • 280
  • 1
  • 12
2
votes
3 answers

Map each value in list to a percentile, but where the lower values are better

So, I have a list with 25 scores, ranging from 60 to 500 lst= [60, 65, 89, 200, 220, 73, 340, 500.....65] The lower the score, the better the score. I want to assign each of these scores a percentile that shows which scores are the best/ which are…
srv_77
  • 547
  • 1
  • 8
  • 20
2
votes
1 answer

How to create percentiles in R using dplyr with data frame?

I am looking to create an additional column named "percentile", the percentile will be based off the sold quotes quotes and I do not want to create a window function on it, the percentile is should be based off the entire dataset. See below, the…
Jaskeil
  • 1,044
  • 12
  • 33
2
votes
2 answers

Weighted percentile calculation from group of percentiles

Can we calculate the overall kth percentile if we have kth percentile over 1 minute window for the same time period? The underlying data is not available. Only the kth percentile and count of underlying data is available. Are there any existing…
nishant
  • 955
  • 2
  • 11
  • 27
2
votes
1 answer

Ranking of one variable by weighted value of another variable?

Super R beginner here. I am trying to get rankings of a certain variable by weighted values of a another column/variable. For example, I have a dataset shown below: State <- rep(c("MN", "MN", "OR", "OR", "ME", "ME", "CO", "CO", "HI", "HI"), each =…
ayy__bee
  • 21
  • 2
1 2 3
…
49 50