Using Monte Carlo Simulations

The Monte Carlo method can be used to analyze data with help of random number generators. This includes for example finding approximate maximum and minimum for a given formula/function or simulating real data like measurements or observations.

In GS-Calc the Monte Carlo simulations are executed by specifying "Input" worksheet cells or ranges which are filled with ("pseudo-") random numbers in loops and "Output" cells which contain formulas processing these numbers. Large numbers of loops enable collecting statistically meaningful number of results of those formulas and verifying how they will behave for real "Input" data.

The following menus and commands related to the MC simulations are available in GS-Calc: