
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
Concept explainers
Textbook Question
Chapter 10, Problem 13ICA
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
5.112 A mounting bracket for electronic components is formed from sheet
metal with a uniform thickness. Locate the center of gravity of the
bracket.
0.75 in.
3 in.
༧
Fig. P5.112
1.25 in.
0.75 in.
y
r = 0.625 in.
2.5 in.
1 in.
6 in.
x
4-105. Replace the force system acting on the beam by an equivalent resultant force and couple
moment at point B.
A
30 in.
4 in.
12 in.
16 in.
B
30%
3 in.
10 in.
250 lb
260 lb
13
5
12
300 lb
Sketch and Describe a hatch coaming and show how the hatch coamings are framed in to ships strucure?
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
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
- Sketch and describe hatch coamings. Describe structrual requirements to deck plating to compensate discontinuity for corners of a hatch. Show what is done to the deck plating when the decks are cut away and include the supporting members.arrow_forwardAn Inclining experiment done on a ship thats 6500 t, a mass of 30t was moved 6.0 m transvesly causing a 30 cm deflection in a 6m pendulum, calculate the transverse meta centre height.arrow_forwarda ship 150 m long and 20.5 m beam floats at a draught of8 m and displaces 19 500 tonne. The TPC is 26.5 and midshipsection area coefficient 0.94. Calculate the block, prismatic andwaterplane area coefficients.arrow_forward
- A vessel loads 680 t fuel between forward and aft deep tanks. centre of gravity of forward tank is 24m forward of ships COG. centre to centre between tanks is 42 m. how much in each tank to keep trim the samearrow_forwardBeam of a vessel is 11% its length. Cw =0.72. When floating in SW of relative denisity 1.03, TPC is 0.35t greater than in freshwater. Find the length of the shiparrow_forwardAn inclining experiment was carried out on a ship of 4000tonne displacement, when masses of 6 tonne were moved transverselythrough 13.5 m. The deflections of a 7.5 m pendulurnwere 81, 78, 85, 83, 79, 82, 84 and 80 mm respectively.Caiculate the metacentric height.arrow_forward
- A ship of 10 000 tonne displacement has a waterplanearea of 1300 m2. The ship loads in water of 1.010 t/m3 andmoves into water of 1.026 t/m3. Find the change in meandraughtarrow_forwardA ship of 7000 tonne displacement has a waterplane areaof 1500 m2. In passing from sea water into river water of1005 kg/m3 there is an increase in draught of 10 cm. Find the Idensity of the sea water.arrow_forwardA ship has 300 tonne of cargo in the hold, 24 m forward ofmidships. The displacement of the vessel is 6000 tonne and its centre of gravity is 1.2 m forward of midships.Find the new position of the centre of gravity if this cargo ismoved to an after hold, 40 m from midshipsarrow_forward
- Sketch and describe how ships are supported in dry dock. When and where does the greatest amount of stresses occur?arrow_forwardSketch and desribe a balanced rudder and how it is suspendedarrow_forwardA ship 140 m long and 18 m beam floats at a draught of9 m. The immersed cross-sectionai areas at equai intervais are 5,60, 116, 145, 152, 153, 153, 151, 142, 85 and 0 m2 respectively.Calculate:(a) displacement(b) block coefficient(c) midship section area coefficient(d) prismatic coefficient.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 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

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