This needs to be done in Excel
50 students enrolled in a particular course recently completed a mid-term exam. 13 students earned an A, 10 students earned a B, 8 students earned a C, 9 students earned a D, and 10 students earned an F on the exam. The students were queried regarding the number of hours they had devoted to studying for the exam. 11 of the students who earned an A, 7 of the students who earned a B, 3 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.
- What is the probability of a randomly selected student having devoted no more than 8 hours to studying for the exam?
- What is the probability of a randomly selected student having earned an A or a B on the exam, given they devoted no more than 8 hours to studying for the exam?
- What is the probability of a randomly selected student having earned less than a B on the exam given, they devoted more than 8 hours to studying for the exam?
- What is the probability of a randomly selected student having earned less an A on the exam, given they devoted more than 8 hours to studying for the exam?