Concept explainers
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).
- 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”,” ”))
- 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”,””)
------
- 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”,“”))
- d. Suppose the formula in part (c) was copied into cell L 16. What will appear in cell L16 when this statement is executed?
- e. Suppose the formula in part (c) was copied into cell L 18. What will appear in cell L18 when this statement is executed?
Want to see the full answer?
Check out a sample textbook solutionChapter 10 Solutions
Thinking Like an Engineer: An Active Learning Approach (3rd Edition)
Additional Engineering Textbook Solutions
Machine Tool Practices (10th Edition)
Thermodynamics: An Engineering Approach
Fluid Mechanics: Fundamentals and Applications
Introduction To Finite Element Analysis And Design
INTERNATIONAL EDITION---Engineering Mechanics: Statics, 14th edition (SI unit)
Applied Statics and Strength of Materials (6th Edition)
- Posted below is a picture of a data table and a diagram of an experiment. In the experiment you rolled a marble down a ruler ramp off the end of a coffee table to observe projectiles and conservation of energy. You do 3 trials for each initial height. Each height is measured in meters. h= initial height of marble off of table Y= height of table off floor X= horizontal distance marble goes from edge of table to where it strikes the floor a) use the table to find information you need to solve for theoretical range and % of error in measured range.arrow_forwardA company finds that if they price their product at $ 65, they can sell 690 items of it. For every dollar increase in the price, the number of items sold will decrease by 10. What is the maximum revenue possible in this situation? (Do not use commas when entering the answer) $ What price will guarantee the maximum revenue? $ Submit Question 國山品 12 MacBook Air esc 吕口 F3 F2 F4 F7arrow_forwardYou own a wheat warehouse with a capacity of 20,000bushels. At the beginning of month 1, you have 6,000 bushels of wheat. Each month, wheat can be bought and sold at theprice per 1000 bushels given in Table 46.The sequence of events during each month is as follows:a You observe your initial stock of wheat.b You can sell any amount of wheat up to your initialstock at the current month’s selling price.c You can buy (at the current month’s buying price) asmuch wheat as you want, subject to the warehouse sizelimitation.Your goal is to formulate an LP that can be used to determine how to maximize the profit earned over the next 10monthsarrow_forward
- You are a biomedical engineer working for a small orthopaedic firm that fabricates rectangular shaped fracture fixation plates from titanium alloy (model = "Ti Fix-It") materials. A recent clinical report documents some problems with the plates implanted into fractured limbs. Specifically, some plates have become permanently bent while patients are in rehab and doing partial weight bearing activities. Your boss asks you to review the technical report that was generated by the previous test engineer (whose job you now have!) and used to verify the design. The brief report states the following... "Ti Fix-It plates were manufactured from Ti-6Al-4V (grade 5) and machined into solid 150 mm long beams with a 4 mm thick and 15 mm wide cross section. Each Ti Fix-It plate was loaded in equilibrium in a 4-point bending test (set-up configuration is provided in drawing below), with an applied load of 1000N. The maximum stress in this set-up was less than the yield stress for the Ti-6Al-4V…arrow_forwardOn an alien planet, the law that expresses the flow of blood through a blood vessel, F, as a function of the radius r of the vessel is f=kr5/2where k is a constant. Certain geological features of this planet produce a gas that changes the radius of blood vessels by 5% at the time of inhalation. What would the corresponding increase in blood flow through the vessel at this time be? Write 1-2 sentences explaining how you found your answer.arrow_forwardNewton's Law of cooling states that the rate at which heat is lost by a heated body is proportional to the difference in temperature between the body and the surrounding medium. Match the following statements/phrases with the corresponding item in the drop down box. Choices in the box 1. In accordance with the stated law obove, we have the equation? 2. If a thermometer is taken outdoors where the temperoture is 5 deg C, from a room in which the temperature is 20 deg C and the reading drops 10 deg C in one minute, the working equation is? 3. In the obove problem, separoting the variables and integrating will result to? 4. In the obove problem, how long, in minutes, after its removal from the room will the reading be 6 deg C? 5. In the obove problem, ofter 30 seconds, whot will be the thermometer reading? 5.2 dT(body temp)/dt = k(Temp of medium - 5) dr(body temp)/dt = k(Temp of body - Temp of medium) Temp of body = Cenkt +5 2.5 13.7 dr(body temp)/dt = k(Temp of medium - Temp of body)…arrow_forward
- Hi, I need help with the first part of the problem below because I'm very confused about how P1 and P2 should be calculated. If you look at my notes to solve the problem there is already a formula in place as I always thought the Patm should also be multiplied by the Area in the numerator, but it's not if I look at this specific tutorial solution given by my course but it's not explained why. I have done a while ago a very similar problem with using that formula in my notes and it gave me the right results, but it's not working for this one. Could you please help me understand why as I have a test coming soon? Figure Q3 (see image attached) shows a cylinder and pistonenclosing air, the movement of the pistonbeing restrained by a compression spring ofstiffness 20 kN/m. The air is heated andexpands, the piston moving 0.3 m. Thefree length of the spring is 1.0 m.Calculate the work done by the air duringthe process.If the pressure , volume and internal energyof air are related by the…arrow_forward3) Body mass index (BMI) of a person is a measure of body fat based on height and weight. In U.S. customary units it is calculated by: BMI = 703" %D where W is the person's weight in pounds and h is the heights in inches. Write a MATLAB program in a script file that calculates the BMI. For input the program asks the user to enter his/her weight and height. The pro- gram then calculates the BMI rounded to the nearest tenth. For output the program displays the message: "The BMI is: XX." where XX is the value of the BMI. Determine the BMI of a 68-in.-tall person that weigh162 lb.arrow_forwardRow indexing: Snow fall records stateSnowRecord contains the amount of snow fall (in cm) for various cities. Rows represent a city and columns represent the snow fall for a given month. Assign citySnow Record with all elements of row rowNum. Ex: If stateSnowRecord is [17.3, 20.3; 4.8, 6.2] and rowNum is 2, then citySnowRecord is [4.8, 6.2]. Function > 6 % 7 % 8 9 10 11 12 13 end function citySnowRecord = Get CitySnowFall (stateSnowRecord, rowNum) 2% Get CitySnow Fall: Returns all snow fall values for city in row rowNum % 4 % Inputs: stateSnowRecord matrix of snow fall records for cities for various months rowNum specified row of stateSnowRecord to return stateSnowRecord = [17.3, 20.3; 4.8, 6.2] Outputs: citySnowRecord - all snow fall values for a given city % Assign citySnowRecord with all elements of a row rowNum. citySnowRecord = stateSnowRecord (rowNum, :); Code to call your function > 1 GetCitySnow Fall([17.3, 20.3; 4.8, 6.2], 2) Previous Assessment: 1 of 2 Tests Passed (50%) Save…arrow_forward
- 1) A low-friction cart is placed between two identical springs attached to rigid walls. If you push the cart against one of the springs and release it, it will continue to move back and forth between the springs. www Draw a force-time graph showing the sum of the horizontal forces exerted on the cart as it moves back and force between the springs. Scientific Abilities Is able to construct a force diagram Missing No representation is constructed. Inadequate FD is constructed but contains major errors such as incorrect mislabeled or not labeled force vectors, length of vectors, wrong direction, extra incorrect vectors are added, or vectors are missing. Needs Improvement FD contains no errors in vectors but lacks a key feature such as labels of forces with two subscripts or vectors are not drawn from single point, or axes are missing. Adequate The diagram contains no errors and each force is labeled so that it is clearly understood what each force represents. Explain whether or not this…arrow_forwardFor the air compressor shown in Figure below, the air enters from a large area and exit from small one, explain why? Instructions for answering this question: The answer to this questian is required as handwritten where you are aiso required to add a Handwritten integrity Statement. Pieose follow the below steps: 1 Write on a blank poper your AUM student ID, full name, course code, section and date 2 Write the following integrity statement and sign: "7 offirm that I have neither given nor received any help on this assessment and that personally compieted it on my own." 3. Write your onswer to the obove question as required 4. Put your Original Civil ID card or AUM ID card on the poper 5 Toke o picture or scan, and uplood Important note: if handwritten document is submitted without the integrity stotement including ID (Civil ID or AUM ID), then the related handwritten question(s) will not be groded.arrow_forwardI was going over the equations for the notes in class and I had a thought. Based on the equations in the image, you could get negative propellant mass. So, I coded it in matlab and I got negative mass. How is that possible? I think I used practical values for the velocity and mass ratio and so on. Did I do something wrong?arrow_forward
- Elements Of ElectromagneticsMechanical EngineeringISBN:9780190698614Author:Sadiku, Matthew N. O.Publisher:Oxford University PressMechanics of Materials (10th Edition)Mechanical EngineeringISBN:9780134319650Author:Russell C. HibbelerPublisher:PEARSONThermodynamics: An Engineering ApproachMechanical EngineeringISBN:9781259822674Author:Yunus A. Cengel Dr., Michael A. BolesPublisher:McGraw-Hill Education
- Control Systems EngineeringMechanical EngineeringISBN:9781118170519Author:Norman S. NisePublisher:WILEYMechanics of Materials (MindTap Course List)Mechanical EngineeringISBN:9781337093347Author:Barry J. Goodno, James M. GerePublisher:Cengage LearningEngineering Mechanics: StaticsMechanical EngineeringISBN:9781118807330Author:James L. Meriam, L. G. Kraige, J. N. BoltonPublisher:WILEY