1 option
100 excel simulations : using excel to model risk, investments, genetics, growth, gambling and Monte Carlo analysis / Gerard M. Verschuuren.
- Format:
- Book
- Author/Creator:
- Verschuuren, G. M. N. (Geert M. N.), author.
- Language:
- English
- Subjects (All):
- Microsoft Excel (Computer file).
- Digital computer simulation.
- Computer simulation.
- Physical Description:
- 1 online resource (227 p.)
- Edition:
- 1st ed.
- Place of Publication:
- Merritt Island, Florida : Holy Macro! Books, 2017.
- Summary:
- 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.
- Contents:
- Cover
- Preface
- Instructions
- Title Page
- Copyright
- Contents
- 1. The Die Is Cast
- 2. Casting Six Dice
- 3. Frequencies
- 4. Roulette Machine
- 5. Gambler's Ruin
- 6. Random Walk
- 7. Gambling Strategy
- 8. Cracking a Password
- 9. A Fair Coin?
- 10. The Mean of Means
- 11. Sampling
- 12. The Normal Distribution
- 13. Normalizing
- 14. Repeats
- 15. Confidence Margins
- 16. Power Curves
- 17. Hidden Peaks
- 18. Sampling Sizes
- 19. Quality Control
- 20. Chromosomes
- 21. Sex Determination
- 22. Radiation and Mutation
- 23. Mendel
- 24. Hardy-Weinberg Law
- 25. Genetic Drift
- 26. Lethal Homozygote
- 27. Reduced Vitality
- 28. Two Selective Forces
- 29. Balanced Equilibrium
- 30. Molecular Clock
- 31. DNA Sequencing
- 32. Fluctuating APR
- 33. Risk Analysis
- 34. Missing or Exceeding Targets
- 35. Two-Dimensional Filters
- 36. Scenarios
- 37. Moving Averages
- 38. Return on Investment
- 39. Employee Stock Options
- 40. Value at Risk
- 41. Asian Options
- 42. Black-Scholes Model
- Expansion
- 44. Extrapolation
- 45. Predator-Prey Cycle
- 46. Homeostasis
- 47. Taking Medication
- 48. Population Pyramid
- 49. Titration
- 50. EC50 Determination
- 51. Converter
- 52. Conditional Training
- 53. Epidemics
- 54. How Random Is Random?
- 55. Brownian Motion
- 56. A Traffic Situation
- 57. Uncertainties in Sales
- 58. Exchange Rate Fluctuations
- 59. Cost Estimates
- 60. Market Growth
- 61. Integration with Monte Carlo
- 62. Circular References
- 63. Win or Lose?
- 64. Circular Gradients
- 65. Single-Cell Arrays
- 66. Data Management
- 67. Solving Equations
- 68. Least Squares Method
- 69. Combining Scenarios
- 70. Logistics
- 71. Area Code Finder
- 72. Graph Manipulation
- 73. Detecting Outliers
- 74. False Positives
- 75. Probability of Beliefs.
- 76. Unbiased Sampling
- 77. Numbering Records
- 78. Fiscal Year
- 79. Stock Market
- 80. Forecasting Temperatures
- Miscellanea
- 82. Graph Manipulation
- 83. Simulation of a Slot Machine
- 84. Letter Game
- 85. A Hawk-Dove Simulation
- 86. Flock Behavior
- 87. Simulation of Sick Cases
- 88. Ehrenfest's Urn Simulation
- 89. Two Monte Carlo Integrations
- 90. Randomness in Gene Pools
- 91. Random Mating
- 92. Differences in Fitness
- 93. Loan Simulation
- 94. Stock Volatility
- 95. S&
- P 500 Performance
- 96. Scenario Risks
- 97. Temperature Fluctuations
- 98. Juror Selection
- 99. Waiting Time Simulation
- 100. Project Delays
- Appendices
- 1. Locking Cell References
- 2. Nested functions
- 3. What-If Tables
- 4. Monte Carlo Simulations
- 5. Simulation Controls
- Index.
- Notes:
- "Using Excel to Model Risk, Investments, Genetics, Growth, Gambling and Monte Carlo Analysis"--Cover.
- Includes index.
- Description based on print version record.
- Description based on publisher supplied metadata and other sources.
- ISBN:
- 1-61547-234-7
- OCLC:
- 959148663
The Penn Libraries is committed to describing library materials using current, accurate, and responsible language. If you discover outdated or inaccurate language, please fill out this feedback form to report it and suggest alternative language.