Thinking Like an Engineer: An Active Learning Approach (4th Edition)
Thinking Like an Engineer: An Active Learning Approach (4th Edition)
4th Edition
ISBN: 9780134639673
Author: Elizabeth A. Stephan, David R. Bowman, William J. Park, Benjamin L. Sill, Matthew W. Ohland
Publisher: PEARSON
bartleby

Concept explainers

bartleby

Videos

Textbook Question
Book Icon
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. Chapter 10, Problem 15ICA, A bioengineer conducts clinical trials on stressed-out college students to see if a sleep aid will Suppose the formula in part (c) was copied into cell L 18. What will appear in cell L18 when this statement is executed?
Blurred answer
Students have asked these similar questions
For Questions 3 and 4: A cup of water was heated to a temperature of 90°. It was placed in a refrigerator that had a temperature of 11°C. The water cooled to a temperature of 17°C in 30 minutes. Let the following variables represent the relevant quantities. L = Temperature of the liquid S= Temperature of the surroundings t = Time B = Initial temperature of the liquid (Temperature at t = 0 k = Cooling constant 3. Using the Equation Solver, find the value of k in the equation L = (B - S)e -kt + S. Remember to set the equation equal to zero and then enter it into the Solver.
Don't use chatgpt will upvote
2. There were 42 mangoes in each crate. 12 such crates of mangoes were delivered to a factory. 4 mangoes were rotten and had to be thrown away. The remaining mangoes were packed into boxes of 10 mangoes each. Write a numerical expression in MATLAB syntax to represent this situation and then find how many boxes of mangoes were there? OFocus 4:20 AM 28°C Mostly clear 3/26/2022 LG CVENUENS THANOS BOBBLEHEAD AMANLANTE A ON CABIA ANn POCKET YOP! AVENGES KEYCHAIN INFINITY WAR Handy Fan THANOS BOBBLE HEAD IGENA ERANLIA P COs CA AN

Chapter 10 Solutions

Thinking Like an Engineer: An Active Learning Approach (4th Edition)

Ch. 10.6 - In 1980, the Environmental Protection Agency (EPA)...Ch. 10 - A B C D E F 1 2 45 3 meters 4...Ch. 10 - A B C D E F 1 2 45 3 meters 4...Ch. 10 - A B C D E F 1 2 45 3 meters 4...Ch. 10 - A B C D E F 1 2 45 3 meters 4...Ch. 10 - ICA 10-5 The worksheet shown here was designed to...Ch. 10 - The worksheet provided was designed to calculate...Ch. 10 - Some alternate energy technologies, such as wind...Ch. 10 - The worksheet shown was designed to calculate the...Ch. 10 - The worksheet shown was designed to calculate the...Ch. 10 - Refer to the following worksheet. The following...Ch. 10 - Write the output value that would appear in a cell...Ch. 10 - Write the output value that would appear in a cell...Ch. 10 - Refer to the following worksheet. In all...Ch. 10 - Prob. 14ICACh. 10 - A bioengineer conducts clinical trials on...Ch. 10 - Refer to the Worksheet shown, set up to calculate...Ch. 10 - You are interested in analyzing different implant...Ch. 10 - You have a large stock of several values of...Ch. 10 - We accidentally drop a tomato from the balcony of...Ch. 10 - You are interested in calculating the best place...Ch. 10 - 1. A history major of your acquaintance is...Ch. 10 - Prob. 2RQCh. 10 - 3. A phase diagram for carbon and platinum is...Ch. 10 - 4. A simplified phase diagram for cobalt and...Ch. 10 - 5. You enjoy drinking coffee but are particular...Ch. 10 - 6. In the 1950s, a team at Los Alamos National...Ch. 10 - Use the following phase diagram for questions 7...Ch. 10 - Use the following phase diagram for questions 7...Ch. 10 - Use the following phase diagram for questions 9...Ch. 10 - Use the following phase diagram for questions 9...Ch. 10 - 11. When liquid and vapor coexist in a container...Ch. 10 - 12. The ideal gas law assumes that molecules...Ch. 10 - One of the NAE Grand Challenges for Engineering is...Ch. 10 - 15 Create an Excel worksheet that will allow the...Ch. 10 - Prob. 16RQ

Additional Engineering Textbook Solutions

Find more solutions based on key concepts
Knowledge Booster
Background pattern image
Mechanical Engineering
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, mechanical-engineering and related others by exploring similar questions and additional content below.
Similar questions
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
Elements Of Electromagnetics
Mechanical Engineering
ISBN:9780190698614
Author:Sadiku, Matthew N. O.
Publisher:Oxford University Press
Text book image
Mechanics of Materials (10th Edition)
Mechanical Engineering
ISBN:9780134319650
Author:Russell C. Hibbeler
Publisher:PEARSON
Text book image
Thermodynamics: An Engineering Approach
Mechanical Engineering
ISBN:9781259822674
Author:Yunus A. Cengel Dr., Michael A. Boles
Publisher:McGraw-Hill Education
Text book image
Control Systems Engineering
Mechanical Engineering
ISBN:9781118170519
Author:Norman S. Nise
Publisher:WILEY
Text book image
Mechanics of Materials (MindTap Course List)
Mechanical Engineering
ISBN:9781337093347
Author:Barry J. Goodno, James M. Gere
Publisher:Cengage Learning
Text book image
Engineering Mechanics: Statics
Mechanical Engineering
ISBN:9781118807330
Author:James L. Meriam, L. G. Kraige, J. N. Bolton
Publisher:WILEY
Chemical and Phase Equilibrium; Author: LearnChemE;https://www.youtube.com/watch?v=SWhZkU7e8yw;License: Standard Youtube License