Simulation in Excel and VBA

Name: Simulation in Excel and VBA (English version)
SKU: 9B11E031

Mehmet A. Begen; Wei Xia

Product #:9B11E031

Supplier:Ivey

Discipline:Management Science

Setting:2011

Details:Case (PDF) • 24 pages • 2011-10-17

Subjects:

Analytics and data science Data science

Your Price:

$9.71

Purchase this material with a free Educator Account and enjoy more benefits:

Free Educator Copy
Free Teaching Notes
Build your coursepack
Discounted academic price

This note is an introduction to simulation in Excel and VBA. The note uses examples to demonstrate different methods of doing simulation in Excel and VBA (Visual Basic for Applications). Concepts explained in this note include random number generation, probability distributions, data tables, loops and arrays, histograms, and descriptive statistics.

Learning Objectives

The note can be used as an introductory reading or as lecture notes in any course that teaches and/or requires simulation in Excel and VBA.