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 define 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 identification code (ID) of the number 1 that is assigned to the first
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 first 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 first 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,
DOI: 10.1007/978-1-4614-5779-4_2,
Springer Science+Business Media New York 2013
21
Search JabSto ::




Custom Search