This problem demonstrates the Central Limit Theorem at work. In

This problem demonstrates the Central Limit Theorem at work. In your spreadsheet, use the =RAND() function to generate a random sample of 25 observations (I suggest entering this function in cells A4:A28, for example). Copy these cells across 100 columns, to generate 100 samples. In row 29, calculate the mean of each sample. Now examine the distribution of these sample means. You will find the RAND() function recalculates automatically every time you perform an operation in the spreadsheet. This makes it difficult to complete the analysis. The solution is to copy and then use ‘Edit, Paste Special, Values’ to create a copy of the values of the sample means. These will remain stable.

(a) What distribution would you expect them to have?

(b) What is the parent distribution from which the samples are drawn?

(c) What are the parameters of the parent distribution and of the sample means?

(d) Do your results accord with what you would expect?

(e) Draw up a frequency table of the sample means and graph it. Does it look as you expected?

(f) Experiment with different sample sizes and with different parent distributions to see the effect that these have.

How Our Website Works


It has never been easier to place your order. Fill in the initial requirements in the small order form located on the home page and press “continue” button to proceed to the main order form or press “order” button in the header menu. Starting from there let our system intuitively guide you through all steps of ordering process.


All your payments are processed securely through PayPal. This enables us to guarantee a 100% security of your funds and process payments swiftly.


Next, we match up your order details with the most qualified freelance writer in your field.


Once we have found the most suitable writer for your assignment, they start working on a masterpiece just for you!


Once finished, your final paper will be available for download through your personal dashboard. You will also receive an email notification with a copy of your paper attached to it. Sometimes, the writer may leave a note for you about the order in case there is any additional information that they need to give you.

Leave a Reply

Your email address will not be published.