Calculating Quartiles

[rushabh_shah]

Hi Team,

Like we have automatic options to do Sum, Count, Avg, Median etc. how dow we get Quartiles in Alteryx?

Regards,

Rushabh

[jdunkerley79 · Accepted solution]

Use the percentile option in the summarise and set to 25/75% 

[MarqueeCrew]

@jdunkerley79,

You're FAST!!!!

I was going to go another route and use the TILE tool.  I'd use the EQUAL RECORDS method

and set it up with 4 tiles.  Based on the "Score" or value that we were tiling, I'd not let it break on that field (e.g. all 70.5's should get the same tile).  You can also group by within the tool and get tiles by Gender or other fields.

You say summarize and I say tile.  We're both right :)

[NeilR]

Couple more options:

1. Quartiles appear in the Browse tool data profiling information...

2. And if you need the values in your data stream, use the Basic Data Profile tool...

[GuyMarcel]

How to add the information available in the browse tool profile to a data table or a query result? 

I have a table and i need to extract (no manually) for one column, the inter quartile range (IQR) to dynamically remove outliers from the data set. I can see Q1 and Q3 in the tool's output and i need a formula using that information to create a new column in the workflow.

[NeilR]

@GuyMarcel you can use the Basic Data Profile tool.

[CHerv]

Hi,

I have checked the various options - percentile, tile and basic data profile but I am not sure any of these solutions give the correct quartile result.

For example, the sequence of 1, 2, 3, 4, 5, 6 should provide a result of :

Lower quartile = (1+2)/2  =  1.5

Median = (3+4)/2 = 3.5

Upper quartile = (5+6)/2 = 5.5

None of the options (percentile, tile and basic data profile) provide that outcome. For example, the basic profile provides the following values :-

25th Percentile = 2.25

50th Percentile = 3.5  

75th Percentile = 4.75

Can someone please review and let me know if I am right/wrong ... if right, is there is another way to determine the quartiles?

[kheuer]

@CHerv  - did you ever figure out this problem? 

[ptaylor_ds]

I had posted the same issue... missed this discussion.  Is there a fix for the math yet?

Re: Median and 3rd Percentile Calculation Error - Alteryx Community