Gerard M. Verschuuren PhD Excel Simulations

ISBN 13: 9781615470228

Excel Simulations

3.38 avg rating
( 8 ratings by Goodreads )
 
9781615470228: Excel Simulations
View all copies of this ISBN edition:
 
 

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.

"synopsis" may belong to another edition of this title.

From the Back Cover:

a NEW book with 80 different simulationsI. GAMBLING

  • 1. THE DIE IS CAST
  • 2. CASTING SIX DICE
  • 3. FREQUENCIES
  • 4. GAMBLING STRATEGY
  • 5. ROULETTE MACHINE
  • 6. GAMBLER'S RUIN
  • 7. RANDOM WALK
  • 8. CRACKING A PASSWORD
II. STATISTICS
  • 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
III. GENETICS
  • 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
IV. FINANCIAL
  • 32. FLUCTUATING APR
  • 33. RISK ANALYSIS
  • 34. MISSING/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
V. EXPANSION
  • 43. OFFSPRING OF TWO RABBITS
  • 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
VI. MONTE CARLO SIMULATIONS
  • 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 W/ MONTE CARLO
VII. ITERATIONS
  • 62. CIRCULAR REFERENCES
  • 63. COUNTING NEW HITS
  • 64. CIRCULAR GRADIENTS
  • 65. SINGLE-CELL ARRAYS
  • 66. MULTI-CELL ARRAYS
  • 67. SOLVING EQUATIONS
  • 68. LEAST SQUARES METHOD
  • 69. COMBINING SCENARIOS
  • 70. LOGISTICS
VIII. EXTRAS
  • 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. WEATHER FORECAST
IX. APPENDICES
  • 1. LOCKING CELL REFERENCES
  • 2. NESTED FUNCTIONS
  • 3. WHAT-IF TABLES
  • 4. MONTE CARLO SIMULATIONS
  • 5. SIMULATION CONTROLS
X. INDEX

About the Author:

Gerard M. Verschuuren, PhD, is a Microsoft Certified Professional specializing in C#.NET, VB, VBA, and VB.NET. He is the principal of Genesis PC, where he teaches and advises on the use of curve-fitting software such as Excel and XLfit in data, regression, and statistical analyses. His clients include Abbott, Bose, IBM, Liberty Mutual, Massachusetts General Hospital, and Harvard University. He is the author of numerous computer programming books, including Excel 2007 VBA, From VBA to VSTO, Master the Web, and Slide Your Way Through Excel VBA. He lives in Atkinson, New Hampshire.

"About this title" may belong to another edition of this title.

Top Search Results from the AbeBooks Marketplace

1.

Verschuuren, Gerard M., Dr.
ISBN 10: 1615470220 ISBN 13: 9781615470228
New Quantity Available: > 20
Seller:
Paperbackshop-US
(Wood Dale, IL, U.S.A.)
Rating
[?]

Book Description 2013. PAP. Condition: New. New Book. Shipped from US within 10 to 14 business days. Established seller since 2000. Seller Inventory # TI-9781615470228

More information about this seller | Contact this seller

Buy New
US$ 13.95
Convert currency

Add to Basket

Shipping: US$ 3.99
Within U.S.A.
Destination, rates & speeds

2.

Verschuuren, Gerard M, PhD
ISBN 10: 1615470220 ISBN 13: 9781615470228
New Quantity Available: > 20
Seller:
INDOO
(Avenel, NJ, U.S.A.)
Rating
[?]

Book Description Condition: New. Brand New. Seller Inventory # 1615470220

More information about this seller | Contact this seller

Buy New
US$ 14.51
Convert currency

Add to Basket

Shipping: US$ 3.60
Within U.S.A.
Destination, rates & speeds

3.

Verschuuren, Gerard M., Dr.
ISBN 10: 1615470220 ISBN 13: 9781615470228
New Quantity Available: 2
Seller:
Pbshop
(Wood Dale, IL, U.S.A.)
Rating
[?]

Book Description 2013. PAP. Condition: New. New Book.Shipped from US within 10 to 14 business days. Established seller since 2000. Seller Inventory # IB-9781615470228

More information about this seller | Contact this seller

Buy New
US$ 15.73
Convert currency

Add to Basket

Shipping: US$ 3.99
Within U.S.A.
Destination, rates & speeds

4.

