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 Approach, Student Value Edition Plus MyLab Engineering with Pearson eText - Access Card Package (4th 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)
- Hartley Electronics, Inc., in Nashville, producesshort runs of custom airwave scanners for the defense industry.The owner, Janet Hartley, has asked you to reduce inventory byintroducing a kanban system. After several hours of analysis, youdevelop the following data for scanner connectors used in onework cell. How many kanbans do you need for this connector?Daily demand 1,000 connectorsLead time 2 daysSafety stock 12 dayKanban size 500 connectorsarrow_forward1. The development of thermodynamics since the 17th century, which was pioneered by the invention of the steam engine in England, and was followed by thermodynamic scientists such as Willian Rankine, Rudolph Clausius, and Lord Kelvin in the 19th century. explain what the findings or theories of the 3 inventors are! Please answer fast max 25-30.minutes thank uarrow_forwardA firm is attempting to minimize its shipping costs. The firm has 3 factories and must supply the needs of its 3 customers without shortages. Since the firm has no storage facilities, each factory must make daily shipments to its customers. The table below shows the capacity of each factory, the amount required by each customer, and the cost of shipping from each factory to each customer. Complete the table below to show the quantity shipped from each factory to each customer. (Leave no cells blank - be certain to enter "0" wherever required.) Shipping Costs ($/unit) Factory/Capacity Customer 1 Customer 2 Customer 3 A/100 units 11 5 9 B/180 units 8 7 8 C/130 units 12 7 10 Requirement— 205 units Requirement— 68 units Requirement— 137 units What is the total cost of meeting customer requirements each day?arrow_forward
- 1. In general, what pattern do you notice between the force due to the gravity of the masses and the displacement of the spring? 2. What is the physical meaning of the slope? 3. Using the slope for each spring, what would be the force required to stretch the spring 0.10 m? 4. Using the slope for each spring, what would be the amount of stretch with a 500 g mass hanging on the spring? Ps: pls refer to the graph belowarrow_forwardYou are working for a medical device start-up company as a design engineer. Your first task is to make measurements on the flow of blood plasma through your prototype. The device specifications require that 37°C plasma flow into the device pass through a bank of 100 tubes (0.2mm diameter), then exit the device. The total flow rate for the device must be 800 ml min^-1. If you want to maintain a pressure drop across each tube below 100 pascals, what is the maximum length of the tube in centimeters?arrow_forwardPart (a) How many times, x, does the cable pass over the pulley within the crane? (Assume that the tension in each segment of the rope is the same Part (b) Assuming that the positive y-direction is up, input an expression for the sum of the forces acting on the car in the y-direction, in terms of the force produced by the crane's motor, F, and the given variables. Assume the motor pulls at a constant velocity. Part (c) What is the minimum force, in Newtons, the crane's motor must provide to begin to move the car? d) Assuming the crane's motor is producing a force of F = 1500 N on the car, what is the car's acceleration, in meters per square second?arrow_forward
- 5. What is the degree of freedom if the number of independent equations are 5 and the number of unknowns is 7. Is the problem over-specified or under-specified? 6. Write a general statement for the unsteady state mass balance. Write a similar statement describing activity in a bank account related to monetary balance.arrow_forwardNewton’s 2nd Law Lab (Modeling friendly lab) Go to the PhET simulation Forces & Motion. https://phet.colorado.edu/sims/html/forcesandmotionbasics/latest/forcesandmotionbasics_en.html Select “Acceleration” Click to show Forces, Sum of Forces, Values, Mass, and Acceleration. There are two experiments for this activity – make sure you include both. Experiment #1: Acceleration vs. Force In this lab you will determine the relationship between acceleration and net force. Choose a mass at the beginning, and keep it constant for this entire experiment. Set the friction to zero. This will make your Applied Force equal to the net force. Record data for five different values of Applied Force. Graph Acceleration vs. Net Force. Graph this in Google sheets(you want a line graph - it should only have one line). Make sure that Applied Force information is used as the x value Make sure that Acceleration information is used as the y value Add a trendline – see what fits best –…arrow_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
- hints: The flask will be filled with water (at a constant rate of 500 gallons per minute). It will take me exactly 10 minutes to escape from the chains. The diameter of the tank at 1 foot intervals. I am 5 feet 9 inches tall, and I'm pretty skinny so that you can ignore both my volume and the volume of the stool in your analysis. A gallon is equal to 0.13368 cubic feet. You can think of the volume and the height of the water as functions of time. You can easily find an expression for V (t), and then use your expression for volume in terms of height to solve for h(t). after 10 minutes amount of water in the tank=66.84 ft3 t=69.3 minutes h(t)=e66.84t/100? -1 h(10)=e66.84(10)/100? -1=7.39 ft Height of stool=1.64 ft Height of water in the tank=7.39 ft Questions: show work How fast is the water rising? I would like to know how long I will have to hold my breath during the last part of the stunt.arrow_forwardHello, I am a mechanical engineering student and want to upload this question as I have an exam in early June about thermodynamics. I have been given a question that will help me answer my exams in June. Please could you answer showing step by step guidance on how to answer this question with the formula clearly shown. Thank you very mucharrow_forwardI downloaded this question multiple times but I had no answer. I need (d and e)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