statistic hw

Create a Excel document. Each question and graph should be a separate spreadsheet.

There should be 7 spreadsheets in the document., one spreadsheet for each ‘*’ marked

below.

1*What are the major types of sampling? Give examples

Using Excel

2*Construct a set of 100 Random numbers between 0 and 10 [10*RAND()] (Copy –paste

Values to stabilize them and for following steps).

Using the rule of 2k, construct a histogram.

For the random numbers in 2.a - compare the actual mean and standard deviation to the expected

mean and standard deviation for a uniform distribution

3*Using the 100 numbers compute 96 means of 5 numbers each

Construct a histogram using the same categories as in 2.b

Compute the mean and standard deviation.

4*Compute z scores

What % of the distribution is between +- 1.0 and between +-.5 and how does this compare to the

Normal distribution?

Determine the probability for the z score or a lower z score for the z scores computed in 2.g.

[=NORM.S.DIST(z,TRUE)]Compare their average to the expected average.

Using Excel

5*Using the 100 numbers compute 81 means of 20 numbers each

Construct a histogram using the same categories as in 2.b

Compute the mean and standard deviation.

6*Compute z scores

What % of the distribution is between +- 1.0 and between +-.5 and how does this compare to the

Normal distribution?

Determine the probability for the z score or a lower z score for the z scores computed in 3.d.

[=NORM.S.DIST(z,TRUE)]Compare their average to the expected average.

7* Do your conclusions support the Law of Large Numbers and why?