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.