Microsoft Office Tutorials and References
In Depth Information
2.5 End-of-Chapter Practice Problems
1. Suppose that you had cultured various strains of bacteria in a college
microbiology laboratory. You want to study the growth rate of one strain of bacteria.
You have samples of this bacteria strain in 63 test tubes and you would like to
test randomly 15 of these 63 samples.
(a) Set up a spreadsheet of frame numbers for these test tubes with the
heading: FRAME NUMBERS using the Home/Fill commands.
(b) Then, create a separate column to the right of these frame numbers which
duplicates these frame numbers with the title: Duplicate frame numbers.
(c) Then, create a separate column to the right of these duplicate frame
numbers and use the =RAND() function to assign random numbers to all
of the frame numbers in the duplicate frame numbers column, and change
this column format so that 3 decimal places appear for each random
number.
(d) Sort the duplicate frame numbers and random numbers into a random
order.
(e) Print the result so that the spreadsheet ﬁts onto one page.
(f) Circle on your printout the I.D. number of the ﬁrst 15 test tubes that you
would use in your research study.
(g) Save the ﬁle as: RAND9.
Important note:
Note that everyone who does this problem will generate a
different random order of test tube ID numbers since Excel
assigns a different random number each time the RAND()
command is used. For this reason, the answer to this problem
given in this Excel Guide will have a completely different
sequence of random numbers from the random sequence that
you generate. This is normal and what is to be expected.
2. Suppose that you have been hired as a consultant to test building materials for
engineers designing suspension bridges. The engineers of this company are
interested in using a new type of steel in future bridge construction. You have been
given 114 samples of this type of steel and you have been asked to test a random
sample of 10 of these samples for tensile strength in terms of their material
consistency.
(a) Set up a spreadsheet of frame numbers for these steel samples with the