Instructions : Clearly label each problem and each part of a problem on your pap
ID: 3353606 • Letter: I
Question
Instructions : Clearly label each problem and each part of a problem on your paper. print information and explain in detail on any questions or comments. Make sure and 1.) Simulate flipping a fair coin by performing the following operations. a.) Randomly generate a column of data (c1) with 2500 entries { Cale Random Data Integer ). b.) Randomly generate a column of data (c2) with 4500 entries t Cale Random Data Integer ). c.) Randomly generate a column of data (c3) with 9500 entries {Cale'Random Data Integer ). Minimum number is 0 and maximum number is 1 Minimum number is 0 and maximum number is 1 Minimum number is 0 and maximum number is 1Explanation / Answer
Let 0 be heads and 1 be tails. We use the Randbetween function in excel to generate 2500,4500,9500 numbers respectively
a)
Heads=1253
Tails=1245
b)Heads=2248
Tails=2252
c) Heads=4745
Tails=4755
by counting the number of zeros and 1s respectively.