Microsoft Office Tutorials and References
In Depth Information
(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 fits onto one page.
(f) Circle on your printout the I.D. number of the first 10 steel samples that
would be used in this research study.
(g) Save the file as: RANDOM6.
3. Suppose that a biology field researcher wants to take a random sample of 20 of
75 wild field mice that have been collected from the prairie grass that grows
above the bluffs along the Mississippi River in Elsah, Illinois for a field
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 fits onto one page.
(f) Circle on your printout the I.D. number of the first 20 mice that the field
biologist should select for her study.
(g) Save the file as: RAND5.
Search JabSto ::




Custom Search