Question

In: Statistics and Probability

Create a histogram on excel for a coin toss. Flip the coin 6 times, each time...

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.

Solutions

Expert Solution

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


Related Solutions

Create a histogram on excel for a coin toss. Flip the coin 6 times, each time...
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...
Flip a coin 30 times and document the result of each toss. Then provide both the...
Flip a coin 30 times and document the result of each toss. Then provide both the empirical and theoretical probability distributions. Use the appropriate expression for probability.
flip a coin 30 times and document the result of each toss. Then provide both empirical...
flip a coin 30 times and document the result of each toss. Then provide both empirical and theoretical proability distributions. use the appropriate expression for probability.
Flip a coin 10 times. Put a 1 each time the coin comes up heads and...
Flip a coin 10 times. Put a 1 each time the coin comes up heads and a 0 each time the coin comes up tails. Count the number of heads you obtained and divide by 10. What number did you get? a. Is the number you obtained in part (a) a parameter or a statistic? b. Now flip the coin 25 times. Put a 1 each time you obtain a heads and a 0 for tails. Count the number of...
6. Create a probability distribution for a coin flipping game. That is, toss a coin at...
6. Create a probability distribution for a coin flipping game. That is, toss a coin at least 25 times and keep up with the number of heads and the number of tails. (8 points for each part) a. Compile your data into a probability distribution. Be sure to show that your distribution meets the properties for a probability distribution. RESULTS Trial 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19...
hink about the following game: A fair coin is tossed 10 times. Each time the toss...
hink about the following game: A fair coin is tossed 10 times. Each time the toss results in heads, you receive $10; for tails, you get nothing. What is the maximum amount you would pay to play the game? Define a success as a toss that lands on heads. Then the probability of a success is 0.5, and the expected number of successes after 10 tosses is 10(0.5) = 5. Since each success pays $10, the total amount you would...
We toss a fair 6 sided die and flip a fair coin twice. Define the random...
We toss a fair 6 sided die and flip a fair coin twice. Define the random variable Y1 to be the number of sports atop the die. Define Y2 to be the total number of heads obtained on the two flips of the coin. a) Find the mean value and standard deviation of Y1. b) Find the mean value and standard deviation of Y2. c) Find the mean value and standard deviation of Y1+Y2. d) What are the mean value...
Flip a fair coin 5 times. What is the probability that at least one time the...
Flip a fair coin 5 times. What is the probability that at least one time the coin lands on heads?
Write an application that simulates coin tossing. Let the program toss a coin each time the...
Write an application that simulates coin tossing. Let the program toss a coin each time the user chooses the “Toss Coin” menu option. Count the number times each side of the coin appears. Display the results. The program should call a method flip( ) that takes no arguments and returns a zero to represent a tail or a one to represent a head. There is a Random class that will allow you to generate a random integer. Import it from...
What are the probabilities that... 1) You toss a fair coin 6 times and you get...
What are the probabilities that... 1) You toss a fair coin 6 times and you get exactly 4 heads? 2) You toss a fair coin 6 times and you get at least two heads?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT