Cellurific Battery Life-Reliability
X-value Calculations Given Probabilities Using the Inverse Normal Distribution
This spreadsheet is designed to calculate the X-value based on probability of values equal to, or less than a desired x value,
of a normally distributed variable. It requires input of a known mean and standard deviation and uses the inverse of the cumulative normal distribution
Enter the mean of the distribution in cell D10 and the standard deviation in cell D11, below. Enter the desired probability in cell D12, and the calculated x-value will be seen in D13.
Mean of distribution 1100
Std Dev of distribution 60
Calculated x-values Probability Reliability – 1-P 920 0.00135
860 0.00003 0.99997 980 0.02275
866 0.00005 0.99995 1040 0.15866
872 0.00007 0.99993 1100 0.50000
878 0.00011 0.99989 1160 0.84134
884 0.00016 0.99984 1160 0.84134
920 0.00135 0.99865
926 0.00187 0.99813
932 0.00256 0.99744
938 0.00347 0.99653
944 0.00466 0.99534
950 0.00621 0.99379
956 0.00820 0.99180
962 0.01072 0.98928
968 0.01390 0.98610
974 0.01786 0.98214
980 0.02275 0.97725
986 0.02872 0.97128
992 0.03593 0.96407
998 0.04457 0.95543
1004 0.05480 0.94520
1010 0.06681 0.93319
1016 0.08076 0.91924
1022 0.09680 0.90320
1028 0.11507 0.88493
1070 0.30854 0.69146
1076 0.34458 0.65542
1082 0.38209 0.61791
1088 0.42074 0.57926
1094 0.46017 0.53983
1100 0.50000 0.50000
1106 0.53983 0.46017
1112 0.57926 0.42074
1118 0.61791 0.38209
0.000
0.600
0.700
0.800
0.900
1.000
860 960 1060 1160 1260
X-values
0.300
0.400
0.500
0.600
0.700
0.800
0.900
1.000
Probability
Reliability Curve
Probability of X or less 0.10 Calculated Given
1124 0.65542 0.34458
1130 0.69146 0.30854
1136 0.72575 0.27425
1142 0.75804 0.24196
1148 0.78814 0.21186
1154 0.81594 0.18406
1160 0.84134 0.15866
1166 0.86433 0.13567
1172 0.88493 0.11507
1220 0.97725 0.02275
1226 0.98214 0.01786
1232 0.98610 0.01390
1238 0.98928 0.01072
1244 0.99180 0.00820
1250 0.99379 0.00621
1256 0.99534 0.00466
1262 0.99653 0.00347
1268 0.99744 0.00256
1274 0.99813 0.00187
1322 0.99989 0.00011
1328 0.99993 0.00007
1334 0.99995 0.00005
1340 0.99997 0.00003