Books / Verschuuren 100 Excel Simulations

Using Excel to Model Risk, Investments, Genetics, Growth, Gambling and Monte Carlo Analysis
1. Auflage 2025
ISBN: 978-1-83702-902-0
Verlag: De Gruyter
Format: EPUB
Kopierschutz: 0 - No protection

E-Book, Englisch, 227 Seiten

This book dives deep into the art of creating realistic simulations using Excel. Starting with simple concepts like dice rolls and roulette, it gradually introduces advanced scenarios in genetics, finance, and statistics. Each example is designed to help readers understand the principles of modeling and problem-solving with step-by-step guidance.
Readers will explore Monte Carlo simulations, hypothesis testing, and iterative techniques to tackle real-world challenges. The book covers diverse applications, such as risk analysis, DNA sequencing, and stock market predictions. It emphasizes practical approaches that make complex techniques accessible, even for users with basic Excel skills.
By the end, readers will have hands-on experience designing and testing custom simulations for various fields. Whether analyzing traffic patterns, forecasting market trends, or studying population dynamics, this book equips users with the tools and confidence to address multifaceted problems effectively.

Autoren/Hrsg.

Books, MrExcel's Holy Macro!

Verschuuren, Dr. Gerard

Verschuuren, Gerard

Fachgebiete

• Mathematik | Informatik EDV | Informatik Daten / Datenbanken

Über Autor(innen)

Books MrExcel's Holy Macro! :

Holy Macro! Books has been providing top-quality books on Excel, Power Query, and Power BI since 2002. They have published over 100 titles by 30 authors, including numerous Microsoft MVPs.Verschuuren Dr. Gerard :

Dr. Gerard Verschuuren is a Microsoft Certified Professional specializing in 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.