Does Google Spreadsheet support Monte Carlo simulation?

Posted by:

In their raw form, no, not really. Like excel, they have random functions that allow for single, randomized trials based off of certain criteria, but also like excel, Google Sheets require additional programming through addons and extensions (or VBA or additional addons for excel) in order to actually perform any quantity of randomized trials where n > 1.

With that said, you might be able to find extensions (or create your own) that will allow you to run monte carlo simulations. A commercial option, Risk Solver (traditionally used in excel), can be found here: Risk Solver – Google Sheets add-on.


Add a Comment