Problem:
Shaquille O'Neal is not particularly good at free throws. He makes about 50 percent of his free throws over an entire season. Set up a new worksheet to simulate 100 free throws shot independently by a player who has probability 0.5 of making each shot. In column A, keep a record of the attempt number by generating integers 1, 2, 100 in cells A2 through A101. Enter an appropriate title in cell A1. Do 50 rows for each column. This will then simulate flipping a coin 50 times, calculating the number of heads, then do it again and again for a total of 50 using Excel.