Consider the problem of sampling from a population which consists of the salaries for public sector employees employed by a national government. The historical data suggests that the population data is normally distributed with mean of €45,000 and standard deviation of €10,000. We can use Excel to generate ‘N’ random samples with each sample containing ‘n’ data values.

(a) Create 10 random samples each with 1000 data points.

(b) Calculate the mean for each random sample.

(c) Plot the histogram representing the sampling distribution for the sample mean.