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 CompTIA Data+: Data Analytics Tools
Rating 4.3 of 32 users Rating 4.3 of 32 users (32)
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)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Book A Complete Guide to PivotTables: A Visual Approach
Course Getting started in Excel 365 (2023)
Rating 3.5 of 57 users Rating 3.5 of 57 users (57)
Book Excel 2019 Bible