MrExcel Publishing
Your One Stop for Excel Tips & Solutions

100 Excel Simulations


November 2016

100 Excel Simulations

A Fun Book about Excel!

Learn how to use Excel for gambling to genetics.

Bill Jelen, MrExcel

category: Spreadsheets
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
    8. Cracking a Password
  • 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
    2. Radiation and Mutation
    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?
    2. Circular Gradients
    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

Where to Buy

MrExcel Store

We will ship you a physical copy of the book, plus you can immediately download the e-book in any of three DRM-Free versions: PDF, ePub, or Mobi.

Print Book from MrExcel »

MrExcel Store

Outside of the USA, purchase the e-book. You can choose from any of 3 DRM-Free editions when you purchase from:

e-Book from MrExcel »

Other Editions