Quick and Clean simulation in MS Excel: a brief tutorial

This presentation was an introduction to doing simulation in MS Excel, using the Data Table function, presented by Dr. Dennis Sweitzer.

View pictures taken at the meeting.

The presentation covered (or provided in sample spreadsheets):

• The basic method
• Using inverse probability functions for validation, verification, and insigh
• Some basic macros for setting u
• VBA code for some missing probability function
• Examples (from clinical trials
• Advantages, Disadvantages, and Limitation

Documents

Dr Sweitzer has provided the slides of his presentation and associated Excel files for viewing and or download

• Presentation slides
• Examples
• Template

Additional Resources

Additional information is available at Dr. Sweitzer's web site.

Dennis E. Sweitzer, Ph.D.
610.202.8736 (cell)
610.857.7456 (home)
www.Dennis-Sweitzer.com