Excel Simulations

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.

Table of Contents

Part 1. Gambling
Chapter 1. The Die Is Cast
Chapter 2. Casting Six Dice
Chapter 3. Frequencies
Chapter 4. Roulette Machine
Chapter 5. Gambler’s Ruin
Chapter 6. Random Walk
Chapter 7. Gambling Strategy
Chapter 8. Cracking a Password

Part 2. Statistics
Chapter 10. The Mean of Means
Chapter 11. Sampling
Chapter 12. The Normal Distribution
Chapter 13. Normalizing
Chapter 14. Repeats
Chapter 15. Confidence Margins
Chapter 16. Power Curves
Chapter 17. Hidden Peaks
Chapter 18. Sampling Sizes
Chapter 19. Quality Control

Part 3. Genetics
Chapter 21. Sex Determination
Chapter 22. Radiation and Mutation
Chapter 23. Mendel
Chapter 24. Hardy-Weinberg Law
Chapter 25. Genetic Drift
Chapter 26. Lethal Homozygote
Chapter 27. Reduced Vitality
Chapter 28. Two Selective Forces
Chapter 29. Balanced Equilibrium
Chapter 30. Molecular Clock
Chapter 31. DNA Sequencing

Part 4. Financial
Chapter 33. Risk Analysis
Chapter 34. Missing or Exceeding Targets
Chapter 35. Two-Dimensional Filters
Chapter 36. Scenarios
Chapter 37. Moving Averages
Chapter 38. Return on Investment
Chapter 39. Employee Stock Options
Chapter 40. Value at Risk
Chapter 41. Asian Options
Chapter 42. Black-Scholes Model

Part 5. Expansion
Chapter 44. Extrapolation
Chapter 45. Predator-Prey Cycle
Chapter 46. Homeostasis
Chapter 47. Taking Medication
Chapter 48. Population Pyramid
Chapter 49. Titration
Chapter 50. EC50 Determination
Chapter 51. Converter
Chapter 52. Conditional Training
Chapter 53. Epidemics

Part 6. Monte Carlo Simulations
Chapter 55. Brownian Motion
Chapter 56. A Traffic Situation
Chapter 57. Uncertainties in Sales
Chapter 58. Exchange Rate Fluctuations
Chapter 59. Cost Estimates
Chapter 60. Market Growth
Chapter 61. Integration with Monte Carlo

Part 7. Iterations
Chapter 63. Win or Lose?
Chapter 64. Circular Gradients
Chapter 65. Single-Cell Arrays
Chapter 66. Data Management
Chapter 67. Solving Equations
Chapter 68. Least Squares Method
Chapter 69. Combining Scenarios
Chapter 70. Logistics

Part 8. Extras
Chapter 72. Graph Manipulation
Chapter 73. Detecting Outliers
Chapter 74. False Positives
Chapter 75. Probability of Beliefs
Chapter 76. Unbiased Sampling
Chapter 77. Numbering Records
Chapter 78. Fiscal Year
Chapter 79. Stock Market
Chapter 80. Forecasting Temperatures

Part 9. Appendices
Chapter 1. Locking Cell References
Chapter 2. Nested functions
Chapter 3. What-If Tables
Chapter 5. Simulation Controls