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

=NORMINV(RAND(),$E$5,$E$6)

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. Tags: .

AVERAGEIF Formula SUMIF Formula

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.

    Reply

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s

Trackback this post  |  Subscribe to the comments via RSS Feed


We Moved!

Kami telah pindah ke www.excelquotient.com

Tweet XQ

Kapsul XQ Terkini

Archives

Annex


Langganan
RSS Kapsul XQ
RSS Komentar XQ

# Blog Walkers
web tracker

Ranks
My Popularity (by popuri.us)

Lisensi
Creative Commons License

%d bloggers like this: