Frackly Oil
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 880 NORMAL PROBABILITY CALCULATIONS
Std deviation of distribution 7.8
Calculated z-value 1.20
(X-axis)
Probability Using
Prob. of x, or less 0.88493
Desired x-values
Equivalent – Z Values
NORMS.DIST
840 -5.13 0.00000 Equivalent Probability Using Desired
841 -5.00 0.00000 Z Values NORM.DIST x-values
842 -4.87 0.00000 -4.00 0.00003 940
843 -4.74 0.00000 -3.60 0.00016 948
844 -4.62 0.00000 -3.20 0.00069 956
858 -2.82 0.00240 2.40 0.99180 1068
859 -2.69 0.00355 2.80 0.99744 1076
860 -2.56 0.00517 3.20 0.99931 1084
861 -2.44 0.00743 3.60 0.99984 1092
862 -2.31 0.01051 4.00 0.99997 1100
863 -2.18 0.01465
864 -2.05 0.02012
865 -1.92 0.02724
879 -0.13 0.44899
880 0.00 0.50000
881 0.13 0.55101
882 0.26 0.60118
883 0.38 0.64974
884 0.51 0.69596
885 0.64 0.73925
886 0.77 0.77912
0.40
0.50
0.60
0.70
0.80
Cumulative Probability Function
Calculated z-value 1.20
Prob. of x, or less 0.88493
Equivalent Probability Using Desired
Z Values NORM.DIST x-values
-4.00 0.00003 940
-3.60 0.00016 948
2.40 0.99180 1068
2.80 0.99744 1076
3.20 0.99931 1084
3.60 0.99984 1092
4.00 0.99997 1100
Mean of distribution 1020
Std Dev of distribution 20
Desired x-value 1044
887 0.90 0.81526
888 1.03 0.84747
889 1.15 0.87572
890 1.28 0.90009
891 1.41 0.92077
892 1.54 0.93803
893 1.67 0.95221
894 1.79 0.96366
895 1.92 0.97276
896 2.05 0.97988
897 2.18 0.98535
908 3.59 0.99983
909 3.72 0.99990
910 3.85 0.99994
911 3.97 0.99996
912 4.10 0.99998
913 4.23 0.99999
914 4.36 0.99999
915 4.49 1.00000
916 4.62 1.00000
917 4.74 1.00000
918 4.87 1.00000
919 5.00 1.00000
920 5.13 1.00000