Microsoft Office Tutorials and References
In Depth Information
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
Objective: To create the frame numbers for generating random numbers
A3: FRAME NO.
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:
T. J. Quirk et al., Excel 2010 for Biological and Life Sciences Statistics,
Springer Science+Business Media New York 2013
Search JabSto ::