Use the discrete random number generator to create baths trial data for 500 rows of 3 houses at a time. IV) ** Create a frequency table and histogram for the sample means: take the simulated bath data averaged by row (3 houses at a time), create a column of those 500 averages, and determine their frequency. V) Compare the mean and variance of this averaged column of data to that of the unaveraged data in 3 III) above. You should find that the mean of the averaged data is quite close to the mean of the raw data, but the variance is much smaller. ** Summarize those findings **Lastly, rearrange the worksheets so the first 3 contain all your answers for Q1, 2, and 3. You should rename these worksheets, as well as any relevant additional worksheets to make clear which questions they are based on. Next Previous