Microsoft Office Tutorials and References
In Depth Information
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
(b) Then, create a separate column to the right of these frame numbers which
duplicates these frame numbers with the title: Duplicate frame no.
(c) Then, create a separate column to the right of these duplicate frame numbers
entitled “Random number” and use the ¼ RAND() function to assign random
numbers to all of the frame numbers in the duplicate frame numbers column.
Then, 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 10 steel samples that
would be used in this research study.
(g) Save the ﬁle as: RANDOM6
3. Suppose that a biology ﬁeld researcher wants to take a random sample of 20 of
75 wild ﬁeld mice that have been collected from the prairie grass that grows
above the bluffs along the Mississippi River in Elsah, Illinois for a ﬁeld research
study.
(a) Set up a spreadsheet of frame numbers for these mice with the heading:
FRAME NUMBERS.
(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
entitled “Random number” and use the
RAND() function to assign random
numbers to all of the frame numbers in the duplicate frame numbers column.
Then, 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 20 mice that the ﬁeld
biologist should select for her study.
(g) Save the ﬁle as: RAND5
¼
References
There are no references at the end of Chapter 2
Search JabSto ::

Custom Search