# (Computer project) Use the = RAND( ) function in your spreadsheet to create 100 samples of size 25..

(Computer project) Use the = RAND( ) function in your
spreadsheet to create 100 samples of size 25 (which are effectively all from
the same population). Compute the mean and standard deviation of each sample.
Calculate the z score for each sample, using a hypothesised mean of 0.5 (since the
= RAND( ) function chooses a random number in the range 0 to 1).

Don't use plagiarized sources. Get Your Custom Essay on
(Computer project) Use the = RAND( ) function in your spreadsheet to create 100 samples of size 25..
For as low as \$13/Page

(a) How many of the z scores would you expect to exceed 1.96
in absolute value? Explain why.

(b) How many do exceed this? Is this in line with your
prediction?

(c) Graph the sample means and comment upon the shape of the
distribution. Shade in the area of the graph beyond z = ±1.96.

## Order a unique copy of this paper

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
\$26