Computer Exercise

Generate one series of data for Bernoulli distribution, Binomial Distribution, Uniform distribution and Normal distribution with the Random Number Generator from Excel as shown in Class. The number of data points for each series should be 100.

(1) Please write down the probability distribution function of your data.

(2) Generate 50 series for each of the distribution in question one, then calculated the average of each series, we call this sample averages. Now that you have 50 sample averages, plot the histogram of your average (to save time, use the automatically assigned bin range). Then answer the following question

a. How does your histogram assemble the probability distribution of normal distribution?

b. What is the average of the sample averages? What is mean of your sample averages? Compare with your population data.