News

In Microsoft Excel, using a scatter chart allows you to plot the data points against the probability of achieving each observed data point.
Enter "=A2/A1" in cell A3 to calculate the classical probability. Probabilities are described as a decimal number between 0 and 1. The example probabilities equal 0.5, 0.25 and 0.833, respectively.