Question: 3 points: Starting in cell 113, moving down, list all possible values for the number of defective microprocessors [out of 5 sampled]. ? points: Suppose

3 points: Starting in cell 113, moving down, list all possible values for the number of defective microprocessors [out of 5 sampled]. ? points: Suppose that Intel Corp.'s shipment contains 11m defective microprocessors. Use Excel's built-in function for the Binomial distribution to caICulate the probability for each outcome you listed in column A. Start the probability calculations in cell BB and move dot-m. I Also, show that you ensured that the sum of the probabilities of all possible outcomes is 1. 2 points: ilrgainI suppose that Intel Corp.'s shipment contains 1% defective microprocessors. In cell {311, nd the average number of defectives we expect in a sample of 5 microprocessors. 4 points: Again, suppose that Intel Corp.'s shipment contains 1% defective microprocessors. In cell |i313, provide the probability that the entire shipment will be returned {assuming mas defect rate and 5 microprocessors sampled]. 4 points: In cell C15, calculate the probability that the entire shipment will he lrept by Gateway even though the shipment has 10% defective microprocessors assuming 5 microprocessors are sampled
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
