# Simulation

Assume a "1" means heads came up.

A) Graph the cumulative % heads. For example, say the first flip comes up heads. The % heads is 100%. If the second flip comes up tails the cumulative % heads is 50%. If the third flip comes up tails the cumulative % heads is 33%.

2) What is the "average" number of heads.

3) Look at the data-- what is the longest "streak" of heads?

B) Use Excel to generate 40 columns of randomly distributed 0's and 1's.

1) Find the number of heads for each column.

2) Use the total number of heads to generate a histogram.

3) Describe the histogram.

© BrainMass Inc. brainmass.com October 9, 2019, 10:32 pm ad1c9bdddfhttps://brainmass.com/business/strategy-and-business-analysis/simulation-frequency-distribution-problem-223307

#### Solution Preview

Answers are in the attached excel file on two different work sheets - A part on the first and B part on the second.

Assume a "1" means heads came up.A) Graph the cumulative % heads.For example, say the first flip comes up heads. The % heads is 100%. If the second flip comes up tails the cumulative % heads is 50%. If the third flip comes up tails the cumulative % heads is 33%. 2.)What is the "average" number of heads. 3)Look at the data-- what is the longest "streak" of heads? B)Use Excel to generate 40 columns of randomly distributed 0's and ...

#### Solution Summary

Frequency Distribution for coin flip: graph data, generate and describe a histogram: Graph the cumulative % heads. What is the "average" number of heads. Look at the data-- what is the longest "streak" of heads? Use the total number of heads to generate a histogram. Describe the histogram.