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
