Open Microsoft Excel and list your observed data points in column A. Enter "=COUNTIF (A:A,A1)/COUNTA (A:A)" without quotes in cell B1. Click and drag the lower right corner of cell B1 down to the ...

How to Use Excel to Find Percentiles. As your business grows, you'll find that you need Microsoft Excel 2010 more and more to compute important numbers for your business.