Microsoft Office Tutorials and References

In Depth Information

Chapter 2

Random Number Generator

Suppose that a local poultry farmer is raising a variety of laying hens and that he is

interested in the egg production of a particular breed of hens (Breed X). Suppose

that he has asked you to take a random sample of 5 of Breed X’s 32 laying hens to

identify overall egg production of this breed. Using your Excel skills to determine

egg production, you will need to deﬁne a “sampling frame.” A sampling frame is a

list of objects, events, or people from which you want to select a random sample. In

this case, it is the group of 32 chickens. The frame starts with the identiﬁcation code

(ID) of the number 1 that is assigned to the ﬁrst hen in the group of 32 laying hens

on the poultry farm. The second hen has a code number of 2, the third a code

number of 3, and so forth until the last hen has a code number of 32.

Since the poultry farm has 32 Breed X hens, your sampling frame would go from

1 to 32 with each hen having a unique ID number.

We will ﬁrst create the frame numbers as follows in a new Excel worksheet:

2.1 Creating Frame Numbers for Generating Random

Numbers

Objective
: To create the frame numbers for generating random

numbers

A3: FRAME NO.

A4: 1

Now, create the frame numbers in column A with the Home/Fill commands that

were explained in the ﬁrst chapter of this topic (see Sect. 1.4.1) so that the frame

numbers go from 1 to 32 , with the number 32 in cell A35. If you need to be

reminded about how to do that, here are the steps:

Click on cell A4 to select this cell

Home

T.J. Quirk et al.,
Excel 2007 for Biological and Life Sciences Statistics
,

DOI 10.1007/978-1-4614-6003-9_2,
#
Springer Science+Business Media New York 2013

19

Search JabSto ::

Custom Search