Question: Use the = RAND( ) function in your spreadsheet to create 100 samples of size 25 (which are effectively all from the same population). Compute

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).

(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.

Step by Step Solution

3.38 Rating (157 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

To address these questions lets go through them step by step First well simulate the process ... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Statistics Economics Accounting Questions!