random numbers with mean and stdev fixed

[yamboe]

Hello everyone! So i'm having a excel problem here... I want to build a program thats generates a n diferent sequences of 3 numbers , between 1-15, with a certain standard deviation and mean . Its no problem to have the same numbers in the sequence(for exemple 2-3-14 and 2-3-13), only if the program generates exactly equals ones. Can anyone help me ? =)

[MrShorty]

The approach I usually see is to use Excel's uniform random number generator and put it into the NORM.DIST() function (or the NORMDIST() function if you need compatibility with older versions of Excel): https://support.office.com/en-us/art...rs=en-US&ad=US =NORM.DIST(rand(),mean,standarddeviation,FALSE)

[yamboe]

thank you mr. shorty!