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.