Please assist me with this question using excel. Requesting appropriate formulas within excel that is consistent with theory such as (AVERAGE, STDEV, BINOMIAL, HYPERGEOMETRIC, etc.). Please indicate how you use any formulas to for the question.

Find the probabilities for the following discrete random variabtes a. b. Among a shipment of 5,000 tires, 1,000 are slightly blemished. If one purchases 10 of these tires, what is the probability that 3 or less {P (x 5) people enter the store. An electronic switching device occasionally malfunctions and may need to be replaced. It is known that the device is satisfactory if it makes, on average no more than .2 errors per hour. A particular ve hour period is chosen as a \"test" on the device. If no more than 1 error occurs, the device is considered satisfactory. What is the probability that a satisfactory device will be misdiagnosed as "unsatisfactory" on the basis of the test? A restaurant chef prepares a tossed salad containing, on average, 5 vegetables per day. Find the probability that the salad contains more than T vegetables on i} a given day and on ii)3 of the next 6 days? . A second stage smog device has been instatled on 50 different industry rms in Los Angeles. An inspector plans to visit 10 randomly selected industrial rms to check the device for violations. Assume that 15 industrial rms violate smog regulations. What is the probability that 5 or less of the inspected rms will result smog violation . A family decides to have children until it has three children of the same gender. Assume P{boy) = P(girl} = .5. What is the gm of X, the number of children in the family