Excel Simulations
November 2013
A fun Excel book, covering everything from gambling to genetics
Learn how to use circular references (on purpose) to perform simulations in Excel
Add to Cart: $9.99 »- 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.
-
I. Gambling
- The Dice Is Cast
- 200 Random Numbers
- Frequencies
- Casting Six Dices
- Roulette Machine
- Cracking a Password
-
II. Statistics
- The Bell Curve
- The Mean of Means
- Sampling
- The Normal Distribution
- Normalizing
- Confidence Limits
- Power Curves
- Hidden Peaks
- Sampling Sizes
-
III. Genetics
- Chromosomes
- Sex Determination
- Radiation and Mutation
- Hardy-Weinberg Law
- Lethal Homozygote
- Reduced Vitality
- Two Selective Forces
- Frequency Changes
- Balanced Polymorphism
-
IV Business
- Loan Targets
- Changes in Demand
- Risk Analysis
- Missing or Exceeding Targets
- Two-Dimensional Filters
- Scenarios
- Compounding Effects
- Moving Averages
-
V Growth
- Growth Curves
- Population Growth
- Titration
- Extrapolation
- The Offspring of Two Rabbits
- Buffers
- Surface Area
- Converter
-
VI. Monte Carlo Simulations
- A Traffic Situation
- Uncertainties in Sales
- Exchange Rate Fluctuations
- Cost Estimates
- Integration with Monte Carlo
-
VII. Iterations
- Single-Cell Arrays
- Multi-Cell Arrays
- Circular References
- Counting New Hits
- Circular Gradients
- Solving Equations
- Least Squares Method
- Reducing Residuals
-
VIII. Miscellanea
- Area Code Finder
- Hide Outliers in a Graph
- Monthly Calendar
- Mark Changes in a Table
- Numbering Records
- Simulating Repetition
-
IX Appendices
- Relative vs. Absolute References
- Range Names
- Nested functions
- Array Functions
- What-If Tables