How to Calculate a Quintile

Save

Calculating a quintile can help you zero in on interesting and informative patterns in a data set. A quintile is a group of numbers that represents 20 percent of the values that reside in a larger set. A company, for example, may calculate quintiles to discover how much its lowest selling items contribute to the company's total sales.The government, on the other hand, might calculate quintiles to discover how income is distributed between different five different age groups.

  • Sort a list of at least five numbers in ascending order and place them in a column, as seen in the following example:

    100
    500
    700
    1,200
    1,300
    20,000
    40,000
    55,000
    58,000
    61,000

  • Calculate the sum of the values in your data set. The sum of the values in the above example is 237,800.

  • Divide the numbers into fifths by drawing lines that separate the quintiles. If you perform this task using the sample data, you’ll see the following:

    100
    500
    700
    1,200
    1,300
    20,000
    40,000
    55,000
    58,000
    61,000

    The numbers above each line represent a quintile. In the above example, the numbers in the second quintile are 700 and 1,200. The values 58,000 and 61,000 make up the fifth quintile.

  • Divide the fifth quintile’s sum by the data-set sum and multiply the result by 100, as shown in the following example:

    (119,000 / 237,800) * 100 = 50.04.

    The result represents the percentage that the fifth quintile contributes to the data set’s total value. In this example, the fifth quintile accounts for over 50 percent of the data set’s total value.

  • Repeat this calculation to determine the contribution percentages of the other four percentiles.

Tips & Warnings

  • You can calculate quintiles faster by working in a spreadsheet program. Sort a column of Excel worksheet cells, for instance, by clicking any cell in the column, clicking “Home,” and then clicking “Sort & Filter.” Click “Sort Smallest to Largest” to sort the cells in ascending order.
  • You may find it useful to learn the ratio between sum of the values in the lowest quintile and the sum of the values in the highest quintile. Perform that calculation by dividing the last quintile's total value by the first quintile's total value.

References

  • Photo Credit Ingram Publishing/Ingram Publishing/Getty Images
Promoted By Zergnet

Comments

Resources

You May Also Like

  • Grade Point Average Vs. Percentile System

    Grade point averages and percentile systems are used by colleges and universities as baseline admissions guidelines. For example, a university law school...

  • How to Calculate Marginal Propensity to Consume

    The Marginal Propensity to Consume (MPC) is a calculation used by economists to express the amount of additional income that consumers are...

  • How to Calculate Salary Range Percentiles

    For just about every job offered by an employer there is a salary range which indicates tolerable pay rates based on knowledge,...

  • How to Calculate Range Statistics

    Statistical measures help summarize a set of data. Calculating different types of range statistics enables you not only to measure the amount...

  • How to Calculate a Lower Quartile

    When statistically analyzing lists of numbers, it is often necessary to identify key values. These values include the minimum, maximum, median and...

  • How to Calculate Quantiles

    A quantile of a sorted data set is any (q-1) values that divide the data set q into approximately equal parts. Quantiles...

  • How to Calculate Quartiles

    When ranking numbers, such as test scores or the length of elephant tusks, it can be helpful to conceptualize one rank in...

  • How to Calculate TRP

    Target Rating Point is a means of determining how often an advertisement is seen by a specific target audience. Calculating TRP will...

  • How to Calculate a Bell Curve

    A bell curve gives a person studying a fact an example of a normal distribution of observations. The curve is also called...

  • How to Calculate a Percentage of a Whole

    A percentage figure represents the number of parts per one hundred a portion amount corresponds to. For example, "75 percent" is another...

  • How to Get a Percentage of Total Income

    Calculating a percentage of your total income is beneficial for a number of reasons. One benefit is for budgeting purposes; many people...

  • What Is a Quintile Rank?

    The term "quintile" refers to one-fifth of a particular group. Quintile 1 typically means the top one-fifth of the group, quintile 2...

Related Searches

Check It Out

How to Build and Grow a Salad Garden On Your Balcony

M
Is DIY in your DNA? Become part of our maker community.
Submit Your Work!