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
Add to Cart: $9.99 »

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

Product Details
  • 180 Pages
  • Publisher: Holy Macro! Books
  • ISBN: 978-1-61547-022-8
  • PDF ISBN: 978-1-61547-215-4

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 Bookstore

eBook from MrExcel.

MrExcel Bookstore

Print book from MrExcel.

Amazon

Print book from Amazon.


Other Editions


100 Excel Simulations

November 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.