116 questions
-1
votes
0
answers
48
views
How to adapt boxplot graph to the boxplot.stats data? [closed]
I´d like to get a boxplot graph with Q1, Q2 and Q3 being the data in the position (n+1)/4, 2*(n+1)/4 and 3*(n+1)/4 of the sorted data.
---------------------------------------
# Data set
t7<-seq(1:...
0
votes
1
answer
232
views
Quartiles in R using a Dataset
I am fairly new to programming in R, and I was trying to find the first and third quartiles for the column titled "rm" in the dataset Boston (which I've renamed to BSTN). I keep getting an ...
0
votes
1
answer
273
views
ggpredict and quartiles: predictions with only one data point?
I am using ggefects::ggpredict() to plot a regression model including two-way interactions: categorical:continuous, continuous:continuous, continuous:continuous (2nd degree polynomial). My first ...
0
votes
1
answer
191
views
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 ...
0
votes
1
answer
477
views
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.. ...
0
votes
2
answers
567
views
Google Sheets Quartile Function Giving Error [duplicate]
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.
0
votes
2
answers
1k
views
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 ...
0
votes
0
answers
133
views
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 ...
0
votes
1
answer
899
views
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 ...
2
votes
1
answer
200
views
Python boxplot size of the IQR from 50% to 70%
I would like to know if it's possible to put 70% of the population in the boxplot as in the red one?
I know that Q3 - Q1 = IQR but don't know how this can help me.
I'm using matplotlib to draw my ...
0
votes
1
answer
2k
views
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,...
0
votes
0
answers
98
views
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 ...
1
vote
1
answer
755
views
How to find top quartile & bottom quartile in R?
Using the mtcars dataset, find car(s) within the top quartile in MPG, bottom quartile in weight, and 5 gears.
I know the answer it just codes not fitting in.
data.frame(mtcars)
mtcars %>% filter(...
0
votes
1
answer
2k
views
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....
2
votes
1
answer
197
views
How can I interpret the pandas quartiles?
I have a pandas datafram df with a column A. The values of A are based on predictions and I've forced them to be greater or equal to 0.00000001.
Now when I run df.A.describe() I get:
count 3....