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
expand_more
expand_more
format_list_bulleted
Videos
Textbook Question
Chapter 10, Problem 3ICA
| A | B | C | D | E | F | |
| 1 | ||||||
| 2 | 45 | |||||
| 3 | meters | |||||
| 4 | horses | |||||
| 5 | canoes | |||||
| 6 | 99 | |||||
| 7 | four | |||||
| 8 | equator | |||||
| 9 | Dabo | |||||
| 10 | 33.3333 | |||||
| 11 |
The worksheet displayed was designed to reflect on our understanding of the use of cell references.
Answer the following questions using the worksheet.
- a. If we want to calculate the average of all of the cells in the range A2:A10, what do we type into cell B5?
- b. If we want to calculate the sum of each individual numeric value (by individual cell, not range), what do we type into cell B6?
- c. If we want to concatenate every cell that contains text (in order from lowest numbered row to highest numbered row) in the range A2:A10, what is the resulting string of text that would appear in cell B7?
- d. If we want to concatenate every cell that contains text (in order from highest numbered row to lowest numbered row) in the range A2:A10, what would we write in cell B8 to generate that string of text?
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
An ideal gas, occupying a volume of 0.02 m3 , has a temperature of 25 0C and is at 1.2 bar. The gas is compressed reversibly and adiabatically to a final pressure of 8 bar. Assuming the gas has an adiabatic index of γ = 1.4, calculate (a) the final temperature, (b) the final volume, (c) the work performed during the compression and (d) the heat transferred.
attached is a past paper question in which we werent given the solution. a solution with clear steps and justification would be massively appreciated thankyou.
in this scenario, when it comes to matrix iterations it states this system is assumed out of phase. why is this?
Chapter 10 Solutions
Thinking Like an Engineer: An Active Learning Approach (4th Edition)
Ch. 10.1 - Type 5 in cell E22 and 13 in cell E23; type =E22 +...Ch. 10.1 - Type 45 into cell G22 and =G22 + 10 in cell H22....Ch. 10.1 - Type 40 into cell A28 and =A28 + 10 in cell D28....Ch. 10.1 - Type 40 into cell A28 and =A28 + 5 in cell G28....Ch. 10.2 - Launch a new worksheet. Type the following Excel...Ch. 10.2 - As part of the design of a high-performance...Ch. 10.3 - Evaluate the following expressions. What is the...Ch. 10.3 - Prob. 8CCCh. 10.4 - This is a continuation of the worksheet you...Ch. 10.5 - Prob. 11CC
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
What types of coolant are used in vehicles?
Automotive Technology: Principles, Diagnosis, And Service (6th Edition) (halderman Automotive Series)
A nozzle at A discharges water with an initial velocity of 36 ft/s at an angle with the horizontal. Determine ...
Vector Mechanics For Engineers
Look at the following description of a problem domain:
Starting Out with Java: From Control Structures through Data Structures (4th Edition) (What's New in Computer Science)
17–1C A high-speed aircraft is cruising in still air. How does the temperature of air at the nose of the aircra...
Thermodynamics: An Engineering Approach
In Exercises 1 through 22, determine the output displayed in the text box or list box by the lines of code.
Introduction To Programming Using Visual Basic (11th Edition)
What are the design issues for character string types?
Concepts Of Programming Languages
Knowledge Booster
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
- Q1. A curved beam of a circular cross section of diameter "d" is fixed at one end and subjected to a concentrated load P at the free end (Fig. 1). Calculate stresses at points A and C. Given: P = 800 N, d = 30 mm, a 25 mm, and b = 15 mm. Fig.1 P b B (10 Marks)arrow_forwardYou are working as an engineer in a bearing systems design company. The flow of lubricant inside a hydrodynamic bearing (p = 0.001 kg m-1 s-1) can be approximated as a parallel, steady, two-dimensional, incompressible flow between two parallel plates. The top plate, representing the moving part of the bearing, travels at a constant speed, U, while the bottom plate remains stationary (Figure Q1). The plates are separated by a distance of 2h = 1 cm and are W = 20 cm wide. Their length is L = 10 cm. By applying the above approximations to the Navier-Stokes equations and assuming that end effects can be neglected, the horizontal velocity profile can be shown to be y = +h I 2h = 1 cm x1 y = -h u(y) 1 dP 2μ dx -y² + Ay + B moving plate stationary plate U 2 I2 L = 10 cm Figure Q1: Flow in a hydrodynamic bearing. The plates extend a width, W = 20 cm, into the page.arrow_forwardQuestion 1 You are working as an engineer in a bearing systems design company. The flow of lubricant inside a hydrodynamic bearing (µ = 0.001 kg m¯¹ s¯¹) can be approximated as a parallel, steady, two-dimensional, incompressible flow between two parallel plates. The top plate, representing the moving part of the bearing, travels at a constant speed, U, while the bottom plate remains stationary (Figure Q1). The plates are separated by a distance of 2h = 1 cm and are W = 20 cm wide. Their length is L = 10 cm. By applying the above approximations to the Navier-Stokes equations and assuming that end effects can be neglected, the horizontal velocity profile can be shown to be 1 dP u(y) = 2μ dx -y² + Ay + B y= +h Ꮖ 2h=1 cm 1 x1 y = −h moving plate stationary plate 2 X2 L = 10 cm Figure Q1: Flow in a hydrodynamic bearing. The plates extend a width, W = 20 cm, into the page. (a) By considering the appropriate boundary conditions, show that the constants take the following forms: U U 1 dP A =…arrow_forward
- Question 2 You are an engineer working in the propulsion team for a supersonic civil transport aircraft driven by a turbojet engine, where you have oversight of the design for the engine intake and the exhaust nozzle, indicated in Figure Q2a. The turbojet engine can operate when provided with air flow in the Mach number range, 0.60 to 0.80. You are asked to analyse a condition where the aircraft is flying at 472 m/s at an altitude of 14,000 m. For all parts of the question, you can assume that the flow path of air through the engine has a circular cross section. (a) ← intake normal shock 472 m/s A B (b) 50 m/s H 472 m/s B engine altitude: 14,000 m exhaust nozzle E F exit to atmosphere diameter: DE = 0.30 m E F diameter: DF = 0.66 m Figure Q2: Propulsion system for a supersonic aircraft. a) When the aircraft is at an altitude of 14,000 m, use the International Standard Atmosphere in the Module Data Book to state the local air pressure and tempera- ture. Thus show that the aircraft speed…arrow_forwardيكا - put 96** I need a detailed drawing with explanation or in wake, and the top edge of im below the free surface of the water. Determine the hydrothed if hydrostatic on the Plot the displacement diagram for a cam with roller follower of diameter 10 mm. The required motion is as follows; 1- Rising 60 mm in 135° with uniform acceleration and retardation motion. 2- Dwell 90° 3- Falling 60 mm for 135° with Uniform acceleration-retardation motion. Then design the cam profile to give the above displacement diagram if the minimum circle diameter of the cam is 50 mm. =--20125 7357 750 X 2.01arrow_forwardYou are working as an engineer in a bearing systems design company. The flow of lubricant inside a hydrodynamic bearing (µ = 0.001 kg m¯¹ s¯¹) can be approximated as a parallel, steady, two-dimensional, incompressible flow between two parallel plates. The top plate, representing the moving part of the bearing, travels at a constant speed, U, while the bottom plate remains stationary (Figure Q1). The plates are separated by a distance of 2h = 1 cm and are W = 20 cm wide. Their length is L = 10 cm. By applying the above approximations to the Navier-Stokes equations and assuming that end effects can be neglected, the horizontal velocity profile can be shown to be U y = +h У 2h = 1 cm 1 x1 y=-h u(y) = 1 dP 2μ dx -y² + Ay + B moving plate - U stationary plate 2 I2 L = 10 cm Figure Q1: Flow in a hydrodynamic bearing. The plates extend a width, W = 20 cm, into the page. (a) By considering the appropriate boundary conditions, show that the constants take the following forms: A = U 2h U 1 dP…arrow_forward
- Question 2 You are an engineer working in the propulsion team for a supersonic civil transport aircraft driven by a turbojet engine, where you have oversight of the design for the engine intake and the exhaust nozzle, indicated in Figure Q2a. The turbojet engine can operate when provided with air flow in the Mach number range, 0.60 to 0.80. You are asked to analyse a condition where the aircraft is flying at 472 m/s at an altitude of 14,000 m. For all parts of the question, you can assume that the flow path of air through the engine has a circular cross section. (a) normal shock 472 m/s A B (b) intake engine altitude: 14,000 m D exhaust nozzle→ exit to atmosphere 472 m/s 50 m/s B diameter: DE = 0.30 m EX diameter: DF = 0.66 m Figure Q2: Propulsion system for a supersonic aircraft. F a) When the aircraft is at an altitude of 14,000 m, use the International Standard Atmosphere in the Module Data Book to state the local air pressure and tempera- ture. Thus show that the aircraft speed of…arrow_forwardgiven below: A rectangular wing with wing twist yields the spanwise circulation distribution kbV1 roy) = kbv. (2) where k is a constant, b is the span length and V. is the free-stream velocity. The wing has an aspect ratio of 4. For all wing sections, the lift curve slope (ag) is 2 and the zero-lift angle of attack (a=0) is 0. a. Derive expressions for the downwash (w) and induced angle of attack a distributions along the span. b. Derive an expression for the induced drag coefficient. c. Calculate the span efficiency factor. d. Calculate the value of k if the wing has a washout and the difference between the geometric angles of attack of the root (y = 0) and the tip (y = tb/2) is: a(y = 0) a(y = ±b/2) = /18 Hint: Use the coordinate transformation y = cos (0)arrow_forward۳/۱ العنوان O не شكا +91x PU + 96852 A heavy car plunges into a lake during an accident and lands at the bottom of the lake on its wheels as shown in figure. The door is 1.2 m high and I m wide, and the top edge of Deine the hadrostatic force on the Plot the displacement diagram for a cam with roller follower of diameter 10 mm. The required motion is as follows; 1- Rising 60 mm in 135° with uniform acceleration and retardation motion. 2- Dwell 90° 3- Falling 60 mm for 135° with Uniform acceleration-retardation motion. Then design the cam profile to give the above displacement diagram if the minimum circle diameter of the cam is 50 mm. = -20125 750 x2.01arrow_forward
- Plot the displacement diagram for a cam with roller follower of diameter 10 mm. The required motion is as follows; 1- Rising 60 mm in 135° with uniform acceleration and retardation motion. 2- Dwell 90° 3- Falling 60 mm for 135° with Uniform acceleration-retardation motion. Then design the cam profile to give the above displacement diagram if the minimum circle diameter of the cam is 50 mm.arrow_forwardQ1/ A vertical, circular gate with water on one side as shown. Determine the total resultant force acting on the gate and the location of the center of pressure, use water specific weight 9.81 kN/m³ 1 m 4 marrow_forwardI need handwritten solution with sketches for eacharrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Elements Of ElectromagneticsMechanical EngineeringISBN:9780190698614Author:Sadiku, Matthew N. O.Publisher:Oxford University Press
Mechanics of Materials (10th Edition)Mechanical EngineeringISBN:9780134319650Author:Russell C. HibbelerPublisher:PEARSON
Thermodynamics: An Engineering ApproachMechanical EngineeringISBN:9781259822674Author:Yunus A. Cengel Dr., Michael A. BolesPublisher:McGraw-Hill Education
Control Systems EngineeringMechanical EngineeringISBN:9781118170519Author:Norman S. NisePublisher:WILEY
Mechanics of Materials (MindTap Course List)Mechanical EngineeringISBN:9781337093347Author:Barry J. Goodno, James M. GerePublisher:Cengage Learning
Engineering Mechanics: StaticsMechanical EngineeringISBN:9781118807330Author:James L. Meriam, L. G. Kraige, J. N. BoltonPublisher:WILEY
Elements Of Electromagnetics
Mechanical Engineering
ISBN:9780190698614
Author:Sadiku, Matthew N. O.
Publisher:Oxford University Press
Mechanics of Materials (10th Edition)
Mechanical Engineering
ISBN:9780134319650
Author:Russell C. Hibbeler
Publisher:PEARSON
Thermodynamics: An Engineering Approach
Mechanical Engineering
ISBN:9781259822674
Author:Yunus A. Cengel Dr., Michael A. Boles
Publisher:McGraw-Hill Education
Control Systems Engineering
Mechanical Engineering
ISBN:9781118170519
Author:Norman S. Nise
Publisher:WILEY
Mechanics of Materials (MindTap Course List)
Mechanical Engineering
ISBN:9781337093347
Author:Barry J. Goodno, James M. Gere
Publisher:Cengage Learning
Engineering Mechanics: Statics
Mechanical Engineering
ISBN:9781118807330
Author:James L. Meriam, L. G. Kraige, J. N. Bolton
Publisher:WILEY
Dimensional Analysis - in physics; Author: Jennifer Cash;https://www.youtube.com/watch?v=c_ZUnEUlTbM;License: Standard youtube license