2 problem excel and word
Gannon University
Department of Mechanical Engineering
Decision Making Under Uncertainty, GENG 623
Use the spreadsheet developed for problem # 1. Calculate the probability that 1 through 20 parts out of 30 parts tested and found to be defective, are assembled by first group (all experienced workers). Plot this probability as a function of defective parts. Please submit your spread sheet with values as well as with formulae.
Hint: Follow the procedure similar to section 2.4 from the textbook.