Details: Complete Problems 4.9, 4.15, 4.19, 4.23, 4.45, and 4.48 in the textbook

Details: Complete Problems 4.9, 4.15, 4.19, 4.23, 4.45, and 4.48 in the textbook.     Ex-4.15 What is the probability that a new car selected at random needs a warranty repair?                                                                   B. What is the probability that a new car selected at random needs a warranty repair and was manufactured by a U.S.-based company?                                                            C. What is the probability that a new car selected at random needs a warranty repair or was manufactured by a U.S.-based company?                                                           D. What is the probability that a new car selected at random needs a warranty repair or was not manufactured by a U.S.- based company?                               ex-4.23   Gender   Preference Female Male Total Coke 120 95 215 Pepsi 95 80 175 Neither/Unsure 65 45 110 Total 280 220 500   Submit one Excel file. Put each problem result on a separate sheet in your file. You are not required to submit this assignment to Turnitin. You are required to show all of your work/formulas to receive credit for the assignments. Failure to show your work/formulas willnegatively impact your grade.