Verschuuren G. 100 Excel VBA Simulations: Using Excel VBA to Model Risk, Investments, Genetics. Growth, Gambling, and Monte Carlo Analysis

CreateSpace Independent Publishing Platform, 2016. — 460 p.Gambling.
The Die Is Cast
Casting Six Dice
Roulette Machine
An X-O Game
A Slot Machine
Gamblers’ Ruin
Lottery Numbers
Win or Lose?
A Letter Game
A Three-Way Circuit
Flock Behavior
Statistics.
Samples
A Normal Distribution
Distribution Simulations
Discrete Distributions
Peaks
Confidence Margins
Sample Size and Confidence Interval
Random Repeats
Flipping a Fair Coin?
Simulation of Sick Cases
Unbiased Sampling
Transforming a LogNormal Distribution
Outlier Detection
Bootstrapping
Bean Machine Simulation
Correlated Distributions
Sorted Random Sampling
Frequencies
Monte Carlo Simulations.
The Law of Large Numbers
Brownian Motion
Ehrenfest Urn
Random Walk
A Data Table with Memory
Juror Selection in Court
Running Project Costs
Forecasting Profits
Uncertainty in Sales
Exchange Rate Fluctuations.
Genetics.
Shuffling Chromosomes
Sex Determination
Mendelian Laws
The Hardy-Weinberg Law
Genetic Drift
Two Selective Forces
Differential Fitness
Molecular Clock
DNA Sequencing
Science.
Matrix Elimination
Integration with Simulation
Two Monte Carlo Integrations
Monte Carlo Approach of Pi
A Population Pyramid
Predator-Prey Cycle
Taking Medication
The Course of an Epidemic
Boltzmann Equation for Sigmoidal Curves
Interpolation
A Rigid Pendulum
A Piston Sinusoid
The Brusselator Model
A Hawk-Dove Game
Business.
Prognosis of Sales
Cycle Percentiles
Cost Estimates
A Filtering
Profit Changes
Risk Analysis
Scenarios
Market Growth
A Traffic Situation
Quality Control
Waiting Time Simulation
Project Delays
Finance.
Buy or Sell Stock
Moving Averages
Automatic Totals and Subtotals
Fluctuations of APR
Net Present Value
Loan with Balance and Principal
S&P500 Performance
Stock Market
Stock Volatility
Return on Investment
Value at Risk
Asian Options
Misscellanea.
Cracking a Password
Encrypting Text
Encrypting a Spreadsheet
Numbering Records
Sizing Bins for Frequencies
Creating Calendars
Populating a Jagged Array
Filtering a Database
Formatting Phone Numbers
Creating Gradients
Aligning Multiple Charts
Temperature Fluctuations
Working with Fiscal Years
Time Calculations
Appendix.
Data Tables
If Statements
Value Type Variables
Ranges vs. Cells
FormulaR1C1
Arrays
Error Handling