# 100 Excel Simulations

November 2016

## A Fun Book about Excel!

Learn how to use Excel for gambling to genetics.

Bill Jelen, MrExcel

covers: Excel 2010 - Excel 2016, Office 365

Product Details
• Paperback: 213 Pages
• Publisher: Holy Macro! Books
• Print ISBN: 978-1-61547-048-8
• PDF ISBN: 978-1-61547-234-5
• ePub ISBN: 978-1-61547-357-1
• Mobi (Kindle) ISBN: 978-1-61547-134-8

Covering a variety of Excel simulations, from gambling to genetics, this introduction is for people interested in modeling future events, without the cost of an expensive textbook. The simulations covered offer a fun alternative to the usual Excel topics and include situations such as roulette, password cracking, sex determination, population growth, and traffic patterns, among many others.

• Gambling

1. The Die Is Cast
2. Casting Six Dice
3. Frequencies
4. Roulette Machine
5. Gambler’s Ruin
6. Random Walk
7. Gambling Strategy
• Statistics

1. The Mean of Means
2. Sampling
3. The Normal Distribution
4. Normalizing
5. Repeats
6. Confidence Margins
7. Power Curves
8. Hidden Peaks
9. Sampling Sizes
10. Quality Control
• Genetics

1. Sex Determination
3. Mendel
4. Hardy-Weinberg Law
5. Genetic Drift
6. Lethal Homozygote
7. Reduced Vitality
8. Two Selective Forces
9. Balanced Equilibrium
10. Molecular Clock
11. DNA Sequencing
• Financial

1. Risk Analysis
2. Missing or Exceeding Targets
3. Two-Dimensional Filters
4. Scenarios
5. Moving Averages
6. Return on Investment
7. Employee Stock Options
8. Value at Risk
9. Asian Options
10. Black-Scholes Model
• Expansion

1. Extrapolation
2. Predator-Prey Cycle
3. Homeostasis
4. Taking Medication
5. Population Pyramid
6. Titration
7. EC50 Determination
8. Converter
9. Conditional Training
10. Epidemics
• Monte Carlo Simulations

1. Brownian Motion
2. A Traffic Situation
3. Uncertainties in Sales
4. Exchange Rate Fluctuations
5. Cost Estimates
6. Market Growth
7. Integration with Monte Carlo
• Iterations

1. Win or Lose?
3. Single-Cell Arrays
4. Data Management
5. Solving Equations
6. Least Squares Method
7. Combining Scenarios
8. Logistics
• Extras

1. Graph Manipulation
2. Detecting Outliers
3. False Positives
4. Probability of Beliefs
5. Unbiased Sampling
6. Numbering Records
7. Fiscal Year
8. Stock Market
9. Forecasting Temperatures
• Miscellanea

1. Graph Manipulation
2. Simulation of a Slot Machine
3. Letter Game
4. A Hawk-Dove Simulation
5. Flock Behavior
6. Simulation of Sick Cases
7. Ehrenfest’s Urn Simulation
8. Two Monte Carlo Integrations
9. Randomness in Gene Pools
10. Random Mating
11. Differences in Fitness
12. Loan Simulation
13. Stock Volatility
14. S&P 500 Performance
15. Scenario Risks
16. Temperature Fluctuations
17. Juror Selection
18. Waiting Time Simulation
19. Project Delays
• Appendices

• Locking Cell References
• Nested functions
• What-If Tables
• Simulation Controls
• Index