If your stats class contain 8 business majors, 4 biology majors and 3 math majors, what is the probability that the professor selects a math major when choosing one student at random from the class Can you show me how to set it up in excell

1. Calculate the total number of students:
\text{Total Students} = 8 + 4 + 3 = 15

2. Identify the number of math majors:
\text{Math Majors} = 3

3. Determine the probability:
P(\text{Math Major}) = \frac{3}{15} = \frac{1}{5}

4. Answer:
P(\text{Math Major}) = \frac{1}{5}

To set this up in Excel:

1. In cell A1, enter "Business Majors".
2. In cell B1, enter "8".
3. In cell A2, enter "Biology Majors".
4. In cell B2, enter "4".
5. In cell A3, enter "Math Majors".
6. In cell B3, enter "3".
7. In cell A4, enter "Total Students".
8. In cell B4, enter the formula: `=SUM(B1:B3)`.
9. In cell A5, enter "Probability of Math Major".
10. In cell B5, enter the formula: `=B3/B4`.
11. The result in cell B5 should be `0.2`, which corresponds to the probability \( \frac{1}{5} \).