Skip to ContentSkip to Navigation
Expertisecentrum CIBIFOnderdeel van Rijksuniversiteit Groningen

Expertisecentrum CIBIF

Faculteit Economie en Bedrijfskunde
Centre of Expertise CIBIFFor students

Monte Carlo Simulation in Excel

Using the Data Table function of Excel allows you to do Monte Carlo simulations in a very efficient way. In this youtube video, we show you how to test dynamic asset allocation strategies using using a Monte Carlo simulation experiment in Excel. You can find the Data Table function under "Data", in the main menu. Then select "What-If Analysis", and finally "Data Table".

You can also download the Excel file used in this video.

Laatst gewijzigd:12 november 2018 09:40
printView this page in: English