| Description |
1 online resource. |
| Note |
Print version record. |
| Summary |
Annotation 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. The simulations covered offer a fun alternative to the usual Excel topics and include situations such as roulette, password cracking, sex determination, population growth, and traffic patterns, among many others. |
| 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. |
| Subject |
Microsoft Excel (Computer file)
|
|
Microsoft Excel (Computer file) (OCoLC)fst01366659
|
|
Digital computer simulation.
|
|
Computer simulation.
|
|
COMPUTERS -- Desktop Applications -- Spreadsheets.
|
|
MATHEMATICS -- Applied.
|
|
MATHEMATICS -- Probability & Statistics -- General.
|
|
Computer simulation. (OCoLC)fst00872518
|
|
Digital computer simulation. (OCoLC)fst00893651
|
|
Commercial statistics.
|
| Genre/Form |
Electronic books.
|
| Other Form: |
Print version: 9781306013246 |
| ISBN |
9781306013246 (electronic bk.) |
|
1306013240 (electronic bk.) |
|
9781615472154 (electronic bk.) |
|
1615472150 (electronic bk.) |
|
9781615471157 (electronic bk.) |
|
1615471154 (electronic bk.) |
|
9781615473359 (electronic bk.) |
|
1615473351 (electronic bk.) |
|
