Random Normal Distribution Example

Here is a Google Drive link to the example Excel sheet I showed in 1st block this morning.

To generate the random numbers I used NORMINV(RAND ( ), 65, 5).  I made up a mean of 65 and a standard deviation of 5.  Then I dragged down 100 cells.

To build the confidence intervals, I went to cell B1, typed in an equals sign, clicked on cell A1, then did a minus, 1.96 * my standard deviation, and then divided by SQRT (n).  

If you hold the cursor over any of the cells in Row 1 you will see what I typed in.

Email or Tweet me if you have questions.  Math IV projects are due Monday.