Groupby Quantile

Computes the quantile of values in a dataset grouped by a specified column.

Input

Select Scope

Other Group Aggregation

Output

Table Statistic?

Any Questions?

Computes the quantile of values in a dataset grouped by a specified column. A quantile is a value that divides a set into equal-sized subgroups or intervals. Read more about quantile on Wikipedia https://en.wikipedia.org/wiki/Quantile

The 75th percentile of the set [1, 2, 3, 4, 5] is 4 because it divides the set into the lower 75% and the upper 25%.

Gives percentile ranks within each group. Useful in grading systems, sales performance ranking, etc.

Microsoft Excel: QUARTILE
Google Sheets: QUARTILE
Apple Numbers: QUARTILE
Python Pandas: df.groupby('grouping_column')['column_name'].quantile(q=0.5)
Related Words: calculate groupby quantile, find quantile based on a grouping column

This is normal for a web based application. We recommend uploading data up to 6000 columns and rows. If you encounter lag, you can reduce the sheet size.

There is a fullscreen button on the top right side of the input table. You can also download the table offline to edit with excel which has bigger screen sizes.

You can leave a message here.

Why SickSheet?

🌎

Access Anywhere

Compatible with any browser on any systems. No installation needed.

💸

Free to Use

Use over 300+ tools for free. No registration or credit card asked.

🧸

No Code

Complete all process without writing a single line of code.

💡

Intuitive Edit

Editing tables feels like in Excel. No learning curve needed.

💾

Instant Download

Click to download 10+ Spreadsheet formats and continue edit in Excel.

🕵️‍♂️

Super Private

Nothing is sent to the server. All data are operated on the client-side.

Table Statistic?

Any Questions?

Q1: What does this tool do?

Q2: Can you give an example?

Q3: When is it useful?

Q4: What are related functions?

Q5: Why does it lag during input pasting?

Q6: Can I make the spreadsheet window bigger?

Q7: Who can I contact?