130 Excel Simulations in Action: Simulations to Model Risk, Gambling, Statistics, Monte Carlo Analysis, Science, Business and Finance - Softcover

Verschuuren, Dr. Gerard M.

Softcover

ISBN 10: 1978429878 ISBN 13: 9781978429871

Publisher: CreateSpace Independent Publishing Platform, 2017

Synopsis

This book covers a variety of Excel simulations, from gambling to genetics. The 130 simulations covered offer an exciting and fun alternative the usual Excel topics and include situations such as roulette, sex determination, population growth, and traffic patterns, among 125 others.

About this title

About the Author

Dr. Gerard M. Verschuuren isa Microsoft Certified Professional specializing in C#.NET, VB, VBA, and VB.NET.He is the principal of Genesis PC, where he teaches and advises on the use ofcurve-fitting software such as Excel and XLfit in data, regression, andstatistical analyses. His clients include Abbott, Bose, IBM, Liberty Mutual,Massachusetts General Hospital, and Harvard University. He is the author ofnumerous computer programming books, including Excel 2007 VBA, FromVBA to VSTO, See Sharper with C#, and 100 Excel VBASimulations. He lives in the southern part of New Hampshire.

From the Inside Flap

I. GAMBLING
1: The Die Is Cast
2: Casting Six Dice
3: Roulette Machine
4: An X-O Game
5: A Slot Machine
6: Gamblers' Ruin
7: Lottery Numbers
8: Win or Lose?
9: A Letter Game (1)
10: A Letter Game (2)
11: A Game Board
12: A Gambling Strategy
13: A Three-Way Circuit
14: Flocking Behavior
II. STATISTICS
15: Samples
16: A Normal Distribution
17: The Perfect Bell Curve
18: Types of Distributions
19: Peaks
20: Standard Error
21: Confidence Margins
22: Confidence Intervals
23: Power Curves
24: Sampling Sizes
25: Polling Errors
26: Flipping a Fair Coin?
27: Simulation of Sick Cases
28: Bean Machine Simulation
29: Correlated Distributions
30: Transforming a LogNormal Distribution
31: Bootstrapping
32: Outlier Detection
33: Chi-Squared Test
34: Unbiased Sampling
35: Sorted Random Sampling
36: Sorted Random Dates
III. MONTE CARLO SIMULATIONS
37: The Law of Large Numbers
38: Random Walk
39: Brownian Motion
40: Ehrenfest Urn
41: A Data Table with Memory
42: Juror Selection in Court
43: Running Project Costs
44: Forecasting Profits
45: Uncertainty in Sales
46: Exchange Rate Fluctuations
47: Monte Carlo Stock Values
48: Monte Carlo Retirement
49: Monte Carlo and Pi
50: Integration Simulated
51: Two Monte Carlo Integrations
IV. GENETICS
52: Shuffling Chromosomes
53: Sex Determination
54: Mendelian Laws
55: The Hardy-Weinberg Law
56: Genetic Drift
57: Two Selective Forces
58: Balanced Polymorphism
59: Differential Fitness
60: Random Mating
61: Molecular Clock
62: DNA Sequencing
V. SCIENCE
63: Matrix Elimination
64: Interpolation
65: Extrapolation
66: Boltzmann Equation for Sigmoidal Curves
67: Rounding in Excel
68: Simple Decay Simulation
69: Radioactive Decay
70: Michaelis-Menten Equation
71: Chemical Equilibria
72: Spectrum Simulation
73: Oscillations
74: Ballistic Trajectories
75: Logistic Bacterial Growth
76: Predator-Prey Cycle
77: The Course of an Epidemic
78: Taking Medication
79: A Hawk-Dove Game
80: A Population Pyramid
81: False Positives
VI. BUSINESS
82: Cycle Percentiles
83: Profit Estimates
84: Production Costs
85: Profit Changes
86: A Filtering Table
87: Risk Analysis
88: Scenarios
89: Market Growth
90: Target Analysis
91: Fiscal Year
92: Resource Allocation
93: A Traffic Situation
94: Quality Control
95: Logistics
96: Customer Flow
97: Project Delays
VII. FINANCE
98: Smoothing Data
99: Investing Optimized
100: Return on Investment (ROI)
101: Fluctuating APR
102: Loan Payments
103: Buy or Sell Stock?
104: S&P500 Performance
105: Stock Market Analysis
106: Employee Stock Options
107: Stock Volatility
108: Net Present Value
109: Asian Options
110: Black-Scholes Model
111: Value at Risk (VaR)
112: Historical Value at Risk
113: Combined Value at Risk
114: Stock Price Movements
VIII. MISCELLANEA
115: Numbering Records
116: Cracking a Password
117: Area Code Finder
118: Data Management
119: Chart Snapshots
120: Sizing Bins for Frequencies
121: Chart Markers
122: Scrolling Charts
123: Graph Manipulation
124: Creating Gradients
125: Summarizing in Steps
126: A Monthly Calendar
127: Comparison of Values
128: Letter Permutations
129: Metric Conversion
130: Probability of Beliefs

Edition details

• Publisher: CreateSpace Independent Publishing Platform
• Publication date: 2017
• Language: English
• ISBN 10: 1978429878
• ISBN 13: 9781978429871
• Binding: Paperback
• Number of pages: 288