Cointoss.ST.2016W.xlsx - Rand 0-1 Fixed 0-1 Rand 0 99.999...

Info icon This preview shows pages 1–8. Sign up to view the full content.

Rand Fixed Rand 0 - 1 0 - 1 0 - 99.999 Excel Rand() function
Image of page 1

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

n
Image of page 2
Coin Toss experiment Toss a coin by using a computer simulation; If the number that comes up is >0.5 record a Head If > .5, H H 1 If the number that comes up is <0.5 record a Tail If < .5, T T 0 0.93 H 1 0.81 H 1 0.72 H 1 0.47 F 0 0.36 F 0 0.45 F 0 0.57 H 1 0.21 F 0 0.44 F 0 0.74 H 1 # of Heads = 5 # of Tosses = 10 Prob(Head) = 0.5 A B C D E F G H I J 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
Image of page 3

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

Coin Toss experiment Toss a coin by using a computer simulation; If the number that comes up is >0.5 record a Head If > .5, H H 1 If the number that comes up is <0.5 record a Tail If < .5, T T 0 0.609809347 H 1 0.687242233 H 1 0.42932976 F 0 0.757463352 H 1 0.85988415 H 1 0.739484046 H 1 0.867698905 H 1 0.331239533 F 0 0.799298574 H 1 0.568443359 H 1 # of Heads = 8 # of Tosses = 10 Prob(Head) = 0.8 A B C D E F G H I J 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
Image of page 4
Coin Toss experiment Toss a coin by using a computer simulation; If the number that comes up is >0.5 record a Head If > .5, H H 1 If the number that comes up is <0.5 record a Tail If < .5, T T 0 0.63 0.51 0.62 0.38 0.55 0.83 0.93 0.70 0.53 0.84 0.36 0.09 0.35 0.34 0.34 0.75 0.62 0.88 0.82 0.20 0.80 0.54 0.44 0.94 0.04 0.07 0.57 0.86 0.67 0.39 0.43 0.89 0.65 0.50 0.48 0.73 0.58 0.57 0.54 0.43 0.02 0.98 0.34 0.23 0.22 0.56 0.97 0.88 0.64 0.88 H H H F H 1 1 1 0 1 H H H H H 1 1 1 1 1 F F F F F 0 0 0 0 0 H H H H F 1 1 1 1 0 H H F H F 1 1 0 1 0 F H H H F 0 1 1 1 0 F H H H F 0 1 1 1 0 H H H H F 1 1 1 1 0 F H F F F 0 1 0 0 0 H H H H H 1 1 1 1 1 # of Heads = 32 # of Tosses = 50 Prob(Head) = 0.64 A B C D E F G H I J K 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30
Image of page 5

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

Coin Toss experiment Toss a coin by using a computer simulation; If the number that comes up is >0.5 record a Head H 1 If the number that comes up is <0.5 record a Tail T 0 0.56 0.39 0.00 0.01 0.29 0.25 0.95 0.26 0.09 0.29 0.36 0.72 0.59 0.08 0.78 0.46 0.92 0.20 0.65 0.55 0.33 0.57 0.54 0.34 0.70 0.82 0.04 0.88 0.50 0.56 0.39 0.11 0.71 0.90 0.75 0.36 0.02 0.19 0.51 0.98 0.03 0.79 0.47 0.40 0.84 0.75 0.24 0.32 0.73 0.30 0.68 0.30 0.73 0.07 0.18 0.86 0.92 0.87 0.06 0.30 0.38 0.82 0.55 0.21 0.11 0.83 0.06 0.48 0.19 0.31 0.55 0.09 0.92 0.96 0.99 0.93 0.19 0.88 0.18 0.37 0.06 0.28 0.51 0.01 0.25 0.49 0.80 0.25 0.65 0.09 0.46 0.86 0.22 0.47 0.55 0.84 0.75 0.15 0.88 0.60 H T T T T T H T T T T H H T H T H T H H T H H T H H T H H H T T H H H T T T H H T H T T H H T T H T H T H T T H H H T T T H H T T H T T T T H T H H H H T H T T T T H T T T H T H T T H T T H H H T H H 1 0 0 0 0 0 1 0 0 0 0 1 1 0 1 0 1 0 1 1 0 1 1 0 1 1 0 1 1 1 0 0 1 1 1 0 0 0 1 1 0 1 0 0 1 1 0 0 1 0 1 0 1 0 0 1 1 1 0 0 0 1 1 0 0 1 0 0 0 0 1 0 1 1 1 1 0 1 0 0 0 0 1 0 0 0 1 0 1 0 0 1 0 0 1 1 1 0 1 1 # of Heads = 47 # of Tosses = 100 Prob(Head = 0.47 A B C D E F G H I J 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41
Image of page 6
Coin Toss experiment
Image of page 7

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

Image of page 8
This is the end of the preview. Sign up to access the rest of the document.
  • Spring '09
  • Brian

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern