title: Excel how to find real random data set from mean and standard deviation?
body: <p>In Excel it is easy to find the mean and standard deviation given 10 single data points.  But is it possible to generate 10 random data points in Excel given the mean and standard devation?</p>
  
  <p>In Excel I can right click "View Code" and access a macro to use macro coding, but how would I go about coding this?</p>
  
  <pre><code>Sub rand()
    Range("B4").Formula = "=NORMINV(RAND(),$B$14,$B$15)"
    Range("B4").Calculate
    Range("B4").Value = Range("B4").Value
    Range("B5").Formula = "=NORMINV(RAND(),$B$14,$B$15)"
    Range("B5").Calculate
    Range("B5").Value = Range("B5").Value
    Range("B6").Formula = "=NORMINV(RAND(),$B$14,$B$15)"
    Range("B6").Calculate
    Range("B6").Value = Range("B6").Value
    Range("B7").Formula = "=NORMINV(RAND(),$B$14,$B$15)"
    Range("B7").Calculate
    Range("B7").Value = Range("B7").Value
    Range("B8").Formula = "=NORMINV(RAND(),$B$14,$B$15)"
    Range("B8").Calculate
    Range("B8").Value = Range("B8").Value
    Range("B9").Formula = "=NORMINV(RAND(),$B$14,$B$15)"
    Range("B9").Calculate
    Range("B9").Value = Range("B9").Value
    Range("B10").Formula = "=NORMINV(RAND(),$B$14,$B$15)"
    Range("B10").Calculate
    Range("B10").Value = Range("B10").Value
    Range("B11").Formula = "=NORMINV(RAND(),$B$14,$B$15)"
    Range("B11").Calculate
    Range("B11").Value = Range("B11").Value
    Range("B12").Formula = "=NORMINV(RAND(),$B$14,$B$15)"
    Range("B12").Calculate
    Range("B12").Value = Range("B12").Value
    Range("B13").Formula = "=NORMINV(RAND(),$B$14,$B$15)"
    Range("B13").Calculate
    Range("B13").Value = Range("B13").Value
  End Sub
  </code></pre>
  
  <p>This is my random data generated based on mean and std dev, then i will use this data to find mean and std dev, if the mean and std dev did not mean the value i want then redo until it correct, so what code i need to add to make it redo?</p>