Start here · Essential guide
Simulating Games: Using Code and Spreadsheets to Test Odds
Learn how game simulation estimates probabilities that are hard to derive by hand, using short scripts or spreadsheet formulas and simple checks on accuracy.
Applied Math
Spreadsheets, code and tests for checking game claims.
Start here · Essential guide
Learn how game simulation estimates probabilities that are hard to derive by hand, using short scripts or spreadsheet formulas and simple checks on accuracy.
Build a dice spreadsheet step by step: list every outcome, count sums with COUNTIF, convert to percentages, and compare your table with simulated rolls.
Learn how a chi-square test compares observed die counts with the counts a fair die would give, with a worked example, formulas, and cautions on interpretation.
Tracking mistakes such as selective logging, shifting categories and stopping at a good moment can mislead you about your skill. Here is how to keep cleaner records.
See how uncertain an observed win rate is. Worked examples of 10, 100 and 1,000 games show how the confidence interval narrows as the sample size grows.
A step-by-step Monte Carlo method example: estimate the chance of drawing at least one ace in five cards, then check the estimate against the exact answer.
How random number generators work in games: pseudo-random sequences, seeds, what statistical quality they guarantee, and the mistakes that cause biased results.
How many games before a difference means anything? Learn how statistical significance and sample size work, with worked examples for win rates and rule changes.
Random seeds explained: how a starting value makes a pseudo-random sequence repeatable, how to use them in Python and spreadsheets, and the mistakes to avoid.
Learn to plot game results as outcome histograms so the shape of the spread is clear: bin choice, counts versus proportions, and what skew and tails reveal.
Related topics