ProductSolutionsTemplatesResources

PERCENTILE.INC

See PERCENTILE

Video field
Statistical

In Google Sheets, the function PERCENTILE.INC is used to calculate the percentile of a given dataset.

Here's a breakdown of the function's parameters:

"data": This refers to the range of values or array containing the dataset for which you want to calculate the percentile. It can be a cell range, a range reference, or an array.

"percentile": This is the specific percentile you want to find within the dataset. It should be a decimal number between 0 and 1, where 0 represents the minimum value (0th percentile) and 1 represents the maximum value (100th percentile).

The "=PERCENTILE.INC(data, percentile)" function returns the value at the specified percentile within the dataset. For example, if you have a set of values in cells A1 to A10 and you use the formula "=PERCENTILE.INC(A1:A10, 0.5)" it will return the median value of the dataset.

Visit Official Docs

Want even more from Google Sheets?


With Softr, you can turn your spreadsheets into powerful web apps.You can give advanced roles and permissions to each user, build advanced logic and automation flows, customize the design to your needs, and much more.


Softr also offers a growing library of templates for internal tools, client portals, community hubs, and more. The templates come with a Google Sheet or an Airtable base that you can use to store and manage your data easily.


Try Softr now and build your custom web apps in 10 minutes – no code required!