130 Excel Simulations in Action

by Dr. Gerard M. Verschuuren



Order the book from Amazon: www.Amazon.com
Order the book from Barnes & Noble: www.barnesandnoble.com
Order the book from Amazon, UK: www.amazon.co.uk



A book with 130 different 
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 (1)	
10: A Letter Game (2)	
11: A Game Board	
12: A Gambling Strategy	
13: A Three-Way Circuit	
14: Flocking Behavior	

II.	STATISTICS	
15: Samples	
16: A Normal Distribution	
17: The Perfect Bell Curve	
18: Types of Distributions	
19: Peaks	
20: Standard Error	
21: Confidence Margins	
22: Confidence Intervals	
23: Power Curves	
24: Sampling Sizes	
25: Polling Errors	
26: Flipping a Fair Coin?	
27: Simulation of Sick Cases	
28: Bean Machine Simulation	
29: Correlated Distributions	
30: Transforming a LogNormal Distribution	
31: Bootstrapping	
32: Outlier Detection	
33: Chi-Squared Test	
34: Unbiased Sampling	
35: Sorted Random Sampling	
36: Sorted Random Dates	

III.	MONTE CARLO SIMULATIONS	
37: The Law of Large Numbers	
38: Random Walk	
39: Brownian Motion	
40: Ehrenfest Urn	
41: A Data Table with Memory	
42: Juror Selection in Court	
43: Running Project Costs	
44: Forecasting Profits	
45: Uncertainty in Sales	
46: Exchange Rate Fluctuations	
47: Monte Carlo Stock Values	
48: Monte Carlo Retirement	
49: Monte Carlo and Pi	
50: Integration Simulated	
51: Two Monte Carlo Integrations	

IV.	GENETICS	
52: Shuffling Chromosomes	
53: Sex Determination	
54: Mendelian Laws	
55: The Hardy-Weinberg Law	
56: Genetic Drift	
57: Two Selective Forces	
58: Balanced Polymorphism	
59: Differential Fitness	
60: Random Mating	
61: Molecular Clock	
62: DNA Sequencing	
V.	SCIENCE	
63: Matrix Elimination	
64: Interpolation	
65: Extrapolation	
66: Boltzmann Equation for Sigmoidal Curves	
67: Rounding in Excel	
68: Simple Decay Simulation	
69: Radioactive Decay	
70: Michaelis-Menten Equation	
71: Chemical Equilibria	
72: Spectrum Simulation	
73: Oscillations
74: Ballistic Trajectories	
75: Logistic Bacterial Growth	
76: Predator-Prey Cycle	
77: The Course of an Epidemic	
78: Taking Medication	
79: A Hawk-Dove Game	
80: A Population Pyramid	
81: False Positives	

VI.	BUSINESS	
82: Cycle Percentiles	
83: Profit Estimates	
84: Production Costs	
85: Profit Changes	
86: A Filtering Table	
87: Risk Analysis	
88: Scenarios	
89: Market Growth	
90: Target Analysis	
91: Fiscal Year	
92: Resource Allocation	
93: A Traffic Situation	
94: Quality Control	
95: Logistics	
96: Customer Flow	
97: Project Delays	

VII.	FINANCE	
98: Smoothing Data	
99: Investing Optimized	
100: Return on Investment (ROI)	
101: Fluctuating APR	
102: Loan Payments	
103: Buy or Sell Stock?	
104: S&P500 Performance	
105: Stock Market Analysis	
106: Employee Stock Options	
107: Stock Volatility	
108: Net Present Value	
109: Asian Options	
110: Black-Scholes Model	
111: Value at Risk (VaR)	
112: Historical Value at Risk	
113: Combined Value at Risk	
114: Stock Price Movements	

VIII.	MISCELLANEA	
115: Numbering Records	
116: Cracking a Password	
117: Area Code Finder	
118: Data Management	
119: Chart Snapshots	
120: Sizing Bins for Frequencies	
121: Chart Markers	
122: Scrolling Charts	
123: Graph Manipulation	
124: Creating Gradients	
125: Summarizing in Steps	
126: A Monthly Calendar	
127: Comparison of Values	
128: Letter Permutations	
129: Metric Conversion	
130: Probability of Beliefs