(Solved): show excel formulas Q1. Consider the joint frequency table on the right. The numbers refer to a sam ...

Q1. Consider the joint frequency table on the right. The numbers refer to a sample of USB drives. a. Derive the joint probability table. b. What is the probability of selecting a green USB drive at random from the sample? c. What is the probability of selecting a defective drive given that the clolor of the drive is green? d. Are selecting a yellow drive and selecting a non-defective drive statistically independent? Explain.