Class Problem #3 Develop Figure 2.7. This is the spreadsheet we developed in the class. You will need to
recreate this spreadsheet yourself. Leave the spreadsheet live and change the number of
parts in simulation Table from 1 to 20 and note down the probability that 1 through 20
modules out of 30 modules tested and found to be defective made by irregular current
(Similar to Figure 2.8). Plot this probability (data from Figure 2.8) as a function of
defective modules (Figure 2.9) made by irregular current.
Hint: You are reproducing Figure 2.9 but using data obtained from live spreadsheet
developed in the class.
해