A book with 100 different VBA simulations in Excel I. GAMBLING 1: The Die Is Cast 2: Casting Six Dice 3: Roulette Machine 4: An X-O Game 5: A Slot Machine 6: Gamblers’ Ruin 7: Lottery Numbers 8: Win or Lose? 9: A Letter Game 10: A Three-Way Circuit 11: Flocking Behavior II. STATISTICS 12: Samples 13: A Normal Distribution 14: Distribution Simulations 15: Discrete Distributions 16: Peaks 17: Confidence Margins 18: Sample Size and Confidence Interval 19: Random Repeats 20: Flipping a Fair Coin? 21: Simulation of Sick Cases 22: Unbiased Sampling 23: Transforming a LogNormal Distribution 24: Outlier Detection 25: Bootstrapping 26: Bean Machine Simulation 27: Correlated Distributions 28: Sorted Random Sampling 29: Frequencies III. MONTE CARLO SIMULATIONS 30: The Law of Large Numbers 31: Brownian Motion 32: Ehrenfest Urn 33: Random Walk 34: A Data Table with Memory 35: Juror Selection in Court 36: Running Project Costs 37: Forecasting Profits 38: Uncertainty in Sales 39: Exchange Rate Fluctuations IV. GENETICS 40: Shuffling Chromosomes 41: Sex Determination 42: Mendelian Laws 43: The Hardy-Weinberg Law 44: Genetic Drift 45: Two Selective Forces 46: Differential Fitness 47: Molecular Clock 48: DNA Sequencing V. SCIENCE 49: Matrix Elimination 50: Integration with Simulation 51: Two Monte Carlo Integrations 52: Monte Carlo Approach of Pi 53: A Population Pyramid 54: Predator-Prey Cycle 55: Taking Medication | 56: The Course of an Epidemic 57: Boltzmann Equation for Sigmoidal Curves 58: Interpolation 59: A Rigid Pendulum 60: A Piston Sinusoid 61: The Brusselator Model 62: A Hawk-Dove Game VI. BUSINESS 63: Prognosis of Sales 64: Cycle Percentiles 65: Cost Estimates 66: A Filtering Table 67: Profit Changes 68: Risk Analysis 69: Scenarios 70: Market Growth 71: A Traffic Situation 72: Quality Control 73: Waiting Time Simulation 74: Project Delays VII. FINANCE 75: Buy or Sell Stock? 76: Moving Averages 77: Automatic Totals and Subtotals 78: Fluctuations of APR 79: Net Present Value 80: A Loan with Balance and Principal 81: S&P500 Performance 82: Stock Market 83: Stock Volatility 84: Return on Investment 85: Value at Risk 86: Asian Options VIII. MISCELLANEA 87: Cracking a Password 88: Encrypting Text 89: Encrypting a Spreadsheet 90: Numbering Records 91: Sizing Bins for Frequencies 92: Creating Calendars 93: Populating a Jagged Array 94: Filtering a Database 95: Formatting Phone Numbers 96: Creating Gradients 97: Aligning Multiple Charts 98: Temperature Fluctuations 99: Working with Fiscal Years 100: Time Calculations IX. APPENDIX Data Tables Simulation Controls If Statements Value Type Variables Ranges vs. Cells FormulaR1C1 Arrays Error Handling X. INDEX |