How to Make a Probability Versus Data Point in Excel. ... In Microsoft Excel, using a scatter chart allows you to plot the data points against the probability of achieving each observed data point.

Figure 9.5: Probability Plot Based on Lognormal Distribution with Based on Figure 9.4, the 95 th percentile of the diameter distribution is approximately 5.9 mm, since this is the value corresponding ...