LinkBack URL
About LinkBacks
I would like to generate a set of random real numbers within certain rang (-n to +n) and have predefined mean and standard deviation
Please Help
I would like to generate a set of random real numbers within certain rang (-n to +n) and have predefined mean and standard deviation
Please Help
You mean truncated normal random deviates?
Entia non sunt multiplicanda sine necessitate
No , the mean not equal to standard deviation
Pardon ?
Sorry;
Please ignore my last reply
It is truncated normal random deviates
To be clear in my question I need to generate 2300 random number between -1.65 to 2.2 with mean 0.5 and slandered deviation 1.2 is it possible by excel
Please Login or Register to view this content.
Thank you very much
I have a problem
The calculated Mean and SD is not as the input values. Please see attachment
Last edited by ahmedhattab; 02-21-2013 at 06:31 AM.
If you truncate a normal distribution, of course the SD of the surviving values changes -- you chopped off the tails.
If you truncate it asymmetrically, of course the mean of the surviving values changes -- you chopped more off one side than the other. Quantitatively, the mean changes to
= mean + SD^2 * (NORMDIST(lower, mean, SD, FALSE) - NORMDIST(upper, mean, SD, FALSE)) / Z
where Z = NORMDIST(upper, mean, SD, TRUE) - NORMDIST(lower, mean, SD, TRUE)
If you had a bunch of random values that had a certain mean and standard deviation, but a truncated distribution, those would not be normal deviates.
Last edited by shg; 02-21-2013 at 03:00 PM.
Excellent. Thank you for your help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks