I have a function that produce a series of Pi using Monte Carlo.
Is there a way I can use it in a loop so that it recalculates all its values of Pi each iteration?
Solved! Go to Solution.
If its really a function (of a dummy argument) and you call it within a loop with, lets say, the loop counter as argument, the function will create new random number every time and give you a different result.
For more help you'll have to show what you've done so far by attaching your worksheet.
I needed to generate three data sets of 100 determinations of Pi but using increasing number of darts thrown each time (I used 100, 1000, 10000). The problem I was having is that the CalcPi(N) function I used wouldn't update its values when I tried to use it in my loop within my function PiDS(N,D) (Data Sets of Pi where N is number of darts thrown and D is number of determinations of Pi to make and parse into array). The way I fixed it is by using a temp array and set it to CalcPi(1) before setting it to CalcPi(N) each iteration, that way it made the function generate a new array each time. Not sure if there is a proper way of doing it. Hope I made sense...
Thanks for the help.
Not sure if there is a proper way of doing it.
Hard to say without seeing what exactly you have done.