Questions tagged [quartile]

Quartiles are the values that divide a list of numbers into quarters.

Quartiles are the values that divide a list of numbers into quarters.

Further reference: https://www.mathsisfun.com/data/quartiles.html

115 questions
0
votes
1 answer

unique breaks error in calculation of quantiles of a data frame in r

I have a dataframe as follows: AA BB CC DD a name1 59.67 45.9 56.64 b name2 0 0 0.3 c name3 7.14 0 0.55000000000000004 I am using dplyr package and I would…
say.ff
  • 373
  • 1
  • 7
  • 21
0
votes
1 answer

excel function to vba code (exclusive quartile & if function)

I am trying to get this piece of excel function into vba code (mainly because there is no such thing as "application.worksheetfunction.if" - would be great if i can get some help here! =quartile.exc(if((F:F=F2)*(Y:Y=1),I:I),1) basically, i wanted…
yuuyuu
  • 15
  • 4
0
votes
1 answer

Multiple IF QUARTILEs returning wrong values

I am using a nested IF statement within a Quartile wrapper, and it only kind of works, for the most part because it's returning values that are slightly off from what I would have expected if I calculate the range of values manually. I've looked…
Youl
  • 13
  • 3
0
votes
1 answer

Find quartile of range based on value in other column

I have the following data in excel starting in cell A1. I want to find the 25th percentile (quartile 1) of the "Time" data based on the Month. For example, what is the 1 quartile of the time data in Apr-17? I wrote this formula, but it did not…
George
  • 317
  • 2
  • 4
  • 16
0
votes
0 answers

Quartile Ambiguity in R

I have this code in R: data <- c(55, 64, 68, 74, 78, 80, 84, 90, 93, 95) summary(data) I was expecting the Median to be 79, 1st Quartile to be 68 and 3rd Quartile to be 90 according to my previous knowledge. What I got as an output was 79 for the…
Shahbaz Hussain
  • 542
  • 4
  • 21
0
votes
1 answer

Creating a Quartile Column using average per observations instead as row value

I have panel data time series, and I would like to create a variable with the quartile of the mean of a given variable so that a firm can only be found in a given quartile. For example, if I have 4 companies: df = id year value Quartile*…
Economist_Ayahuasca
  • 1,648
  • 24
  • 33
0
votes
1 answer

Compute the quartiles of a given list of numbers

I am trying to complete "Accelerated C++" exercise 3-2. I have tested, and the lower quartile and medians are being calculated correctly, but the upper quartile is not. For example, assuming the input "50, 60, 70, 80, 90, 100", it will output the…
Jonathan Dewein
  • 984
  • 3
  • 16
  • 34
0
votes
2 answers

Formula or functions to find Upper Quartile and Lower Quartile in SQL Server

I am trying to get the upper quartile, median and lower quartile in SQL Server. Is there any function or formula? Please advice - many thanks
Rookie
  • 11
  • 1
0
votes
0 answers

Difference between quantile results and iqr

I'm trying to understand a little more about how Octave calculates quartiles and interquartile range. Consider the following: A=[1 4 7 10 14]; quantile(A, [0.25 0.75]) ans = 3.2500 11.0000 This result seems consistent with Method 3 on the…
Michael McMullin
  • 1,450
  • 1
  • 14
  • 25
0
votes
1 answer

Excel quartile function with variable array criteria (like countif)

hoping someone can help with my Excel query. I want to use the quartile function (or similar, could use percentile if that's easier). I have data in a column but I want to limit the data I use from that column. I have job departments in column A,…
0
votes
0 answers

How to count bucket's values with Pandas qcut?

I'm using qcut from Pandas to properly prepare my data for a machine learning algorithm. I have products with prices, and I discretized my data into equal-sized buckets with this code : df['PriceBucket'] = pd.qcut(df['sell_prix'].sort_values(), 10,…
Arij SEDIRI
  • 2,088
  • 7
  • 25
  • 43
0
votes
1 answer

Subsetting lines as interquarile values in tableau

I have been looking around for a while and have not been able to find answers to the following issue that relate to subsetting. I currently have many lines on a line graph and would only like 4 lines which demonstrate: the lower quartile the…
0
votes
1 answer

Mean of quartile for multiple columns and multiple dates

I'm trying to find the mean forward return (column fwd_rtn) of each quartile for each column (ie for quartiles for PB, PE, PS) for each date group (1/1/2016...1/4/2016) head(df) Date Stock Price PB PE PS fwd_rtn 1 1/1/2016 A 11.90 0.4 0.10 …
0
votes
1 answer

different strategies for finding Quartile in excel

let us consider following data 9 5 3 10 14 6 12 7 14 i would like to find `Q1,Q2,Q3,let sort data 3 5 6 7 9 10 12 14 14 in excel we can calculate it very easily =QUARTILE(A2:A10,1) =QUARTILE(A2:A10,2) =QUARTILE(B2:B10,3) results…
user466534
0
votes
1 answer

Trying to calculate quartiles in MDX

My data looks like this: ID |PersonID |CompanyID |DateID |Throughput |AmountType 33F467AC-F35B-4F24-A05B-FC35CF005981 |7 |53 |200802 |3 |0 04EE0FF0-511D-48F5-AA58-7600B3A69695 |18 …
supremo
  • 131
  • 1
  • 1
  • 9