學門類別
最新個案
- Leadership Imperatives in an AI World
- Vodafone Idea Merger - Unpacking IS Integration Strategies
- V21 Landmarks Pvt. Ltd: Scaling Newer Heights in Real Estate Entrepreneurship
- Snapchat’s Dilemma: Growth or Financial Sustainability
- Did I Just Cross the Line and Harass a Colleague?
- Predicting the Future Impacts of AI: McLuhan’s Tetrad Framework
- Porsche Drive (A) and (B): Student Spreadsheet
- Porsche Drive (B): Vehicle Subscription Strategy
- TNT Assignment: Financial Ratio Code Cracker
- Winsol: An Opportunity For Solar Expansion
Simulation in Excel and VBA
內容大綱
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.
學習目標
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.