Stack Overflow
Stack Overflow

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
1
vote
1 answer

R function to calculate area under the normal curve between adjacent standard deviations

I'm looking into GoF (goodness of fit) testing, and wanted to see if the quantiles of a vector of data followed the expected frequency of a normal distribution N(0, 1), and before running the chi square test, I generated these frequencies for the…
Antoni Parellada
  • 4,253
  • 6
  • 49
  • 114
1
vote
2 answers

Divide Data Into Quartiles

I have a dataset that contains admissions rates of all providers that we work with. I need to divide that data into quartiles, so that each provider can see where their rate lies in comparison to other providers. The rate ranges from 7% to 89%. can…
datacentric
  • 135
  • 2
  • 6
  • 15
1
vote
2 answers

Why is the third quartile less than the mean in my data?

I loaded a data set called gob into R and tried the handy summary function. It is Note that the 3rd quartile is less than the mean. How can this be? Is it the size of my data or something else like that? I already tried passing in a large value…
Ed Fine
  • 717
  • 1
  • 6
  • 18
0
votes
1 answer

Quartile Array: Inclusive or Exclusive of Median Elements

Let's say that we have the following array: [3.0, 4.0, 4.0, 4.0, 7.0, 10.0, 11.0, 12.0, 14.0, 16.0, 17.0, 18.0] The inter-quartile range would be as follows: 25%: 4.0 50%: 10.5 75%: 15 If one then were to try to count the elements in each…
Jake Chasan
  • 6,290
  • 9
  • 44
  • 90
0
votes
0 answers

How do I use PERCENTILE_CONT() on a subset of my data?

Below are 3 lines of code in my SQL SELECT statement that calculate the 25th, 50th and 75th percentile values over column [Value]. I need to modify this logic so that the 25th and 75th percentile values are calculated as follows: For 25th…
dhkhannatccc
  • 1
0
votes
1 answer

QUARTILE.INC returning a value of zero for the 0 QUART

i'm using the quartile.inc() function in a pivot table. The column I'm using is SUM of profit. It doesn't have any 0 values in there (they have been filtered out) yet it keeps returning a 0 value.. Here's a screenshot of the function in…
Yasmine Asali
  • 21
  • 3
0
votes
2 answers

Google Sheets Quartile Function Giving Error

In Google sheets I write the formula =QUARTILE(G7:G27, 1) to give the lower quartile between G7 and G27 but it gives me #ERROR! Here is a print screen that shows my problem.
pedroleitao1999
  • 31
  • 4
0
votes
2 answers

Excel formula to find the average of bottom 25% from the selection

I have numbers in one column (A1:A100), is there a function to find the average from values that are over 75% ? For example: = average(A76:A100) I first thought that =quartile(A1:A100;3) will do the job, but this is a bit different. In real…
fred
  • 93
  • 8
0
votes
0 answers

how to increase or get desired distance along the X axis in BoxPlot?

How do I manually set the distances along the X-axis so I can read all the column names properly? Code trainData[trainData.columns].plot(kind='box',widths=0.1, grid = True)
Md. Rezuwan Hassan
  • 59
  • 1
  • 12
0
votes
0 answers

How do I categorize a non-linear continuous variable in logistic regression

I am performing a logistic regression using a continuous IV that represents a number of days. There are 4 values within the continuous IV - 89, 90, 91, 92. This IV is not linear with the log odds of the dependent variable, which means I need to…
miczan
  • 1
  • 1
0
votes
1 answer

R: plot Q1, Q2, Q3 & mean by category

I have a massive dataset and am trying to plot a sort of boxplot with the Q1, Q2, Q3 stats by category. I would like a boxplot visualization with the standard interquartile range box and thicker line outlining the median, but not the whiskers and…
PaulaSpinola
  • 531
  • 2
  • 10
0
votes
1 answer

Quantile calculation in excel have not found

Quantile calculation in excel, is there a way to do that? I have values that I want to calculate the quantile(0.05, 0.50, and 0.95). I have tried search online but all i found is quartile calculations, not quantile. Most of info i got online cannot…
i200yrs
  • 23
  • 4
0
votes
0 answers

Splitting number of clients into 3 equal intervals

I have a question regarding the splitting by a particular dimension the number of clients into 3 equal intervals. I would like to split the number of values in the 'N' column (representing the number of clients, ncl) into three equal parts, grouped…
LinaN
  • 1
  • 1
0
votes
1 answer

How to calculate quartiles in Python without import

I have a school prodject were we need to calculate the quartiles of a list (list should be able to be both an even and an uneven list) in python. I am not allowed to use import (exept math.floor/math.ceil) to make things easier. I just can't get it…
Mathman123
  • 13
  • 2
0
votes
1 answer

How to find Quartiles from the data in two columns in excel

Hi I have a basic question. I tried to find the answer by myself but I couldn't. how to contain multi areas in Quartile func in excel? (actually, google spreadsheet) I know the basic func of quartile is =quartile(data,1). ex)…
HoHOHO
  • 1
1 2 3
4
5 6 7 8