Using Excel Use a population with a normal distribution to general (by excel sim

Question

Using Excel

Use a population with a normal distribution to general (by excel simulation) blocks of 1000 different random samples. After generating 1000 samples of size n=4 and 1000 samples of size n=80, and computing samples means and variances, you need to make histograms to show that the sample means and sample variances. Also you need to show that the mean of sample means and the standard deviation of sample means agree with the CLTH theory.

Template

The final result will have 2 tabbed worksheets like this, one for n=4 and one for n=80, plus a set of histograms on separate sheets.

Normal Popluation Mean 0 Normal population std dev 1 Sample n (put value) Mean of sample means by CLTH (put value) Std deviation of sample means by CLTH (compute value) Sample mean mean =average of row 10 Sample s =stdev of row 10 Sample means =average1 =average2 =average3 Etc ........ ---> to ALM (1000 samples) or IQ (250 s Sample s =stdev1 =stdev2 =stdev3 Etc ........ ---> Sample variance =b8^ =c8^2 =d8^ Etc ........ ---> Sample1 val sample2 val sample3 val Etc ........ ---> to ALM (1000 samples) or IQ (250 samples) Block of ........ ........ ......... ........ ........ ........ sample columns ........ ......... ........ ......... ........ ........ of n random numbers ........ ........ ......... ........ ........ .........

Explanation / Answer

1.02

Similarly we can obtained for n =80

Normal Popluation Mean 0 Normal population std dev 1 Sample n 4 Mean of sample means by CLTH 0.0244 Std deviation of sample means by CLTH 0.924 Sample mean mean 0.75 Sample s

1.02

Related Questions

Navigate

• Browse (All)
• Browse U
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.