Excel Simulations / Gerard M. Verschuuren.
Annotation
Saved in:
| Online Access: |
Full Text (via Skillsoft) |
|---|---|
| Main Author: | |
| Format: | Electronic eBook |
| Language: | English |
| Published: |
Uniontown, OH :
Holy Macro! Books,
2013.
|
| Subjects: |
Table of Contents:
- Front Cover; Title page; Copyright page; Contents; Preface; Gambling; 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; Statistics; 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; Genetics; 21. Sex Determination; 22. Radiation and Mutation; 23. Mendel; 24. Hardy-Weinberg Law; 25. Genetic Drift; 26. Lethal Homozygote.
- 27. Reduced Vitality28. Two Selective Forces; 29. Balanced Equilibrium; 30. Molecular Clock; 31. DNA Sequencing; Financial; 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; Monte Carlo Simulations.
- 55. Brownian Motion56. A Traffic Situation; 57. Uncertainties in Sales; 58. Exchange Rate Fluctuations; 59. Cost Estimates; 60. Market Growth; 61. Integration with Monte Carlo; Iterations; 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; Extras; 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; Appendices.
- 1. Locking Cell References2. Nested functions; 3. What-If Tables; 5. Simulation Controls; Index.