214 ◾ Simple Statistical Methods for Software Engineering
Without referring to the Gaussian tables, we can compute the tail area using
Excel function in the following expression:
Right tail = 1 − NORMDIST (USL, mean, standard deviation, 1)
Substituting our values, we get right tail = 0.04697 or 4.697%.
You can measure opportunity with the same yardstick
that measures the risk involved. They go together.
Earl Nightingale
e remaining area under the Gaussian measures the probability of meeting
the goal or “capability.” In our case, requirement volatility capability is 95.3%, as
marked in Figure 13.7.
Capability and risk are complementary. If one is absent the other steps in.
As an extension of the risk calculation procedure, we can calculate risks for tails
based on their distances from the mean. As an example, the tail areas are calculated
for a few useful values of distance from mean and given in Table 13.1.
Table 13.1 contains the solution to the one-tailed problem and presents the
probability of processes exceeding a given specification limit. Several one-tailed
problems, such as the probability of defect density exceeding an upper limit, are the
probability of productivity falling below a lower specification limit.
ere are several two-tailed problems. ese processes have both an upper
specification limit and a lower specification limit. For the effort variance metric,
the specification limits are ±20% in a certain enhancement project. e actual per-
formance is characterized by a normal distribution with mean = 14 and standard
deviation = 15. e two specification limits define two tails.
e Excel syntax for the previous computation is as follows:
Left tail = NORMDIST (LSL, mean, standard deviation, 1)
Right tail = 1-NORMDIST (USL, mean, standard deviation, 1)
Total risk in the process = left tail + right tail
e calculations are shown in Data 13.1.
e left tail involves process compliance risk. When teams save, there is a risk of
adopting short cuts, which might later boomerang as product failure. e right tail has
a plain cost risk. e total risk in the project could be the sum of the two-tailed areas.
Sometimes, the two tails can attract different weights, for a “weighted” sum calculation
of total risk. We have used a plain summation in Data 13.1 with the following result: