I have a video here on solving combination and permutations problems using StatCrunch, but here is the basic Excel solution for problem 3.4.51 in MyStatLab homework which just requires the use of **combinations since order does not matter**.

Remember since these are independent events – the probability of choosing 4 from shift 1 does not change for different choices from shift 2 – the P(A and B) = P(A)*P(B) using the Multiplication Rule.

Download a copy of the Excel workbook here.