EC project2 due by 06/11 4:00pm

profilejinnniubaobao
program_for_computing_distributions.xlsx

Sheet1

DATA 0 1 1 0 1 0 0 0 1 0 0 0 1 1 0 0 1 0 1 0 1 0 0 1 0 0 0 1 1 1 1 0 0 1 1 0 1 1 1 1 1 1 0 1 1 0 1 1 1 0 0 1 0 1 1 0 1 0 0 1 0 1 1 1 1 0 1 0 0 1 0 0 0 0 1 0 1 0 0 1 1 0 1 0 0 0 1 1 1 1 0 1 1 1 0 0 1 0 0 1
#makes 4 4 3 3 4 3 3 4 4 4 4 5 5 4 4 4 4 3 4 4 5 5 5 5 5 6 6 7 7 7 7 7 8 8 8 8 8 8 8 8 7 6 6 6 6 6 6 6 5 4 5 5 5 6 6 6 6 6 6 6 6 6 5 4 3 3 3 3 3 3 3 4 4 5 5 4 9 4 5 6 6 5 6 6 7 7 7 7 6 5 5
binomial distribution
#makes 0 1 2 3 4 5 6 7 8 9 10
frequency 0 0 0 12 19 18 23 10 8 1 0 12
0 1 2 3 4 5 6 7 8 9 10 0 0 0 12 19 18 23 10 8 1 0

Sheet2

DATA 0 1 1 0 1 0 0 0 1 0 0 0 1 1 0 0 1 0 1 0 1 0 0 1 0 0 0 1 1 1 1 0 0 1 1 0 1 1 1 1 1 1 0 1 1 0 1 1 1 0 0 1 0 1 1 0 1 0 0 1 0 1 1 1 1 0 1 0 0 1 0 0 0 0 1 0 1 0 0 1 1 0 1 0 0 0 1 1 1 1 0 1 1 1 0 0 1 0 0 1
# trials 2 1 1 2 1 4 3 2 1 4 3 2 1 1 3 2 1 2 1 2 1 3 2 1 4 3 2 1 1 1 1 3 2 1 1 2 1 1 1 1 1 1 2 1 1 2 1 1 1 3 2 1 2 1 1 2 1 3 2 1 2 1 1 1 1 2 1 3 2 1 5 4 3 2 1 2 1 3 2 1 1 2 1 4 3 2 1 1 1 1 2 1 1 1 3 2 1 3 2 1
until make
geometric distribution
# trials 1 2 3 4 5 6 7 8 9
freq. 52 28 14 5 1 0 0 0 0
1 2 3 4 5 6 7 8 9 52 28 14 5 1 0 0 0 0

Sheet3