2 problem excel and word

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.