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:

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