Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I am trying to do a Monte Carlo simulation using Excel, but a lot of the tutorials I have found are either for older versions of the product, or are not quite what I am after. A simple example of the kind of think I am after is:

Cell A1 contains the formula to simulate (for example int(6*rand())+1 to simulate rolling a dice).

I have 10 rows of "Trials". What I want is to somehow point each row at a different calculation of the formula in A1. So I would end up with something like

Trial   Value 
1       2
2       5
3       6
4       2
5       1
6       3
7       2
8       4
9       2
10      1

I have tried playing with some of the "What-if Analysis" tools, but I am a bit lost.

share|improve this question

2 Answers 2

Have you tried copying the formula in cell A1 (or B2, if we are to believe your illustration) down into the next nine cells below it?

share|improve this answer

The answer is to populate the field where I have the word "Value" with a link to the calculation, then use the "TABLE" function to fill the rows beneath it, either with a substitutable parameter or not. The placement of the cell with the initial answer is the critical step.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.