Chapter 10, Problem 15ICA

A bioengineer conducts clinical trials on stressed-out college students to see if a sleep aid will help them fall asleep faster. She begins the study by having 20 students take a sleep aid for seven days and records through biofeedback the time when they fall asleep. To analyze the data, she sets up the following worksheet. Evaluate the expressions that follow; state what will appear in the cell when the command is executed. Column I contains the average time each student took to fall asleep during the seven-day trial. Column J contains any adverse reactions the students experienced (H = headache; N = nausea).

1. a. Column K will contain the rating of the time it took the student to fall asleep compared with the control group, who did not take the medication. The statement as it appears in cell K14 is given below. What will appear in cell K14 when this statement is executed?

   =IF> (I14>$I$2 + $I$3, ”MORE”, IF (I14 < $I$2 – $I$3, “LESS”,” ”))

2. b. Column L groups the participants into three groups according to their reaction to the drug and the time it took them to fall asleep. Assume the statement for part (a) is executed in column K. The statement as it appears in cell L7 is given below. What will appear in cell L7 when this statement is executed?

   =IF (AND(K7=”MORE”,J7=”H”), ”'MH”,

   IF(AND(K7=”MORE” ,J7=”N”), ”MN”,””)

   ------

3. c. Suppose the formula in column L was changed to regroup the participants. The statement as it appears in cell L9 is given below. In Excel, this statement would appear as a continuous line, but because of space restrictions it is shown here on two lines. What will appear in cell L9 when this statement is executed?

   =IF (AND (K7=“MORE” ,OR(J9=“H”, J9=“'N”)), “SEVERE”,

   IF (OR (J9=“'H”, J9=“'N”), “'MILD”, IF (K9=“'LESS”,“HELPFUL”,“”))

4. d. Suppose the formula in part (c) was copied into cell L 16. What will appear in cell L16 when this statement is executed?
5. e. Suppose the formula in part (c) was copied into cell L 18. What will appear in cell L18 when this statement is executed?