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.
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.
posted by F-Xtudent at
1:59 PM
0 Comments:
Post a Comment
<< Home