Rechercher un cas : 0 résultats

Monte Carlo Simulation in Excel Without Using Add-ins

9B09E004
Résumé
This note gives step-by-step instructions on how to build a Monte Carlo simulation model in Microsoft Excel without using spreadsheet add-ins. The note explains the difference between random and uniformly distributed. The note also explains: how the Excel function RAND() works, how to use Excel functions like NORMINV() to simulate random numbers from distributions other than the uniform; how to use VLOOKUP() with tabulated data to simulate numbers from any arbitrary distribution, and how to use Data Tables to produce multiple iterations of a simulation model. The note concludes with an example that illustrates the use of all of these concepts.
Mots-clés
Spread Sheet Application; Simulation; Models; Uncertainty
Public
Undergraduate/MBA
2009
Livraison par lien de téléchargement
12
Non

Adhérents : 5,10 € HT / Non adhérent : 5,50 € HT
Licence à l'unité*
* Usage unique limité à une session. Prix par étudiant formé. Licence à renouveler pour chaque nouvelle session.

Produits pédagogiques liés ...