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.
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.
This is only a preview of the solution. Please use the purchase button to see the entire solution