1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

  2. Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  3. When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Predicting & seeing patterns in random 100 coin flips. Can you get 75% right always?

Discussion in 'Discuss Data Visualizations and Charting' started by Harry0, Jan 8, 2019.

  1. Harry0

    Harry0 Member

    I am showing basic and don't have all odds but you see a pattern when you flip a coin 100 times. This is a basic example and I am thinking fo showing more if others are interested with higher number and more numbers which gets more complicated and it needs new types of formulas. Maybe later show the odds of dice to have 6 numbers, roulette to have 32, or even Lotto to have pick 2 or more numbers which I do not have it in a presentable way since it is a bit complex... for at least me. It is a bit hard to focus and put it down since it feels overwhelming when dealing with higher numbers and many calculations later on, so for now I am showing just a basic number of 1 or 2 (heads & tails, black & red, etc)

    I assume you might have some other patterns to show to find even better odds. For example finding the odds of it not going as it should since at the end of 100 flips it can be off by not 50/50 but 40/60. So can you guess most numbers without saying everything is heads to get a 50% efficiency. Try to see if you can get 75% efficiency. Or have a formula that can predict it.

    Attached Files:

Share This Page