MrExcel Consulting
Your One Stop for Excel Tips & Solutions

Excel Simulations

November 2013

by Dr. Gerard Verschuuren

A Publication from Holy Macro! Books

Excel Simulations: Solve Problems with Excel
This is a fun book about Microsoft Excel. It covers using Excel for a variety of simulations - from Gambling to Genetics. Most books in this category are $100+ Text Books. This title offers a solid introduction to using Microsoft Excel Simulations in the disciplines of Business, Science, and Casino Gaming.

Order Print Version » Order eBook Version »

Table of Contents

  1. I. Gambling

    • The Dice Is Cast
    • 200 Random Numbers
    • Frequencies
    • Casting Six Dices
    • Roulette Machine
    • Cracking a Password
  2. II. Statistics

    • The Bell Curve
    • The Mean of Means
    • Sampling
    • The Normal Distribution
    • Normalizing
    • Confidence Limits
    • Power Curves
    • Hidden Peaks
    • Sampling Sizes
  3. III. Genetics

    • Chromosomes
    • Sex Determination
    • Radiation and Mutation
    • Hardy-Weinberg Law
    • Lethal Homozygote
    • Reduced Vitality
    • Two Selective Forces
    • Frequency Changes
    • Balanced Polymorphism
  4. IV Business

    • Loan Targets
    • Changes in Demand
    • Risk Analysis
    • Missing or Exceeding Targets
    • Two-Dimensional Filters
    • Scenarios
    • Compounding Effects
    • Moving Averages
  5. V Growth

    • Growth Curves
    • Population Growth
    • Titration
    • Extrapolation
    • The Offspring of Two Rabbits
    • Buffers
    • Surface Area
    • Converter
  6. VI. Monte Carlo Simulations

    • A Traffic Situation
    • Uncertainties in Sales
    • Exchange Rate Fluctuations
    • Cost Estimates
    • Integration with Monte Carlo
  7. VII. Iterations

    • Single-Cell Arrays
    • Multi-Cell Arrays
    • Circular References
    • Counting New Hits
    • Circular Gradients
    • Solving Equations
    • Least Squares Method
    • Reducing Residuals
  8. VIII. Miscellanea

    • Area Code Finder
    • Hide Outliers in a Graph
    • Monthly Calendar
    • Mark Changes in a Table
    • Numbering Records
    • Simulating Repetition
  9. IX Appendices

    • Relative vs. Absolute References
    • Range Names
    • Nested functions
    • Array Functions
    • What-If Tables

About the Author

Dr. Gerard M. Verschuuren is a Microsoft Certified Professional specialized in VB, VBA, and VB.NET. He is the author of many textbooks and has more than 20 years of experience in teaching at colleges and corporations. He holds master's degrees in Biology and in Philosophy, plus a Doctorate in the Philosophy of Science from Universities in Europe. He is author of Excel 2013 For Scientists, Slide Your Way Through Excel VBA and Join the Excellers League.

Order Print Version » Order eBook Version »