Consider the problem of sampling from a population which consists of the salaries for public sector employees

Question:

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.

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Business Statistics Using Excel

ISBN: 9780199659517

2nd Edition

Authors: Glyn Davis, Branko Pecar

Question Posted: