We specialize in hard to find items
All Categories
130 Excel Simulations in Action: Simulations to Model Risk, Gambling, Statistics, Monte Carlo Analysis, Science, Business and Finance
Share Tweet
*Price and Stocks may change without prior notice
*Packaging of actual item may differ from photo shown
- Electrical items MAY be 110 volts.
- 7 Day Return Policy
- All products are genuine and original
About 130 Excel Simulations In Action: Simulations To
Product Description 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. Review This book covers a variety of Excel simulations, from gambling to genetics. The 130 simulations covered offer an exciting and fun alternative to the usual Excel topics and include situations such as roulette, sex determination, population growth, and traffic patterns, among 125 others. Bill Jelen, MrExcel.com------------------------------------------------------Having taught programming and computer science since 1963 and seen a myriad of textbooks, it is a real pleasure to get Dr Gerard Verschuuren's book on Excel Simulations. It is definitely the best "Learn by examples" computer book I have ever seen.Ole Hebin, Prof. Emeritus, University of Copenhagen and Northwestern------------------------------------------------------This book has an impressive breadth of examples from different areas. The writing is very straightforward and explanations seem very understandable for the beginning student. The companion website is an extraordinary resource!Dr. Bud Banis, Professor of Logistics,University of Missouri, St. Louis 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 Opt
