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 PreviewSolution 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
    $35.00 for this solution

    PayPal, G Pay, ApplePay, Amazon Pay, and all major credit cards accepted.

    Find A Tutor

    View available Probability Tutors

    Get College Homework Help.

    Are you sure you don't want to upload any files?

    Fast tutor response requires as much info as possible.

    Upload a file
    Continue without uploading

    We couldn't find that subject.
    Please select the best match from the list below.

    We'll send you an email right away. If it's not in your inbox, check your spam folder.

    • 1
    • 2
    • 3
    Live Chats