MUST SHOW ALL CALCULATIONS USING EXCEL FORMATTING
Scenario Data: 45 students in two sections of a college Physics 101 course recently took a mid-term exam. 12 students earned an A, 9 students earned a B, 8 students earned a C, 8 students earned a D and 8 students earned an F on the exam. The students were queried regarding the number of hours they had devoted to studying for the exam. 9 of the students who earned an A, 6 of the students who earned a B, 5 of the students who earned a C, 2 of the students who earned a D, and 1 of the students who earned an F reported that they had devoted more than 8 hours to studying for the exam. The remaining students reported that they had devoted no more than 8 hours to studying for the exam.
Question 1. What is the probability of a randomly selected student having earned an A on the exam?
Question 2. What is the probability of a randomly selected student having earned a B on the exam?
Question 3. What is the probability of a randomly selected student having devoted no more than 8 hours to studying for the exam?
Question 4. What is the probability of a randomly selected student having earned an A on the exam given they devoted no more than 8 hours to studying for the exam?
Question 5. What is the probability of a randomly selected student having earned an F on the exam given they devoted more than 8 hours to studying for the exam?
Question 6. What is the probability of a randomly selected student having earned an A or a B on the exam given they devoted more than 8 hours to studying for the exam?