Hi
I'm a beginner using Excel to do more advanced stuff than inserting chart and using simple formulas.
Now i need simulate data in 10 cells with a fixed standard deviation and a fixed mean
Example: Simulating the laptime for a runner where the mean should be 50 and the standard deviation 5,
I tried typing
=50+5*RAND()*(-1^(RANDBETWEEN(1;2)))
That gives me a mean close to 50 which is good but th standard deviation is no where near 5.
Anyone who knows how to solve this problem?
Thanks
Arvid
Bookmarks