## Generating Normal Distribution Data

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.

• 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.

## We Moved!

Kami telah pindah ke www.excelquotient.com

## Komentar Terkini

 mangkum on Bukunya Abimono: 50 Jurus Raha… Din on Bukunya Abimono: 50 Jurus Raha… Gravcode Studio Jasa… on Download Tabel dari Internet… Daryatna on Bekerja Efisien dengan Ex… Muhammad Tahir on Bukunya Abimono: 50 Jurus Raha… marzuki on Bukunya Abimono: 50 Jurus Raha… Jufriansyah Al-Banja… on Bukunya Abimono: 50 Jurus Raha…

Langganan