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