# Quartiles, Quintiles, Deciles and Percentiles – Excel template

Generally, the notions of quartiles, quintiles, deciles, and percentiles are referred to as quantiles in general. A quartile divides a distribution in 4 (as in one-fourth), a quintile divides a distribution in 5 (as in one-fifth), and a decile divides a distribution in 10 (as in one-tenth). And of course, a percentile divides a distribution in 100 (one-hundredth). One of the most obvious applications of quantiles in practice is sorting the performance of a group of observations. Such a group could be composed of investment portfolios, students and their grades, or work performance by a firm’s employees.

Some other related topics you might be interested to explore are Mean, Median, Mode, Percent, and Quartile.

This is an open-access Excel template in XLSX format that will be useful for anyone who wants to work as a Statistician, Data Analyst, Data Scientist, or Asset Manager.

Quartiles, Quintiles, Deciles, and Percentiles are among the topics included in the Quantitative Methods module of the CFA Level 1 Curriculum

### 3-Statement Model – Excel Template

The P&L, Balance sheet, and Cash flow statements are three interrelated parts. The P&L feeds net income on the

### 3-Statement Model – Excel Template

The P&L, Balance sheet, and Cash flow statements are three interrelated parts. The P&L feeds net income on the liabilities and equity side of the Balance sheet. At the same time, we obtain Cash (an asset) by summing the bottom-line result of the Cash flow statement with previous year...

### Cash Flow – Excel Template

The cash flow statement shows how a company generated and spent cash throughout a given timeframe. An important truth

### Cash Flow – Excel Template

The cash flow statement shows how a company generated and spent cash throughout a given timeframe. An important truth that is frequently neglected by inexperienced business owners is that profit does not equal cash. Every business owner and manager needs to have a clear idea of the cash flows...

### Balance Sheet – Excel Template

If the P&L statement shows how profitable a company was over a given timeframe, we can say that the

### Balance Sheet – Excel Template

If the P&L statement shows how profitable a company was over a given timeframe, we can say that the Balance sheet is like a momentary picture of the firm’s condition at the time of preparation. The Balance sheet shows what a company owns (assets) and what it owes (liabilities...