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: Office 365, Excel 2010 - 2016

Product Details
  • 213 Pages
  • Publisher: Holy Macro! Books
  • 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 Bookstore

eBook from MrExcel.

Add to Cart »

Skillsoft

Read as part of your employer's Skillsoft / Percipio / Books24x7 subscription.

Open in Percipio »


Other Editions


Excel Simulations

November 2013

This is a fun book about Microsoft Excel. It covers using Excel for a variety of simulations - from Gambling to Genetics.