Calculation of percentiles in MS-Excel

The data to be processed consist of soil ICP analyses for Ba (-80 mesh fraction, aqua-regia digestion, 0.5 gram aliquot) from the Daisy Creek prospect, Montana.


Step 1

Step 2


Step 3

Clicking on the icon on the right enables the input data to be selected using the mouse (see Step 4). The checkbox on the left must be checked if the identifying variable is to appear in the output.

Step 4

More than one variable can be selected but in this instance only Ba will be processed. Clicking on the icon on the right of the box will return to the main Rank and Percentile window.


Step 5

Click on the “OK” to perform the calculations.

Step 6

Output is written into a new worksheet.



Plotting of calculated percentiles to generate a cumulative frequency graph

Input data are percentiles calculated above.


Step 1

Click on the “Chart Wizard” window

Step 2

Click on the “Series” tab and remove the existing “default” entries, if any.


Step 3

Clicking on the circled icon enables the data to be selected by dragging the mouse over the input data (not shown here)

Step 4

Titles and axis labels are added.


Step 5

X-axis gridlines are added (default is y-axis gridlines only)

Step 6

Legend is removed by clicking on circled checkbox.



Step 7

Chart is directed to new worksheet (default is to create chart in an existing sheet)

Step 8

Preliminary Result. Reformatting of axis begins with right-clicking mouse over it.



Step 9

Y-axis maximum is changed to 1 (100%) from 1.2 (120%)


Step 10

Axis fonts are emboldened and increased in size.


Step 11

Numbers on Y-axis are reformatted to percentages with no decimal places. Axis reformatting is complete and “OK” can be clicked.

Step 12

Cumulative-frequency line is thickened after right-clicking mouse over it (not shown).


Step 13

Background is changed to white. Reformatting is complete and “OK” can be clicked again.

Final Result.

Go to Directory Page