Question

Please use the below formula in Excel for developing the combination calculation i.e., the number of ways of choose n numbers k at a time…The Excel formula is =COMBIN(n,k). This will tell you the number of combinations given a number n chosen k at a time. For instance, if you calculated in Excel =COMBIN(49,5) …this will calculate the number of combinations of numbers 1 thru 49 chosen 5 at a time. For instance, 1,2,3,4,5 would be one of those combinations. ] Next, come up with the Probability = 1 / (n chosen k at time ). Note that the denominator is the =COMBIN(n,k) value. Be sure to show your math work in your Word document. Therefore, if you wanted to come up with the probability of winning buy purchasing 4 lottery tickets, given a 49 number lottery where you can choose 5 numbers….here is the calculation that you need to complete: Probability of Winning ( 4 tickets) = 4 / [ COMBIN (49,5) ] Part 2 (answer these questions in your Word document using the definition of probability and the =COMBIN(n,k) formula calculations from Excel): (4) What is the Probability of winning a lottery where you choose 5 out of 49 numbers in a lottery (5) What is the Probability of winning a lottery where you choose 4 out of the 49 numbers in a lottery (6) The probability of choosing 8 of the 49 numbers in a lottery, and

Answer 1

4)Probability of winning a lottery where you choose 5 out of 49 numbers in a lottery

=1/number of ways to choose 5 out of 49 numbers =1/combin(49,5)=1/1906884

5)Probability of winning a lottery where you choose 4 out of the 49 numbers in a lottery

=1/number of ways to choose 4 out of 49 numbers =1/combin(49,4)=1/211876

6)probability of choosing 8 of the 49 numbers in a lottery

=1/number of ways to choose 8 out of 49 numbers =1/combin(49,8)=450978066

( plase revert if help is required in other subparts or need any clarification)