hi i have math problem that i need to solve and set formulas in Excel. So we have 2000 people with 1 up to 50 lottery cards, and we are pulling out 500 winners. every person can be only draw once. Now i want to know the probability for every number of cards what is the chance for that person to win? For example, 1 ticket 5% 2 ticket 7% 3 tickets 9,8%, etc. few more details i would need to set this as an excel formula so that i can use it in the future as well as in future i will have different number of people, different number of winners, and different number of how many people hold how many tickets.
hi i have math problem that i need to solve and set formulas in Excel. So we have 2000 people with 1 up to 50 lottery cards, and we are pulling out 500 winners. every person can be only draw once. Now i want to know the probability for every number of cards what is the chance for that person to win? For example, 1 ticket 5% 2 ticket 7% 3 tickets 9,8%, etc. few more details i would need to set this as an excel formula so that i can use it in the future as well as in future i will have different number of people, different number of winners, and different number of how many people hold how many tickets.
A First Course in Probability (10th Edition)
10th Edition
ISBN:9780134753119
Author:Sheldon Ross
Publisher:Sheldon Ross
Chapter1: Combinatorial Analysis
Section: Chapter Questions
Problem 1.1P: a. How many different 7-place license plates are possible if the first 2 places are for letters and...
Related questions
Question
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps with 2 images
Recommended textbooks for you
A First Course in Probability (10th Edition)
Probability
ISBN:
9780134753119
Author:
Sheldon Ross
Publisher:
PEARSON
A First Course in Probability (10th Edition)
Probability
ISBN:
9780134753119
Author:
Sheldon Ross
Publisher:
PEARSON