Simulation
Not what you're looking for?
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.
Purchase this Solution
Solution Summary
Simulates basketball free throws using Excel.
Purchase this Solution
Free BrainMass Quizzes
Measures of Central Tendency
Tests knowledge of the three main measures of central tendency, including some simple calculation questions.
Know Your Statistical Concepts
Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.
Measures of Central Tendency
This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.
Terms and Definitions for Statistics
This quiz covers basic terms and definitions of statistics.