Thinking Like an Engineer: An Active Learning Approach (3rd Edition)
3rd Edition
ISBN: 9780133593211
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
Concept explainers
Videos
Textbook Question
Chapter 10, Problem 9ICA
Refer to the following worksheet. In all questions, give the requested answers in Excel notation, indicating EXACTLY what you would type into the cell given to properly execute the required procedures.
- a.
In column B, you wish to determine the radius of a cylinder. The volume (column A) and height (cell B3) have been provided. Recall that the volume of a cylinder is given by V = πr2 H. Assume you will write the formula in cell B8 and copy it down the column to cell B100. In the expression, fill in the blanks with any Excel functions and fill in the boxes with any dollar signs necessary for relative, mixed, or absolute references. - b. In column C, the area of a cylinder corresponding to the radius (in column B) and the height (cell B3) has been determined in units of square feet. In column D, you wish to express these values in units of square centimeters. Fill in any Excel mathematical operators or parenthesis for the expression to correctly complete this conversion.
= C8___2.54___2___12___2
- c.
In columns E–G, we wish to determine the dimensions of a rectangular container with the same volume as the cylinders given in column A. The rectangle will be the same height as the cylinder (cell B3) but will have three possible widths (contained in cells E4 – G4). Fill in the following boxes with any dollar signs necessary for relative, mixed, or absolute references to allow the expression to determine the length in cell E8 and be copied across to columns F and G, then down all three columns to row 100. - d. In column H, we wish to tell the user how the length and radius of the different containers compare. Complete the following IF statement for cell H8 to display the maximum value of the length calculations (cells E8 through G8) if the maximum value of the length calculations is greater than the corresponding radius calculation; otherwise display the letter R.
=IF(_(1)_,_(2)_,_(3)_)
- e. Fill in the following IF statement for cell J8 to display the sum of Length 1 and Length 2 if the sum of these lengths is greater than Length 3; otherwise, leave it blank.
IF(_(1)_,_(2)_,_(3)_)
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
340 lb
340 lb
Δ
4. In a table of vector differential operators, look up the expressions for V x V in a cylindrical coordinate
system.
(a) Compute the vorticity for the flow in a round tube where the velocity profile is
= vo [1-(³]
V₂ = Vo
(b) Compute the vorticity for an ideal vortex where the velocity is
Ve=
r
where constant.
2πг
(c) Compute the vorticity in the vortex flow given by
Ve=
r
2лг
1- exp
(
r²
4vt
(d) Sketch all the velocity and vorticity profiles.
In the figure, Neglects the heat loss and kinetic and potential energy changes, calculate the work produced by the
turbine in kJ
T = ???
Steam at
P=3 MPa,
T = 280°C
Turbine
Rigid tank
V = 1000 m³
Turbine
Rigid tank
V = 100 m³
V = 1000 m³
V = 100 m³
The valve is
opened.
Initially: evacuated
(empty) tank
O a. 802.8
Initially: Closed valve
O b. 572
O c. 159.93
Od. 415
e. 627.76
equilibrium
Chapter 10 Solutions
Thinking Like an Engineer: An Active Learning Approach (3rd Edition)
Ch. 10.1 - Type "5" in cell E22 and "9" in cell E23; type...Ch. 10.1 - Type “20” into cell G22 and “=$G$22 + 10” in cell...Ch. 10.1 - Prob. 3CCCh. 10.1 - Type “=$A28 + 5” in cell G28. Copy cell G28 down...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 - Continue the example in CC 10-6 above. The...Ch. 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 - 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. 10ICACh. 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. 3RQCh. 10 - 4. 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 - 16. A substance used to remove the few remaining...Ch. 10 - 15 Create an Excel worksheet that will allow the...Ch. 10 - Prob. 18RQ
Additional Engineering Textbook Solutions
Find more solutions based on key concepts
Which of the following are illegal variable names in Python, and why? x 99bottles july2009 theSalesFigureForFis...
Starting Out with Python (4th Edition)
The solid steel shaft AC has a diameter of 25 mm and is supported by smooth bearings at D and E. It is coupled ...
Mechanics of Materials (10th Edition)
CONCEPT QUESTIONS
15.CQ3 The ball rolls without slipping on the fixed surface as shown. What is the direction ...
Vector Mechanics for Engineers: Statics and Dynamics
How is the hydrodynamic entry length defined for flow in a pipe? Is the entry length longer in laminar or turbu...
Fluid Mechanics: Fundamentals and Applications
How are relationships between tables expressed in a relational database?
Modern Database Management
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
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
- Please find the torsional yield strength, the yield strength, the spring index, and the mean diameter. Use: E = 28.6 Mpsi, G = 11.5 Mpsi, A = 140 kpsi·in, m = 0.190, and relative cost= 1.arrow_forwardA viscoelastic column is made of a material with a creep compliance of D(t)= 0.75+0.5log10t+0.18(log10t)^2 GPA^-1 for t in s. If a constant compressive stress of σ0 = –100 MPa is applied at t = 0, how long will it take (= t1/2) for the height of the column to decrease to ½ its original value? Note: You will obtain multiple answers for this problem! One makes sense physically and one does not.arrow_forwardA group of 23 power transistors, dissipating 2 W each, are to be cooled by attaching them to a black-anodized square aluminum plate and mounting the plate on the wall of a room at 30°C. The emissivity of the transistor and the plate surfaces is 0.9. Assuming the heat transfer from the back side of the plate to be negligible and the temperature of the surrounding surfaces to be the same as the air temperature of the room, determine the length of the square plate if the average surface temperature of the plate is not to exceed 50°C. Start the iteration process with an initial guess of the size of the plate as 43 cm. The properties of air at 1 atm and the film temperature of (Ts + T)/2 = (50 + 30)/2 = 40°C are k = 0.02662 W/m·°C, ν = 1.702 × 10–5 m2 /s, Pr = 0.7255, and β = 0.003195 K–1. Multiple Choice 0.473 m 0.284 m 0.513 m 0.671 marrow_forward
- A 40-cm-diameter, 127-cm-high cylindrical hot water tank is located in the bathroom of a house maintained at 20°C. The surface temperature of the tank is measured to be 44°C and its emissivity is 0.4. Taking the surrounding surface temperature to be also 20°C, determine the rate of heat loss from all surfaces of the tank by natural convection and radiation. The properties of air at 32°C are k=0.02603 W/m-K, v=1.627 x 10-5 m²/s, Pr = 0.7276, and ẞ = 0.003279 K-1 The rate of heat loss from all surfaces of the tank by natural convection is The rate of heat loss from all surfaces of the tank by radiation is W. W.arrow_forwardA 2.5-m-long thin vertical plate is subjected to uniform heat flux on one side, while the other side is exposed to cool air at 5°C. The plate surface has an emissivity of 0.73, and its midpoint temperature is 55°C. Determine the heat flux subjected on the plate surface. Uniform heat flux -Plate, € = 0.73 Cool air 5°C 7 TSUIT Given: The properties of water at Tf,c= 30°C. k=0.02588 W/m.K, v=1.608 x 10-5 m²/s Pr = 0.7282 The heat flux subjected on the plate surface is W/m²arrow_forwardHot water is flowing at an average velocity of 5.82 ft/s through a cast iron pipe (k=30 Btu/h-ft-°F) whose inner and outer diameters are 1.0 in and 1.2 in, respectively. The pipe passes through a 50-ft-long section of a basement whose temperature is 60°F. The emissivity of the outer surface of the pipe is 0.5, and the walls of the basement are also at about 60°F. If the inlet temperature of the water is 150°F and the heat transfer coefficient on the inner surface of the pipe is 30 Btu/h-ft².°F, determine the temperature drop of water as it passes through the basement. Evaluate air properties at a film temperature of 105°C and 1 atm pressure. The properties of air at 1 atm and the film temperature of (Ts+ T∞)/2 = (150+60)/2 = 105°F are k=0.01541 Btu/h-ft-°F. v=0.1838 × 10-3 ft2/s, Pr = 0.7253, and ẞ = 0.00177R-1arrow_forward
- hand-written solutions only, please. correct answers upvoted!arrow_forwardhand-written solutions only, please. correct answers upvoted!arrow_forward! Required information Consider a flat-plate solar collector placed horizontally on the flat roof of a house. The collector is 1.3 m wide and 2.8 m long, and the average temperature of the exposed surface of the collector is 42°C. The properties of air at 1 atm and the film temperature are k=0.02551 W/m-°C, v = 1.562 × 10-5 m²/s, Pr = 0.7286, and ẞ= 0.003356 K-1 Determine the rate of heat loss from the collector by natural convection during a calm day when the ambient air temperature is 8°C. The rate of heat loss from the collector by natural convection is W.arrow_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
First Law of Thermodynamics, Basic Introduction - Internal Energy, Heat and Work - Chemistry; Author: The Organic Chemistry Tutor;https://www.youtube.com/watch?v=NyOYW07-L5g;License: Standard youtube license