Saturday, August 13, 2011

How do you create statistical distributions in MS Excel?

I want to create 100 random data points that are distributed based upon a normal distribution (a bell curve). I have the mean and standard deviation of the distribution that I want. I am stuck on the problem of generating these data points so that I end up with a majority towards the mean value with a few outliers. Is there a way that I can use the probability that a number will be a specific value to somehow weight a number generated by the random number function? Is there another way to solve this problem that I am not seeing?

No comments:

Post a Comment