I was planning on building a Galton Board as a demonstration, then I thought that maybe I co do a virtual version on Excel. So I was just trying to do this simulation by myself, but I was getting stuck because my route was trying to simulate each and every ball "choice" as a separate random result. Remarkably your results "tree" with the random numbers on the column on the left look exactly like my spreadsheet! Anyway, your route of starting with the total of balls and then have fractions of them fall through, made it much simpler, so thanks for that!
Dear mr Verschuuren. It has been a while since you were online? I have read your previous book: 100 Excel simulations. as ebook on Bol/kobo subscription. I had realy much fun reading your book. I realy recommend this book if you like Excel. Although you will not encounter all these kind of problems it really helps you to build good models. Every problem is a puzzle and everything is very well explained. Please keep doing your good work! I do have one critical remark: is it not a rule in simulation that all events are independent? So in this model the random value counts for all events in a row? So should not you work with more random values? Just a question....
I was planning on building a Galton Board as a demonstration, then I thought that maybe I co do a virtual version on Excel. So I was just trying to do this simulation by myself, but I was getting stuck because my route was trying to simulate each and every ball "choice" as a separate random result. Remarkably your results "tree" with the random numbers on the column on the left look exactly like my spreadsheet! Anyway, your route of starting with the total of balls and then have fractions of them fall through, made it much simpler, so thanks for that!
Where I can download or buy for it?
Fantastic, thank you for this!
Dear mr Verschuuren. It has been a while since you were online? I have read your previous book: 100 Excel simulations. as ebook on Bol/kobo subscription. I had realy much fun reading your book. I realy recommend this book if you like Excel. Although you will not encounter all these kind of problems it really helps you to build good models. Every problem is a puzzle and everything is very well explained. Please keep doing your good work!
I do have one critical remark: is it not a rule in simulation that all events are independent? So in this model the random value counts for all events in a row? So should not you work with more random values? Just a question....
It's one of those rules you do not have to follow in all cases. In this case it would not enhance things. Thanks for your comment.
Scientific Excel tricks!