Generating Normal Distribution Data

May 16, 2006 at 1:59 pm 1 comment

Category: Built-in Formula
Level: Intermediate

If u are a statistician or a researcher, this tip must be very important. Generating normal distribution data in Excel is very easy. Using formula NORMINV, u can get the data following normal distribution.

NORMINV(probability, mean, standard deviation)
Returns the inverse of the normal cumulative distribution for the specified mean and standard deviation.
Probability is a probability corresponding to the normal distribution.
Mean is the arithmetic mean of the distribution.
Standard deviation is the standard deviation of the distribution.

For example, I want to generate 50 data following normal distribution with mean 100 and Standard Deviation 5.

Put the parameters in E5 for mean and E6 for standard deviation
Write this formula in range B8:F17


And tada…. U can check the accuracy of mean and standard deviation using AVERAGE and STDEV formula. See cell of E21 and E22.


Entry filed under: Formula, Sedeng.


1 Comment Add your own

  • 1. santy  |  April 5, 2008 at 8:06 pm

    Mau tanya, gimana rumus untuk menghitung nilai , jika 60 kolom nilai berwarna biru, thank’s ya.


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

Trackback this post  |  Subscribe to the comments via RSS Feed

We Moved!

Kami telah pindah ke

Tweet XQ

Kapsul XQ Terkini



RSS Kapsul XQ
RSS Komentar XQ

# Blog Walkers
web tracker

My Popularity (by

Creative Commons License

%d bloggers like this: