This is the probability that a random value from the distribution is less than a given value x. Is it possible to create a set of normally distributed values in Excel? Yes, it is, but we will need to look at the cumulative distribution function F(x)=P(X<=x) and it's inverse function. Create a Normally Distributed Set of Random Numbers in Excel We can see the result is a nice bell shaped curve centered around the mean value. If we select our table then go to the Insert tab and select a Line Chart from the Charts section.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |