In: Statistics and Probability
Create a histogram on excel for a coin toss. Flip the coin 6 times, each time moving down to the left (for heads) and to the right (for tails).
Consider it a success if when flipping a coin, the coin lands with the head side facing up. Then the probability of a success is .5 (p=.5) and the probability of failure is .5 (q=.5) for each event of flipping a coin. In this lab you will repeat a procedure of 6 events by flipping a coin six time (n=6). And you will record the number of successes (heads) and failures (tails) for each procedure.
My results: 384 coin tosses= 64 rounds
3 rounds resulted in 6 times landing on Heads.
8 rounds resulted in 5 Heads 1 Tail
14 rounds resulted in 4 Heads 2 Tails
20 rounds resulted in 3 Heads 3 Tails
11 rounds resulted in 2 Heads 4 Tails
8 rounds resulted in 1 Head 5 Tails
0 rounds resulted in 6 Tails
I need to create a frequency table for excel, In order to create a histogram.
Create a histogram on excel for a coin toss. Flip the coin 6 times, each time moving down to the left (for heads) and to the right (for tails).
Consider it a success if when flipping a coin, the coin lands with the head side facing up. Then the probability of a success is .5 (p=.5) and the probability of failure is .5 (q=.5) for each event of flipping a coin. In this lab you will repeat a procedure of 6 events by flipping a coin six time (n=6). And you will record the number of successes (heads) and failures (tails) for each procedure.
My results: 384 coin tosses= 64 rounds
3 rounds resulted in 6 times landing on Heads.
8 rounds resulted in 5 Heads 1 Tail
14 rounds resulted in 4 Heads 2 Tails
20 rounds resulted in 3 Heads 3 Tails
11 rounds resulted in 2 Heads 4 Tails
8 rounds resulted in 1 Head 5 Tails
0 rounds resulted in 6 Tails
I need to create a frequency table for excel, In order to create a histogram.
Number of Heads(x) |
success Rounds(f) |
6 |
3 |
5 |
8 |
4 |
14 |
3 |
20 |
2 |
11 |
1 |
8 |
0 |
0 |
Total |
64 |