Share
Explore BrainMass

Simulation

A certain college's men's basketball team is quite accomplished at making free throws. According to the coach, in their most recent season the team made approximately 75 percent of free-throw attempts, and ranked 10th in the country among similar schools in successful free-throw attempts. Set up another new worksheet to simulate 100 free throws shot by team members who have probability 0.75 of making each shot. Again, use column A to keep track of the attempt number in cells A2 through A101. Label cell B1 Hit or Miss. Now you will generate a sequence of equally likely occurrences of the numbers 0, 1, 2, or 3 with 0 representing a miss and any of the other three numbers representing a hit. By entering the formula =INT(4*RAND()) into cell B2, you can set the sequence up so each of the numbers occurs with equal probability. Then autofill to cell B101. In cell C2, enter the formula =IF(B2=0,0,1). This will give you a "1" in cell C2 if cell B2 recorded a hit, and a "0" if cell B2 recorded a miss. Autofill the formula down to cell C101.

a. Find the overall proportion of hits, and identify the length of the longest streak of hits and the length of the longest streak of misses. Write a paragraph commenting on your proportion of hits and your "streaks."
b. Describe how the "streaks" compare for the 50-percent and 75-percent scenarios.

Solution Summary

Simulates basketball free throws using Excel.

$2.19