Question

Use the Excel Program to generate a uniform distribution and then show that a flipping fair coin many times will result in having a 50% chance of landing heads up and a 50% chance of landing tails up.

Answer 1

First take A1 box and write there RAND()

Then at A1 a random number between 0 and 1 will be generated.

Then,at the bottom right corner of A1 you will see a dark bold spot

Click on that and drag up to A200

Now you will have 200 random numbers between 0 and 1

Number of numbers below 0.5 may be considered as tail or head.

Write anywhere COUNTIF(A1:A200,"<0.5") to calculate number of numbers in A1:A200 are less than 0.5

I got the result 97

You may get different result since they are random numbers but it will be very close to 100 so that probability would be 0.5

You may increase number of random numbers to get more closer value to 0.5.