Lab 1 – The Sampling Distribution Using Excel

It is reasonable to assume that the speeds follow a normal distribution with mean 50 mph and standard deviation 16 mph. These can be simulated using the NORMINV function in Excel. We shall take 100 samples, in rows 16 to 115 of the worksheet. Part 1 Procedure: In . B15. enter the value 1 to indicate the first car in the sample. ................
................