Probability for a Money Machine

[Taibak]

My company has ordered a money machine (a device that looks like a phone booth that blows cash around while you try to catch it) for employee incentives.

I am trying to figure out the probability of someone capturing more than x amount of dollars per attempt.

We are going to be blowing 200 bills around of varying values. Let's assume the average person can catch 30 bills in 30 seconds.

If we have 150 bills with a face value of $1, and 50 bills with a face value of $5, what is the probability of them catching more than $50?
If we have 150 bills with a face value of $1, 25 bills with a face value of $5, and 25 bills with a face value of $10, what is the probability of them catching more than $75?

I am hoping that there is an Excel function that can compute these types of probabilities for me. Can someone please assist?

 

[mrshl9898]

Sounds like basic maths

Scenario 1 total Value is 400, 525 in 2. Average values $2 and $2.625

30 Bills would average $60 and $78.75.


I have been in one of those however, and caught more like 80% of bills.... So $320 or $420