« Owen Densmore: Open Source Research, A Quiet Revolution | Main | Fraktalbloggare? »
december 11, 2004
Monte Carlo Simulation in Excel: A Practical Guide
Monte Carlo Simulation in Excel: A Practical Guide:
Monte Carlo simulation is often used in business for risk and decision analysis, to help make decisions given uncertainties in market trends, fluctuations, and other uncertain factors. In the science and engineering communities, MC simulation is often used for uncertainty analysis, optimization, and reliability-based design. In manufacturing, MC methods are used to help allocate tolerances in order to reduce cost. There are certainly other fields that employ MC methods, and there are also times when MC is not practical (for extremely large problems, computer speed is still an issue). However, MC continues to gain popularity, and is often used as a benchmark for evaluating other statistical methods.
This article will guide you through the process of performing a Monte Carlo simulation using Microsoft Excel. Although Excel will not always be the best place to run a scientific simulation, the basics are easily explained with just a few simple examples.
Se även
The Basics of Monte Carlo Simulations
MathWorld: Monte Carlo Method (med referenser)
Posted by hakank at december 11, 2004 08:45 EM Posted to Statistik/data-analys