M No 1 2 3 Control Group Average: Standard Deviation: 30 min 4 min 5 Number of Minutes to Fall Asleep Day 1 Day 2 Day 3 Day 4 Day 5 Day 6 Day 7 Reactions Average Time Group 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 OBJECTIVE: To gain experience writing VBA macros using conditional flow. As an aspiring biomedical engineer, you are helping to conduct a clinical trial on stressed-out college students to see if a sleep aid will help them fall asleep faster. The study requires students to take a sleep aid for 7 days and record, through a biofeedback system, the time when they fall asleep. You also have a control group do the same without the use of the sleep aid for comparison purposes. To analyze the data, you set up the Excel worksheet found in the HW9p1.xlsm file, conveniently stored for you on the Community site. The average and standard deviation of the amount of time it takes the control group to fall asleep is provided in cells E3 and E4. Column I labeled Reactions contains any adverse reactions the students reported experiencing (H = headache, N = nausea, HN = both). Add a macro called Analzye Data that will compute and display the following information: Cell J8: The average time to fall asleep for the student Cell K8: The word "MORE" should be displayed for any students who took longer than one standard deviation above the control group average to fall asleep. The word "LESS should be displayed for any students who took less than one standard deviation below the control group average to fall asleep. Nothing should be displayed for any students who fell asleep within one standard deviation of the control group average. Cell L8: The word "SEVERE" should be displayed if it took the student MORE time to fall asleep and if they experienced either headaches, nausea, or both. The word "MILD" should be displayed if the student did not take MORE time to fall asleep, but did experience either headaches, nausea, or both. The word "HELPFUL" should be displayed if the student did not experience headaches or nausea and took LESS time to fall asleep. If the student did not fall into one of the prior categories, the cell should be blank. Test Cases: Time Group MILD Day 1 60 2 24 11 6 28 Day 2 15 37 56 10 I 24 1 Number of Minutes to Fall Asleep Day 3 Day 4 Day 5 | Day 6 Day 7 Reactions Average 21 19 61 16 11 H 29 48 36 44 1958 35 33 64 8 10 49 HN 3 5 3 16 50 9 29 18 12 46 62 40 19 30 23 66 67 55 IN 39 MORE MORE LESS SEVERE HELPFUL 30 MORE SEVERE LIS Parayi api Normal NO Spa OBJECTIVE: To gain experience writing VBA macros using conditional flow. As an aspiring biomedical engineer, you are helping to conduct a clinical trial on stressed-out college students to see if a sleep aid will help them fall asleep faster. The study requires students to take a sleep aid for 7 days and record, through a biofeedback system, the time when they fall asleep. You also have a control group do the same without the use of the sleep aid for comparison purposes. To analyze the data, you set up the Excel worksheet found in the HW9p1.xlsm file, conveniently stored for you on the Community site. The average and standard deviation of the amount of time it takes the control group to fall asleep is provided in cells E3 and E4. Column I labeled Reactions contains any adverse reactions the students reported experiencing (H = headache, N = nausea, HN = both). Add a macro called Analzye Data that will compute and display the following information: Cell J8: The average time to fall asleep for the student Cell K8: The word "MORE" should be displayed for any students who took longer than one standard deviation above the control group average to fall asleep. The word "LESS" should be displayed for any students who took less than one standard deviation below the control group average to fall asleep. Nothing should be displayed for any students who fell asleep within one standard deviation of the control group average Cell L8: The word "SEVERE" should be displayed if it took the student MORE time to fall asleep and if they experienced either headaches, nausea, or both. The word "MILD" should be displayed if the student did not take MORE time to fall asleep, but did experience either headaches, nausea, or both. The word "HELPFUL" should be displayed if the student did not experience headaches or nausea and took LESS time to fall asleep. If the student did not fall into one of the prior categories, the cell should be blank. Test Cases: Day 6 Day 2 Day 2 Reactions Average Time Number of Minutes to Fall Asleep Day 3 Day 4 Days 19 61 36 Day 1 60 2 Day 2 15 37 Group MILD 16 29 58 24 56 10 | HN | 49 29 35 15 18 30 39 MORE MORE LESS SEVERE HELPFUL 50 62 40 28 MORE SEVERE 66 67 55 Save your Excel workbook as HW9pl_TeamXXX_6+2.xlsm A B C D E F G H I J K L Control Group Average: Standard Deviation: 1 30 min 4 min Number of Minutes to Fall Asleep Day 1 Day 2 Day 3 Day 4 Day 5 Day 6 Day 7 Reactions Average Time Group M No 1 2 3 Control Group Average: Standard Deviation: 30 min 4 min 5 Number of Minutes to Fall Asleep Day 1 Day 2 Day 3 Day 4 Day 5 Day 6 Day 7 Reactions Average Time Group 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 OBJECTIVE: To gain experience writing VBA macros using conditional flow. As an aspiring biomedical engineer, you are helping to conduct a clinical trial on stressed-out college students to see if a sleep aid will help them fall asleep faster. The study requires students to take a sleep aid for 7 days and record, through a biofeedback system, the time when they fall asleep. You also have a control group do the same without the use of the sleep aid for comparison purposes. To analyze the data, you set up the Excel worksheet found in the HW9p1.xlsm file, conveniently stored for you on the Community site. The average and standard deviation of the amount of time it takes the control group to fall asleep is provided in cells E3 and E4. Column I labeled Reactions contains any adverse reactions the students reported experiencing (H = headache, N = nausea, HN = both). Add a macro called Analzye Data that will compute and display the following information: Cell J8: The average time to fall asleep for the student Cell K8: The word "MORE" should be displayed for any students who took longer than one standard deviation above the control group average to fall asleep. The word "LESS should be displayed for any students who took less than one standard deviation below the control group average to fall asleep. Nothing should be displayed for any students who fell asleep within one standard deviation of the control group average. Cell L8: The word "SEVERE" should be displayed if it took the student MORE time to fall asleep and if they experienced either headaches, nausea, or both. The word "MILD" should be displayed if the student did not take MORE time to fall asleep, but did experience either headaches, nausea, or both. The word "HELPFUL" should be displayed if the student did not experience headaches or nausea and took LESS time to fall asleep. If the student did not fall into one of the prior categories, the cell should be blank. Test Cases: Time Group MILD Day 1 60 2 24 11 6 28 Day 2 15 37 56 10 I 24 1 Number of Minutes to Fall Asleep Day 3 Day 4 Day 5 | Day 6 Day 7 Reactions Average 21 19 61 16 11 H 29 48 36 44 1958 35 33 64 8 10 49 HN 3 5 3 16 50 9 29 18 12 46 62 40 19 30 23 66 67 55 IN 39 MORE MORE LESS SEVERE HELPFUL 30 MORE SEVERE LIS Parayi api Normal NO Spa OBJECTIVE: To gain experience writing VBA macros using conditional flow. As an aspiring biomedical engineer, you are helping to conduct a clinical trial on stressed-out college students to see if a sleep aid will help them fall asleep faster. The study requires students to take a sleep aid for 7 days and record, through a biofeedback system, the time when they fall asleep. You also have a control group do the same without the use of the sleep aid for comparison purposes. To analyze the data, you set up the Excel worksheet found in the HW9p1.xlsm file, conveniently stored for you on the Community site. The average and standard deviation of the amount of time it takes the control group to fall asleep is provided in cells E3 and E4. Column I labeled Reactions contains any adverse reactions the students reported experiencing (H = headache, N = nausea, HN = both). Add a macro called Analzye Data that will compute and display the following information: Cell J8: The average time to fall asleep for the student Cell K8: The word "MORE" should be displayed for any students who took longer than one standard deviation above the control group average to fall asleep. The word "LESS" should be displayed for any students who took less than one standard deviation below the control group average to fall asleep. Nothing should be displayed for any students who fell asleep within one standard deviation of the control group average Cell L8: The word "SEVERE" should be displayed if it took the student MORE time to fall asleep and if they experienced either headaches, nausea, or both. The word "MILD" should be displayed if the student did not take MORE time to fall asleep, but did experience either headaches, nausea, or both. The word "HELPFUL" should be displayed if the student did not experience headaches or nausea and took LESS time to fall asleep. If the student did not fall into one of the prior categories, the cell should be blank. Test Cases: Day 6 Day 2 Day 2 Reactions Average Time Number of Minutes to Fall Asleep Day 3 Day 4 Days 19 61 36 Day 1 60 2 Day 2 15 37 Group MILD 16 29 58 24 56 10 | HN | 49 29 35 15 18 30 39 MORE MORE LESS SEVERE HELPFUL 50 62 40 28 MORE SEVERE 66 67 55 Save your Excel workbook as HW9pl_TeamXXX_6+2.xlsm A B C D E F G H I J K L Control Group Average: Standard Deviation: 1 30 min 4 min Number of Minutes to Fall Asleep Day 1 Day 2 Day 3 Day 4 Day 5 Day 6 Day 7 Reactions Average Time Group