Written by: STATISTICA 11/3/2009 4:22 PM
We recently received another interesting question from twitter.
How can I generate random normal distribution numbers with known mean and SD?
You need to use spreadsheet formulas. For example....
We want to generate random normal distribution numbers based on the average height of French women. It was 161.9 cm in 2001. And we want to use 2 standard deviations.
Start by creating a new spreadsheet or add a new variable to an open spreadsheet. I named my variable French Women Height.
Double click on the variable name. This will open the Variable Specs dialog. Click your mouse in the Long name field.
You can browse through the formulas by clicking on the Functions button. Or you can just start typing....
You want a random normal distribution, so type =r. A list of functions pops up.
Select RndNormal(x). x is your standard deviation. The final formula looks like:
=RndNormal(2)+ 161.9
Click OK to generate the random numbers.
Related Blogs How To Get X,Y Values for Regression Line How to Print More Than One Item from a Workbook without Printing the Entire Workbook How to Prevent the "Are You Sure" Dialog from Being Displayed How to Import an Excel File to STATISTICA
0 comment(s) so far...