I didnt know how to edit the previous post, but I have changed slightly what Faseeh had to randbetween 0 and 500 and then divide by 100. This was the only way I could get figures such as 0.02 The technique I used in my attempt would not let me get anything less than 0.1 and I think there are...
Wow this is perfect, I had concerns about how exactly I could get 0.08 into the simulation, so my tutor adviced me to start at 0.1, then I was able to use the formula in the excel sheet attached. But your method seems much better...
Hi guys, just an update,
I have my limits at 0.1 and 2.5, and have set 5000 random numbers (within this range) using excel. I am using a normal distribution, can someone point me in the right direction, Im a little lost.
Thanks
Hi Faseeh and Hui,
Thanks for your reply, I have done no ground work Im afraid as I am very confused with where to begin,
This is the first time I have run practical simulation of my own, I have done just very basic stuff like mann whitney, z test etc mainly looking at differences between...
Hi guys,
I have not been using these forums very long, but take an interest in some of the topics now and again (just registered now to ask this question)
Anyway, I am looking to run a monte carlo simulation using Excel for a risk management module at university. Basically from a list of...