Chapter 1 Instructions
Watch the Against All Odds Video Unit #15
❖ Video Assignment
Answer the following questions as you watch the video.
- Why is the study of the
effect of humans on the coral reefs not an experiment?
- Who were the subjects in the
Glucosamine/Chondroitin study? What did the
researchers want to find out?
- Why were subjects randomly
assigned to the treatments?
- Dr. Confound conducted a
very badly designed experiment on mood-altering
medication. List some of the problems with his experiment.
❖ EXCEL Assignment
*Note: We will use EXCEL to generate random numbers. The instructions are on p. 39 of the textbook. More details are shown in Moodle.
EXCEL Assignment
A business employs 166 workers. The Human Resources Department has a list of workers names labeled 1 to 166. They would like to obtain a random sample of 17 workers. Generate the random sample using the RandBetween function in EXCEL
Load the Data Analysis Toolpak
Use the formula RandBetween to generate random numbers
Use the fill handle to copy the RandBetween formula to adjacent cells