Ohio Valley Construction
Probability Calculations Using the Normal Distribution Template
Enter data only in the shaded cells
This spreadsheet is designed to calculate the probability of values equal to, or less than, a desired x value,
given the mean and standard deviation of a normally distributed variable. It uses the cumulative normal distribution
Enter the mean of the distribution in shaded cell D8 and the standard deviation in shaded cell D9. below.
Enter the desired X-value in shaded cell D10, below. The calculated z-value and probability will be seen in D11 and D12.
Mean of distribution 15.5
Std deviation of distribution 0.1217
(X-axis)
Probability Using
Desired x-values
Equivalent – Z Values
NORMS.DIST
15.030 -3.86 0.00006
15.048 -3.71 0.00010
15.066 -3.57 0.00018
15.084 -3.42 0.00032
15.282 -1.79 0.03662
15.300 -1.64 0.05015
15.318 -1.50 0.06739
15.336 -1.35 0.08890
15.354 -1.20 0.11513
15.372 -1.05 0.14645
15.390 -0.90 0.18303
15.408 -0.76 0.22484
15.426 -0.61 0.27158
15.444 -0.46 0.32271
15.462 -0.31 0.37743
15.480 -0.16 0.43473
15.498 -0.02 0.49344
15.516 0.13 0.55230
15.534 0.28 0.61002
15.552 0.43 0.66541
15.714 1.76 0.96066
15.732 1.91 0.97170
15.750 2.05 0.98002
15.768 2.20 0.98617
15.786 2.35 0.99061
15.804 2.50 0.99375
15.822 2.65 0.99593
15.840 2.79 0.99740
15.858 2.94 0.99837
15.876 3.09 0.99900
15.894 3.24 0.99940
0.40
0.50
0.60
0.70
Cumulative Probability Function
Desired x-value 15.75
15.912 3.39 0.99964
15.930 3.53 0.99979
15.948 3.68 0.99988
15.966 3.83 0.99994
15.984 3.98 0.99997
16.002 4.12 0.99998
16.020 4.27 0.99999
16.038 4.42 1.00000
16.056 4.57 1.00000
16.164 5.46 1.00000
16.182 5.60 1.00000
16.200 5.75 1.00000
16.218 5.90 1.00000
16.236 6.05 1.00000
16.254 6.20 1.00000
16.272 6.34 1.00000
16.290 6.49 1.00000
16.308 6.64 1.00000
16.326 6.79 1.00000
16.344 6.94 1.00000
16.452 7.82 1.00000
16.470 7.97 1.00000