A car manufacturer wants to install air conditioners in their cars, they must not be defective, so the car manufacturer will test each unit as it arrives - assume the units arrive randomly and that the probability that the unit will fail is 7%, and units fail independently of each other. Suppose the car manufacturer has an order of 10 cars today, which it intends to complete. We will move this scenario using a negative binomial distribution. In order to calculate the following possibility that the manufacturer will have to test fewer than 12 units in order to complete the order for card would require using the following parameters in the Excel formula for calculating a negative Binomial distribution X= S= P= Cumulative =