100 Excel Simulations

  • 2h 33m
  • Gerard M. Verschuuren
  • Tickling Keys
  • 2016

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.

About the Author

I am a scientist, writer, speaker, and consultant, working at the interface of science, philosophy, and religion. By training, I am human geneticist who also earned a doctorate in the philosophy of science. I studied and worked at universities in Europe and the United States. In 1994, I moved permanently with my wife, Trudy, to the USA, and live now in the southern part of the State of New Hampshire, USA. Because I learned how to use computers for research in populational genetics, I also train scientists to use computers and help them programming. For this purpose, I also developed a "Visual Learning Series" of CDs and DVDs, published by MrExcel.com.

In this Book

  • The Die is Cast
  • Casting Six Dice
  • Frequencies
  • Roulette Machine
  • Gambler's Ruin
  • Random Walk
  • Gambling Strategy
  • Cracking a Password
  • A Fair Coin?
  • The Mean of Means
  • Sampling
  • The Normal Distribution
  • Normalizing
  • Repeats
  • Confidence Margins
  • Power Curves
  • Hidden Peaks
  • Sampling Sizes
  • Quality Control
  • Chromosomes
  • Sex Determination
  • Radiation and Mutation
  • Mendel
  • Hardy-Weinberg Law
  • Genetic Drift
  • Lethal Homozygote
  • Reduced Vitality
  • Two Selective Forces
  • Balanced Equilibrium
  • Molecular Clock
  • DNA Sequencing
  • Fluctuating APR
  • Risk Analysis
  • Missing or Exceeding Targets
  • Two-Dimensional Filters
  • Scenarios
  • Moving Averages
  • Return on Investment
  • Employee Stock Options
  • Value at Risk
  • Asian Options
  • Black-Scholes Model
  • Offspring of Two Rabbits
  • Extrapolation
  • Predator-Prey Cycle
  • Homeostasis
  • Taking Medication
  • Population Pyramid
  • Titration
  • EC50 Determination
  • Converter
  • Conditional Training
  • Epidemics
  • How Random is Random?
  • Brownian Motion
  • A Traffic Situation
  • Uncertainties in Sales
  • Exchange Rate Fluctuations
  • Cost Estimates
  • Market Growth
  • Integration with Monte Carlo
  • Circular References
  • Win or Lose?
  • Circular Gradients
  • Single-Cell Arrays
  • Data Management
  • Solving Equations
  • Least Squares Method
  • Combining Scenarios
  • Logistics
  • Area Code Finder
  • Graph Manipulation
  • Detecting Outliers
  • False Positives
  • Probability of Beliefs
  • Unbiased Sampling
  • Numbering Records
  • Fiscal Year
  • Stock Market
  • Forecasting Temperatures
  • Data Table with Memory
  • Graph Manipulation
  • Simulation of a Slot Machine
  • Letter Game
  • A Hawk-Dove Simulation
  • Flock Behavior
  • Simulation of Sick Cases
  • Ehrenfest's Urn Simulation
  • Two Monte Carlo Integrations
  • Randomness in Gene Pools
  • Random Mating
  • Differences in Fitness
  • Loan Simulation
  • Stock Volatility
  • S&P 500 Performance
  • Scenario Risks
  • Temperature Fluctuations
  • Juror Selection
  • Waiting Time Simulation
  • Project Delays
SHOW MORE
FREE ACCESS

YOU MIGHT ALSO LIKE

Course Using advanced functions in Excel 365 (2024)
Rating 4.7 of 3 users Rating 4.7 of 3 users (3)
Course Entering data in Excel 365 (2023)
Rating 3.9 of 21 users Rating 3.9 of 21 users (21)
Journey Microsoft Excel
Rating 3.7 of 9 users Rating 3.7 of 9 users (9)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Getting started in Excel 365 (2023)
Rating 3.5 of 57 users Rating 3.5 of 57 users (57)
Book Excel 2019 Bible
Book Excel Basics