100 Excel Simulations

Name: 100 Excel Simulations | Using Excel to Model Risk, Investments, Genetics, Growth, Gambling and Monte Carlo Analysis
Brand: Holy Macro! Books
Price: 23.49 EUR
Availability: OnlineOnly

Using Excel to Model Risk, Investments, Genetics, Growth, Gambling and Monte Carlo Analysis

Gerard M. Verschuuren(Autor*in)

Holy Macro! Books (Verlag)

Erschienen am 1. November 2016

300 Seiten

E-Book

ePUB mit Adobe-DRM

Systemvoraussetzungen

978-1-61547-357-1 (ISBN)

23,49 €inkl. 7% MwSt.

Systemvoraussetzungen

für ePUB mit Adobe-DRM

E-Book Einzellizenz

Als Download verfügbar

Beschreibung

Weitere Details

Weitere Ausgaben

Person

Inhalt

Intro
Gambling
Chapter 1 The Die Is Cast
Chapter 2 Casting Six Dice
Chapter 3 Frequencies
Chapter 4 Roulette Machine
Chapter 5 Gambler's Ruin
Chapter 6 Random Walk
Chapter 7 Gambling Strategy
Chapter 8 Cracking a Password
Statistics
Chapter 10 The Mean of Means
Chapter 11 Sampling
Chapter 12 The Normal Distribution
Chapter 13 Normalizing
Chapter 14 Repeats
Chapter 15 Confidence Margins
Chapter 16 Power Curves
Chapter 17 Hidden Peaks
Chapter 18 Sampling Sizes
Chapter 19 Quality Control
Genetics
Chapter 21 Sex Determination
Chapter 22 Radiation and Mutation
Chapter 23 Mendel
Chapter 24 Hardy-Weinberg Law
Chapter 25 Genetic Drift
Chapter 26 Lethal Homozygote
Chapter 27 Reduced Vitality
Chapter 28 Two Selective Forces
Chapter 29 Balanced Equilibrium
Chapter 30 Molecular Clock
Chapter 31 DNA Sequencing
Financial
Chapter 33 Risk Analysis
Chapter 34 Missing or Exceeding Targets
Chapter 35 Two-Dimensional Filters
Chapter 36 Scenarios
Chapter 37 Moving Averages
Chapter 38 Return on Investment
Chapter 39 Employee Stock Options
Chapter 40 Value at Risk
Chapter 41 Asian Options
Chapter 42 Black-Scholes Model
Expansion
Chapter 44 Extrapolation
Chapter 45 Predator-Prey Cycle
Chapter 46 Homeostasis
Chapter 47 Taking Medication
Chapter 48 Population Pyramid
Chapter 49 Titration
Chapter 50 EC50 Determination
Chapter 51 Converter
Chapter 52 Conditional Training
Chapter 53 Epidemics
Monte Carlo Simulations
Chapter 55 Brownian Motion
Chapter 56 A Traffic Situation
Chapter 57 Uncertainties in Sales
Chapter 58 Exchange Rate Fluctuations
Chapter 59 Cost Estimates
Chapter 60 Market Growth
Chapter 61 Integration with Monte Carlo
Iterations
Chapter 63 Win or Lose?
Chapter 64 Circular Gradients
Chapter 65 Single-Cell Arrays
Chapter 66 Data Management
Chapter 67 Solving Equations
Chapter 68 Least Squares Method
Chapter 69 Combining Scenarios
Chapter 70 Logistics
Extras
Chapter 72 Graph Manipulation
Chapter 73 Detecting Outliers
Chapter 74 False Positives
Chapter 75 Probability of Beliefs
Chapter 76 Unbiased Sampling
Chapter 77 Numbering Records
Chapter 78 Fiscal Year
Chapter 79 Stock Market
Chapter 80 Forecasting Temperatures
Miscellanea
Chapter 82 Graph Manipulation
Chapter 83 Simulation of a Slot Machine
Chapter 84 Letter Game
Chapter 85 A Hawk-Dove Simulation
Chapter 86 Flock Behavior
Chapter 87 Simulation of Sick Cases
Chapter 88 Ehrenfest's Urn Simulation
Chapter 89 Two Monte Carlo Integrations
Chapter 90 Randomness in Gene Pools
Chapter 91 Random Mating
Chapter 92 Differences in Fitness
Chapter 93 Loan Simulation
Chapter 94 Stock Volatility
Chapter 95 S&P 500 Performance
Chapter 96 Scenario Risks
Chapter 97 Temperature Fluctuations
Chapter 98 Juror Selection
Chapter 99 Waiting Time Simulation
Chapter 100 Project Delays
Appendices
Locking Cell References
Nested functions
What-If Tables
Simulation Controls
Index

Systemvoraussetzungen

Als PDF speichern Als Link merken