Lab 3 Simulation-2

How to Do Part 4;

Generating 500 sample means, all of size 35, from a binomial distribution where p = .1 the number or trials is 10.

How To Generate the 500 Samples Using Excel:

  1. In the Data menu, click on Data Analysis…
    • Scroll down and select Random Number Generation.  Click OK.
    • Fill out the window (window configuration may vary, but all the information is the same) using the following values then click OK:
      Random Number Generation Picture
       
      • Warning! You will need to change the distribution to Binomial BEFORE you will be able to edit the Random seed value.
      • For the Random Seed, use the last three numbers of any group member's phone number.
  2. While all the data is still selected, click on Home -> Cells Format -> AutoFit Column Width.
  3. Think of each row as a sample of 35 x values from a binomial population based on n=10 and p=0.1

How To Find the 500 Sample's Means Using Excel:

  1. With the cursor in cell AJ1 type the following: =AVERAGE(a1:ai1). Press the ENTER key. The mean for that sample will appear in cell AJ1.

    Find the Average of the Samples

  2. Select cell AJ1 again and click on Home, then Copy.
  3. Next select ALL cells in column AJ from row 1 all the way down to row 500 then click on Home, then Paste.

How To Create The Histogram Of 500 Sample Means Using Excel:

  1. In the Data menu, click on Data Analysis.
  • Scroll down and select Histogram, then click OK.
  • Fill out the window with the following values and boxes checked and click OK:
    • Input Range: AJ1:AJ500
    • Leave the Bin range blank and Excel will decide on the appropriate classes for you.
    • The Output Range is AM1.
    • Be sure the Chart output box is checked!
    • Create the Histogram
  • Carefully hover the mouse pointer over one of the histogram bars and double click.Histogram OutputHistogram after the gap between bars is removed.
  • A formatting window will appear titled Chart Tools. Click on the Layout tab then Format Selection and change the Gap width to 0. Click on Close.
  • Click once on the outermost perimeter of the graph to resize it to make it look "nice".  Your histogram should look very close to this:

Histogram Final Product

How To Calculate The Mean And Standard Deviation Of The 500 Sample Means Using Excel:

  1. Select a free cell and type the following: =AVERAGE(aj1:aj500).  This will get you the mean of the sample means.
  2. Select another free cell and type the following: =STDEV.S(aj1:aj500).  This will get you the standard deviation of the sample means.