Gerard M. Verschuuren
Published by Holy Macro! Books, United States (2013)
ISBN 10: 1615470220 ISBN 13: 9781615470228
New Paperback Quantity Available: 1
Seller:
Book Depository International
(London, United Kingdom)
Rating
[?]

Book Description Holy Macro! Books, United States, 2013. Paperback. Condition: New. Language: English . Brand New Book. Covering a variety of Excel simulations, from gambling to genetics, this introduction is for people interested in modelling 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. Seller Inventory # AAS9781615470228

More information about this seller | Contact this seller

Buy New
US$ 20.26
Convert currency

Add to Basket

Shipping: FREE
From United Kingdom to U.S.A.
Destination, rates & speeds

5.

Gerard M. Verschuuren
Published by Holy Macro! Books, United States (2013)
ISBN 10: 1615470220 ISBN 13: 9781615470228
New Paperback Quantity Available: 1
Seller:
The Book Depository
(London, United Kingdom)
Rating
[?]

Book Description Holy Macro! Books, United States, 2013. Paperback. Condition: New. Language: English . Brand New Book. Covering a variety of Excel simulations, from gambling to genetics, this introduction is for people interested in modelling 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. Seller Inventory # AAS9781615470228

More information about this seller | Contact this seller

Buy New
US$ 20.74
Convert currency

Add to Basket

Shipping: FREE
From United Kingdom to U.S.A.
Destination, rates & speeds

6.

Gerard M. Verschuuren
Published by Holy Macro! Books, United States (2013)
ISBN 10: 1615470220 ISBN 13: 9781615470228
New Paperback Quantity Available: 10
Seller:
Book Depository hard to find
(London, United Kingdom)
Rating
[?]

Book Description Holy Macro! Books, United States, 2013. Paperback. Condition: New. Language: English . This book usually ship within 10-15 business days and we will endeavor to dispatch orders quicker than this where possible. Brand New Book. Covering a variety of Excel simulations, from gambling to genetics, this introduction is for people interested in modelling 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. Seller Inventory # BTE9781615470228

More information about this seller | Contact this seller

Buy New
US$ 21.66
Convert currency

Add to Basket

Shipping: FREE
From United Kingdom to U.S.A.
Destination, rates & speeds

7.

Verschuuren PhD, Gerard M.
Published by Holy Macro! Books
ISBN 10: 1615470220 ISBN 13: 9781615470228
New PAPERBACK Quantity Available: 1
Seller:
Vital Products COM LLC
(Southampton, PA, U.S.A.)
Rating
[?]

Book Description Holy Macro! Books. PAPERBACK. Condition: New. 1615470220. Seller Inventory # Z1615470220ZN

More information about this seller | Contact this seller

Buy New
US$ 23.10
Convert currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, rates & speeds

8.

Verschuuren PhD, Gerard M.
Published by Holy Macro! Books
ISBN 10: 1615470220 ISBN 13: 9781615470228
New PAPERBACK Quantity Available: 1
Seller:
Bookhouse COM LLC
(Philadelphia, PA, U.S.A.)
Rating
[?]

Book Description Holy Macro! Books. PAPERBACK. Condition: New. 1615470220. Seller Inventory # Z1615470220ZN

More information about this seller | Contact this seller

Buy New
US$ 23.10
Convert currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, rates & speeds

9.

Verschuuren PhD, Gerard M.
Published by Holy Macro! Books
ISBN 10: 1615470220 ISBN 13: 9781615470228
New PAPERBACK Quantity Available: 1
Seller:
BookShop4U
(PHILADELPHIA, PA, U.S.A.)
Rating
[?]

Book Description Holy Macro! Books. PAPERBACK. Condition: New. 1615470220. Seller Inventory # Z1615470220ZN

More information about this seller | Contact this seller

Buy New
US$ 23.10
Convert currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, rates & speeds

10.

Verschuuren PhD, Gerard M.
Published by Holy Macro! Books
ISBN 10: 1615470220 ISBN 13: 9781615470228
New PAPERBACK Quantity Available: 1
Seller:
Best Bates
(Bensalem, PA, U.S.A.)
Rating
[?]

Book Description Holy Macro! Books. PAPERBACK. Condition: New. 1615470220. Seller Inventory # Z1615470220ZN

More information about this seller | Contact this seller

Buy New
US$ 23.10
Convert currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, rates & speeds

There are more copies of this book

View all search results for this book