Hi friends, I'm running a random walk simulation in Numbers with a number of cells generating random numbers and these cells in turn being referenced across multiple sheets. In other words, Rows 5 and 7 of sheets 1, 2 and 3 are generating the random value and every other cell that refers to these cells fluctuate, including cells in other sheets.
Now in my last sheet, I have 3 values that are the bottom line calculation in my simulation. I want to create another sheet that generates this simulation 100 times and then crete a scatter plot to show a Gaussian distribution so I can generate a reasonable idea of where the average distribution points are for the 3 values. So, the easy way to do this is to create a cell that equals the final result. This is the first simulation. What I need is to create 99 more of those, but each having a different result. Can anyone recommend how to do this? Kevin -- You received this message because you are subscribed to the Google Groups "MacVisionaries" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/macvisionaries. For more options, visit https://groups.google.com/groups/opt_out.
