Methods to Calculate Quintiles in Excel (With Examples)

by

In statistics, quintiles are numbers that break a dataset into 5 teams of equivalent frequency.

The primary quintile is the purpose the place 20% of all knowledge values lie under it. The second one quintile is the purpose the place 40% of all knowledge values lie under it, and so on.

We will virtue refer to serve as to calculate the quintiles for a dataset in Excel:

=PERCENTILE(CELL RANGE, QUINTILE)

Please see instance displays learn how to virtue this serve as in follow.

Instance: Calculate Quintiles in Excel

Think we have now refer to dataset with 20 values:

Please see symbol displays learn how to calculate the quintiles for the dataset:

The right way to interpret the quintiles is as follows:

  • 20% of all knowledge values lie under 6.8.
  • 40% of all knowledge values lie under 14.
  • 60% of all knowledge values lie under 20.8.
  • 80% of all knowledge values lie under 26.2.

We will additionally virtue refer to formulation to calculate each and every quintile on the identical pace:

=PERCENTILE(CELL RANGE, {0.2, 0.4, 0.6, 0.8})

Please see symbol displays how to take action:

Understand that the quintiles calculated right here fit the quintiles we calculated previous.

Backup Sources

Methods to Calculate Deciles in Excel
Methods to Calculate a 5 Quantity Abstract in Excel
Methods to Calculate the Interquartile Territory (IQR) in Excel

Leave a Comment