MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Excel Simulations


November 2013

Excel Simulations

A fun Excel book, covering everything from gambling to genetics

Learn how to use circular references (on purpose) to perform simulations in Excel

Bill Jelen, MrExcel

category: Spreadsheets
covers: Excel 2010 - 2016, Office 365

Product Details
  • Paperback: 180 Pages
  • Publisher: Holy Macro! Books
  • Print ISBN: 978-1-61547-022-8
  • PDF ISBN: 978-1-61547-215-4
  • ePub ISBN: 978-1-61547-335-9
  • Mobi (Kindle) ISBN: 978-1-61547-115-7

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.

  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

Where to Buy

MrExcel Store

We will ship you a physical copy of the book, plus you can immediately download the e-book in any of three DRM-Free versions: PDF, ePub, or Mobi.

Print Book from MrExcel »

MrExcel Store

Outside of the USA, purchase the e-book. Again, you can choose from any of 3 DRM-Free editions when you purchase from:

e-Book from MrExcel »

Amazon.com

Print Book from Amazon:

Print Book from Amazon »

Other Editions