Use the RAND function in Excel to generate 100 values from a U (0, 1) distribution.

(a) Calculate the average and compare it to 0.5, the expected value for a random sample between 0 and 1.

(b) For the RAND function sample, cluster the results into cells of 0.1 width that is 0.0-0.1, 0.1-0.2, etc., where the upper-limit value is excluded from each cell. Determine the probability for each grouping from the results. Does your sample come close to having approximately 10% in each cell?