Question: This is an excel question. I need the input statements to enter in excel for each column. Problem 3: As an aspiring biomedical engineer, you

This is an excel question. I need the input statements to enter in excel for each column.
 This is an excel question. I need the input statements to
enter in excel for each column. Problem 3: As an aspiring biomedical

Problem 3: 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 You begin the study by having 20 students take a sleep aid for 7 days and record, through biofeedback, the time when they fall asleep. To analyze the data, you set up the Excel worksheet labeled Problem 3 in the Homework 5 workbook. Column K labeled Reactions contains any adverse reactions the students reported experiencing (H = headache, N = nausea). Complete the worksheet by adding Excel formulas to columns J, L and M, which should display information based on the following: Column J Compute and display the average time to fall asleep for each student to the nearest whole number Column L: -The word MORE" should be displayed for any students who took longer than one standard deviation from the group average to fall asleep control took less than one standard deviation from the control group average to fall asleep within one standard deviation of the control The word "LESS" should be displayed for any students who Nothing should be displayed for any students who fell asleep group average Column M 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. When SEVERE is shown, the font color should change to dark red and the cell fill color to light red. -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. When MILD is shown, the font color should change to dark yellow and the cell fill color to light yellow The word "HELPFUL" should be displayed if the student did not experience headaches or time to fall asleep. When HELPFUL is shown, the font color should change to dark green and the cell fill color to light green. nausea and took LESS .If the student did not fall into one of the prior categories, the cell should be blank

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!