100 Excel VBA Simulations by Verschuuren
Book Details :
LanguageEnglish
Pages460
FormatPDF
Size12.5 MB


100 Excel VBA Simulations by Verschuuren



100 Excel VBA Simulations: Using Excel VBA to Model Risk, Investments, Genetics, Growth, Gambling, and Monte Carlo Analysis by Dr. Gerard M. Verschuuren | PDF Free Download.

100 Excel VBA Simulations Contents

GAMBLING

  • Chapter 1: The Die Is Cast
  • Chapter 2: Casting Six Dice
  • Chapter 3: Roulette Machine
  • Chapter 4: An X-O Game
  • Chapter 5: ASlot Machine
  • Chapter 6: Gamblers’Ruin
  • Chapter 7: Lottery Numbers
  • Chapter 8: Win or Lose?
  • Chapter 9: ALetter Game
  • Chapter 10: AThree-Way Circuit
  • Chapter 11: Flock Behavior

STATISTICS

  • Chapter 12: Samples
  • Chapter 13: ANormal Distribution
  • Chapter 14: Distribution Simulations
  • Chapter 15: Discrete Distributions
  • Chapter 16: Peaks
  • Chapter 17: Confidence Margins
  • Chapter 18: Sample Size and Confidence Interval
  • Chapter 19: Random Repeats
  • Chapter 20: Flipping a Fair Coin?
  • Chapter 21: Simulation of Sick Cases
  • Chapter 22: Unbiased Sampling
  • Chapter 23: Transforming a LogNormal Distribution
  • Chapter 24: Outlier Detection
  • Chapter 25: Bootstrapping
  • Chapter 26: Bean Machine Simulation
  • Chapter 27: Correlated Distributions
  • Chapter 28: Sorted Random Sampling
  • Chapter 29: Frequencies
  • MONTE CARLO SIMULATIONS
  • Chapter 30: The Law of Large Numbers
  • Chapter 31: Brownian Motion
  • Chapter 32: Ehrenfest Urn
  • Chapter 33: Random Walk
  • Chapter 34: AData Table with Memory
  • Chapter 35: Juror Selection in Court
  • Chapter 36: Running Project Costs
  • Chapter 37: Forecasting Profits
  • Chapter 38: Uncertainty in Sales
  • Chapter 39: Exchange Rate Fluctuations

GENETICS

  • Chapter 40: Shuffling Chromosomes
  • Chapter 41: Sex Determination
  • Chapter 42: Mendelian Laws
  • Chapter 43: The Hardy-Weinberg Law
  • Chapter 44: Genetic Drift
  • Chapter 45: Two Selective Forces
  • Chapter 46: Differential Fitness
  • Chapter 47: Molecular Clock
  • Chapter 48: DNASequencing

SCIENCE

  • Chapter 49: Matrix Elimination
  • Chapter 50: Integration with Simulation
  • Chapter 51: Two Monte Carlo Integrations
  • Chapter 52: Monte Carlo Approach of Pi
  • Chapter 53: APopulation Pyramid
  • Chapter 54: Predator-Prey Cycle
  • Chapter 55: Taking Medication
  • Chapter 56: The Course of an Epidemic
  • Chapter 57: Boltzmann Equation for Sigmoidal Curves
  • Chapter 58: Interpolation
  • Chapter 59: ARigid Pendulum
  • Chapter 60: APiston Sinusoid
  • Chapter 61: The Brusselator Model
  • Chapter 62: AHawk-Dove Game

BUSINESS

  • Chapter 63: Prognosis of Sales
  • Chapter 64: Cycle Percentiles
  • Chapter 65: Cost Estimates
  • Chapter 66: AFiltering Table
  • Chapter 67: Profit Changes
  • Chapter 68: Risk Analysis
  • Chapter 69: Scenarios
  • Chapter 70: Market Growth
  • Chapter 71: ATraffic Situation
  • Chapter 72: Quality Control
  • Chapter 73: Waiting Time Simulation
  • Chapter 74: Project Delays

FINANCE

  • Chapter 75: Buy or Sell Stock
  • Chapter 76: Moving Averages
  • Chapter 77: Automatic Totals and Subtotals
  • Chapter 78: Fluctuations of APR
  • Chapter 79: Net Present Value
  • Chapter 80: Loan with Balance and Principal
  • Chapter 81: S&P500 Performance
  • Chapter 82: Stock Market
  • Chapter 83: Stock Volatility
  • Chapter 84: Return on Investment
  • Chapter 85: Value at Risk
  • Chapter 86: Asian Options

MISCELLANEA

  • Chapter 87: Cracking a Password
  • Chapter 88: Encrypting Text
  • Chapter 89: Encrypting a Spreadsheet
  • Chapter 90: Numbering Records
  • Chapter 91: Sizing Bins for Frequencies
  • Chapter 92: Creating Calendars
  • Chapter 93: Populating a Jagged Array
  • Chapter 94: Filtering a Database
  • Chapter 95: Formatting Phone Numbers
  • Chapter 96: Creating Gradients
  • Chapter 97: Aligning Multiple Charts
  • Chapter 98: Temperature Fluctuations
  • Chapter 99: Working with Fiscal Years
  • Chapter 100: Time Calculations

Download 100 Excel VBA Simulations by Verschuuren in PDF Format For Free.