Question

1. A coin is flipped 200 times. Use the Binom.dist function to determine the probability that there are between 39 and 103(inclusive) heads flipped.

2. Use Rand() to generate 1000 random numbers from 0-1 and then use Binom.inv to show the number of heads in flipping a coin 200 times

for each of the random numbers.Next prove the average number of heads from the 1000 is close to 100. Use the average function with the results of the

Binom.inv.

Answer 1

		formula used		BINOM.DIST(103,200,0.5,1)-BINOM.DIST(38,200,0.5,1)
				answer		0.69
question 2
			formula used		BINOM.INV(200,0.5,RAND())
					apply this formula in 1000 cells by coping it attaching a equal sign in front
104					I m doing it from cell number a17 to a1016
102
103				for avegage calculation
78
100				formula used			average(a17:a1016)
100
107						answer is		100.1
93
96							so yes it is very close to the true value 100