Statistics?

It is a lab assigment for Stat243 on excel 

Youmust do your own work. Make sure to answer the final questions in your own words.

The examples shown below do not use the actual distributions. The real assignment is at the end.
Please read the instructions carefully.

Example 1
Binomial (n = 20, p = 0.4)

 Put “x” in cell A1.

 Put “f(x)” in cell B1.

 In cells A2 through A4, enter “0”, “1”, and “2”.

 Highlight these last three cells. Put the cursor in
the lower right corner of the cell and start drag-
ging down until it shows the number “20”. Re-
lease.

Lab 3: Discrete Distributions
Stat 243 Fall 2013 due November 14

 Go to cell B2.

 Click on fx.

 Choose the Statistical category and then
BINOMDIST.

 For Number_s type “A2” (the location of the
first X value).

 For Trials, type “20”.

 For Probability_s, type “.4”.

 For Cumulative, type “0”.

 Click OK.

 Put the cursor in the lower right corner of this
cell and drag down to copy.

 Highlight all the cells containing probabilities.
Click FormatCellsNumber, enter “5”
for the number of decimal places, and click OK.

Example 2
Hypergeometric (N = 500, r = 100, n =15)

 Put “x” in cell D1.

 Put “f(x)” in cell E1.

 In cells D2 through D4, enter “0”, “1”, and “2”.

 Highlight these last three cells. Put the cursor in
the lower right corner of the cell and start drag-
ging down until it shows the number “15”. Re-
lease.

 Go to cell E2.

 Click on fx.

 Choose the Statistical category and then
HYPGEOMDIST.

 For Sample_s type “D2” (the location of the
first X value).

 For Number_sample, type “15”.

 For Population_s, type “100”.

 For Number_pop, type “500”.

 Click OK.

 Put the cursor in the lower right corner of this
cell and drag down to copy.
 Highlight all the cells containing probabilities.
Click FormatCellsNumber, enter “5”
for the number of decimal places, and click OK.

Example 3
Poisson (μ = 5)

 Put “x” in cell G1.

 Put “f(x)” in cell H1.

 In cells G2 through G4, enter “0”, “1”, and “2”.

 Highlight these last three cells. Put the cursor in
the lower right corner of the cell and start drag-
ging down until it shows the number “30”. Re-
lease. Remember that, in the Poisson distribu-
tion, there is no upper limit for the X values,
so at the end you will have to go back and de-
termine where to end the list.

 Go to cell H2.

 Click on fx.

 Choose the Statistical category and then
POISSON.

 For X type “G2” (the location of the first X val-
ue).

 For Mean, type “5”.

 For Cumulative, type “0”.
 Click OK.

 Put the cursor in the lower right corner of this
cell and drag down to copy.

 Highlight all the cells containing probabilities.
Click FormatCellsNumber, enter “5”
for the number of decimal places, and click OK.

 Now go back and find the first cell where the
probability is zero to 5 decimal places. Delete
all entries after this one. (Only do this for the
Poisson example. For the other 2 cases, there is
a highest value that X can take on.)

Lab 3 (due Thursday, November 14)

1. Generate the binomial distribution with n = 25 and p = 0.4.

2. Generate the hypergeometric distribution with N = 100, r = 40, and n = 25.

3. Generate the Poisson distribution with μ = 10.

4. Show all of your results side-by-side on a single page, with all probabilities formatted to 5 decimal
places.

5. In each distribution, identify the mode. That is, find the place where the probability is at its maximum,
and circle or highlight that value.

6. In your own words, comment on something that you find interesting about these three distributions.
(How do their means compare? Or their modes? Or their shapes?)