In Microsoft Excel, using a scatter chart allows you to plot the data points against the probability of achieving each observed data point.

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.

Using the Bergum Method and the MS Excel software program, the author determines the probability of passing the USP dissolution test.

Filters are great tools, but you can't remove specific items from the results. When you need to do this, try Find All in Excel instead.

When working with a large data set, you would be more productive if you knew how to quickly find what you need. Luckily, Excel has a few functions that can help with this.