100 Excel Simulations
eBook - PDF

100 Excel Simulations

Using Excel to Model Risk, Investments, Genetics, Growth, Gambling and Monte Carlo Analysis

  1. 227 pages
  2. English
  3. PDF
  4. Available on iOS & Android
eBook - PDF

100 Excel Simulations

Using Excel to Model Risk, Investments, Genetics, Growth, Gambling and Monte Carlo Analysis

About this book

No detailed description available for "100 Excel Simulations".

Trusted by 375,005 students

Access to over 1.5 million titles for a fair monthly price.

Study more efficiently using our study tools.

Information

Publisher
Packt Publishing Limited
Year
2025
eBook ISBN
9781837029020
Topic
Computer Science
Index
Computer Science

Table of contents

  1. First Chapter
  2. Copyright page
  3. Title page
  4. _GoBack
  5. Gambling
  6. 1. The Die Is Cast
  7. 2. Casting Six Dice
  8. 3. Frequencies
  9. 4. Roulette Machine
  10. 5. Gambler’s Ruin
  11. 6. Random Walk
  12. 7. Gambling Strategy
  13. 8. Cracking a Password
  14. Statistics
  15. 10. The Mean of Means
  16. 11. Sampling
  17. 12. The Normal Distribution
  18. 13. Normalizing
  19. 14. Repeats
  20. 15. Confidence Margins
  21. 16. Power Curves
  22. 17. Hidden Peaks
  23. 18. Sampling Sizes
  24. 19. Quality Control
  25. Genetics
  26. 21. Sex Determination
  27. 22. Radiation and Mutation
  28. 23. Mendel
  29. 24. Hardy-Weinberg Law
  30. 25. Genetic Drift
  31. 26. Lethal Homozygote
  32. 27. Reduced Vitality
  33. 28. Two Selective Forces
  34. 29. Balanced Equilibrium
  35. 30. Molecular Clock
  36. 31. DNA Sequencing
  37. Financial
  38. 33. Risk Analysis
  39. 34. Missing or Exceeding Targets
  40. 35. Two-Dimensional Filters
  41. 36. Scenarios
  42. 37. Moving Averages
  43. 38. Return on Investment
  44. 39. Employee Stock Options
  45. 40. Value at Risk
  46. 41. Asian Options
  47. 42. Black-Scholes Model
  48. Expansion
  49. 44. Extrapolation
  50. 45. Predator-Prey Cycle
  51. 46. Homeostasis
  52. 47. Taking Medication
  53. 48. Population Pyramid
  54. 49. Titration
  55. 50. EC50 Determination
  56. 51. Converter
  57. 52. Conditional Training
  58. 53. Epidemics
  59. Monte Carlo Simulations
  60. 55. Brownian Motion
  61. 56. A Traffic Situation
  62. 57. Uncertainties in Sales
  63. 58. Exchange Rate Fluctuations
  64. 59. Cost Estimates
  65. 60. Market Growth
  66. 61. Integration with Monte Carlo
  67. Iterations
  68. 63. Win or Lose?
  69. 64. Circular Gradients
  70. 65. Single-Cell Arrays
  71. 66. Data Management
  72. 67. Solving Equations
  73. 68. Least Squares Method
  74. 69. Combining Scenarios
  75. 70. Logistics
  76. Extras
  77. 72. Graph Manipulation
  78. 73. Detecting Outliers
  79. 74. False Positives
  80. 75. Probability of Beliefs
  81. 76. Unbiased Sampling
  82. 77. Numbering Records
  83. 78. Fiscal Year
  84. 79. Stock Market
  85. 80. Forecasting Temperatures
  86. Miscellanea
  87. 82. Graph Manipulation
  88. 83. Simulation of a Slot Machine
  89. 84. Letter Game
  90. 85. A Hawk-Dove Simulation
  91. 86. Flock Behavior
  92. 87. Simulation of Sick Cases
  93. 88. Ehrenfest’s Urn Simulation
  94. 89. Two Monte Carlo Integrations
  95. 90. Randomness in Gene Pools
  96. 91. Random Mating
  97. 92. Differences in Fitness
  98. 93. Loan Simulation
  99. 94. Stock Volatility
  100. 95. S&P 500 Performance
  101. 96. Scenario Risks
  102. 97. Temperature Fluctuations
  103. 98. Juror Selection
  104. 99. Waiting Time Simulation
  105. 100. Project Delays
  106. Appendices
  107. 1. Locking Cell References
  108. 2. Nested functions
  109. 3. What-If Tables
  110. 5. Simulation Controls
  111. Index
  112. Blank Page

Frequently asked questions

Yes, you can cancel anytime from the Subscription tab in your account settings on the Perlego website. Your subscription will stay active until the end of your current billing period. Learn how to cancel your subscription
No, books cannot be downloaded as external files, such as PDFs, for use outside of Perlego. However, you can download books within the Perlego app for offline reading on mobile or tablet. Learn how to download books offline
Perlego offers two plans: Essential and Complete
  • Essential is ideal for learners and professionals who enjoy exploring a wide range of subjects. Access the Essential Library with 800,000+ trusted titles and best-sellers across business, personal growth, and the humanities. Includes unlimited reading time and Standard Read Aloud voice.
  • Complete: Perfect for advanced learners and researchers needing full, unrestricted access. Unlock 1.5M+ books across hundreds of subjects, including academic and specialized titles. The Complete Plan also includes advanced features like Premium Read Aloud and Research Assistant.
Both plans are available with monthly, semester, or annual billing cycles.
We are an online textbook subscription service, where you can get access to an entire online library for less than the price of a single book per month. With over 1.5 million books across 990+ topics, we’ve got you covered! Learn about our mission
Look out for the read-aloud symbol on your next book to see if you can listen to it. The read-aloud tool reads text aloud for you, highlighting the text as it is being read. You can pause it, speed it up and slow it down. Learn more about Read Aloud
Yes! You can use the Perlego app on both iOS and Android devices to read anytime, anywhere — even offline. Perfect for commutes or when you’re on the go.
Please note we cannot support devices running on iOS 13 and Android 7 or earlier. Learn more about using the app
Yes, you can access 100 Excel Simulations by MrExcel's Holy Macro! Books,Dr. Gerard Verschuuren in PDF and/or ePUB format. We have over 1.5 million books available in our catalogue for you to explore.