Scribd
Upload
46 views4 pages

92% Attempt Result: Percentage Made

This document simulates 100 free throw attempts by Larry Bird, who hits 90% of his free throws. It records each attempt as a 1 for a make or 0 for a miss. It encourages clicking buttons to simulate additional attempts and see streak statistics. The exact same formula is used in 100 cells to model each attempt as a random draw with 90% chance of success.

Uploaded by

Syv Consultores Asociados
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
46 views4 pages

92% Attempt Result: Percentage Made

This document simulates 100 free throw attempts by Larry Bird, who hits 90% of his free throws. It records each attempt as a 1 for a make or 0 for a miss. It encourages clicking buttons to simulate additional attempts and see streak statistics. The exact same formula is used in 100 cells to model each attempt as a random draw with 90% chance of success.

Uploaded by

Syv Consultores Asociados
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 4

Sample

Percentage Made

92%

This sheet contains a single repetition of 100 draws (free throw attempts).

Attempt

Result

Larry Bird hits 90% of his free throws. The formula in Cell B4 informs Exce

2
3
4
5

1
1
1
1

Hit F9 to simulate another 100 free throws.


How did Larry do this time?

6
7
8

1
1
1

How much spread or bounce is there?

Click on the button below to do so.

10

11
12
13
14

1
1
1
1

15

16

17
18
19

1
1
1

20
21

1
1

22

23
24
25

1
1
1

26
27

1
1

28
29

1
0

30

31
32
33

0
0
1

34
35

1
0

36
37

1
1

38

39

The exact same formula is used in the 100 cells from B4 to B1

Hit F9 again and again. Watch cell B1.

Wouldn't it make sense to keep track of Larry's sample percentage?

Curious about streaks? Click on the button below.


Click this button several times.

Do you think Max Streaks follow a normal distribution?


Click on the button below to see a Monte Carlo simulation that answers this

Page 1

Sample

40
41

1
1

42
43

1
1

44
45

1
1

46
47
48
49
50

1
1
1
1
0

51
52
53
54

1
1
1
1

55
56

1
1

57

58
59

1
0

60
61

1
1

62
63
64

1
1
1

65

66
67

1
1

68
69

1
1

70

71

72
73

1
1

74
75
76
77

0
1
1
1

78

79
80

1
1

81

Page 2

Sample

82
83

1
1

84
85

1
1

86
87

1
1

88
89
90
91
92

1
1
1
1
1

93
94
95
96

1
1
1
1

97
98

0
1

99
100

1
1

Page 3

Sample

draws (free throw attempts).

mula in Cell B4 informs Excel of this chance process.

n the 100 cells from B4 to B103. Click on a few of these cells to see for yourself.

s sample percentage?

o simulation that answers this question.

Page 4

You might also like