00:01
For this question, we are generating 30 random birthdays.
00:05
Study the probabilities of two people in a group of 30 during the same birthday.
00:11
So we're representing the different days of the year as the integers from 1 through 365.
00:17
And to do so, we're using the rand between function in excel.
00:23
So for that function, start with an equal sign, and we start typing rand between.
00:28
We find the function.
00:30
Then we enter the lowest number that we want to generate random integer from.
00:34
That's 1, and then the highest number, that's 365.
00:38
We hit enter and we will get some randomly generated integer between 1 and 365.
00:44
We can drag this formula down across 30 rows of cells to generate random numbers for 30 different birthdays.
00:55
Now the specific question here is what do we expect the average birthday to be? practically speaking, this question doesn't have a lot of significance because we are just arbitrarily assigning the numbers 1 through 365...