You are a senior engineer in a company for making motor parts. While doing research, you realize that 5% the parts coming off an assembly line are defective, 78% are moderately okay and the rest 17 out of 100 are perfect. If the sampling was binomially distributed, while determining distribution of defective parts what is the chance of getting 40% parts being defective. Show all calculations in Excel. Thanks for the help.
Solved by K. F. in 15 mins