Once we select any random 5 cells in a 9 cell row, we will fill them with bingo numbers. Now, excel has a function to generate random numbers between 1 to 9 ( =round(rand()*9,0)), but this is not good for us since each time we call this function we will get a random number between 1 to 9, where as we need a 5 random numbers without repetition between 1 to 9. The function is memoryless and could repeat numbers when called 5 times. Instead we can list all the possible “5 cells with numbers and others are empty” combinations of a 9 cells region and select a random combination every time. 126 ways in which you can select any 5 cells out of 9 cells ( without repetition of course). You can see the first five such combinations in the image below: So I listed all these combinations in a table and then randomly selected one of the combinations. #Diwali tambola tickets printable pdf free.#Diwali tambola tickets printable pdf download.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |