Question

Create an Excel spreadsheet that allows to plug in variables of a lottery game and will determine the probability of asserting different prize levels. The first variable is the number of balls that will be drawn. This number will be either 4, 5 or 6. The second variable is the pool of numbers from which the balls will be drawn. That number will be from 20 to infinity. I would like the probability of each prize level being asserted and the number of winners expected at each prize level related to sales. As previously mentioned, I would want the flexibility of being able to plug in the matrix, for example, 6 of 29, 6 of 36, 5 of 35 and determine the probability of each prize level being asserted at sales levels that I plug in as well. For example, I might want to know, for a 6/36 matrix and sales of 400,000 tickets (each ticket is 6-number combination in this case) what would be the probability of asserting 6 of 6 numbers, 5 of 6, 4 of 6, 3 of 6, 2 of 6, 1 of 6 and 0 of 6 and how many winners we would expect at each level based on sales. I would also like to know how many weekly drawings it would take, at several sales levels that I would plug in, for the 6 of 6 to be asserted. For example, for the same example above, when would we expect for the 6 of 6 to be hit if sales were stable (400,000) week after week or, if sales went up by X% (which I would like to plug in). I would like to be able to plug in a sales increase or decrease for each week, which may be different.

Solution Preview

This material may consist of step-by-step explanations on how to solve a problem or examples of proper writing, including the use of citations, references, bibliographies, and formatting. This material is made available for the sole purpose of studying and learning - misuse is strictly forbidden.

Probability Question

This is only a preview of the solution. Please use the purchase button to see the entire solution

Related Homework Solutions

Mathematics Question
Homework Solution
$15.00
Distribution
Conditional Mean
Integral
Triangular Region
Stock
Conditional Density
Value
Probability Questions
Homework Solution
$45.00
Mathematics
Probability
Hypotheses
Interval
Parameters
Null
Hospitals
McNemar
Probability Questions
Homework Solution
$30.00
Mathematics
Probability
Binomial Distribution
Random Variable
Word Problems
Joint Probability Mass Function
Independent Events
Standard Deviation
Coin Problems
Probability Problem
Homework Solution
$15.00
Selection
Conditional Probability
Prize
Box
Bayes
Carnie
Game
Selection
Get help from a qualified tutor
Live Chats