THINKING LIKE AN ENGINEER W/ACCESS
17th Edition
ISBN: 9781323522127
Author: STEPHAN
Publisher: PEARSON C
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 solutionStudents have asked these similar questions
how is it calculated how many numbers in rows or columns should be the sum of when we place integers starting from 1 in a magic square of size NXN? develop the necessary formula depending on N. show that the sum for n=3 will be 15.
Question 3) The length L is given as L=34 m on the plate in the figure. According to this;Question 3-A) Find the X coordinate of the geometric center of the plate. (Enter your result without writing m units. Write at least three digits after the comma.)Question 3-B) Find the Y coordinate of the geometric center of the plate. (Enter your result without writing m units. Write at least three digits after the comma.)
On 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.
Chapter 10 Solutions
THINKING LIKE AN ENGINEER W/ACCESS
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
A number of common substances are
Some of these materials exhibit characteristics of both solid and fluid beha...
Fox and McDonald's Introduction to Fluid Mechanics
3.3 It is known that a vertical force of 200 lb is required to remove the nail at C from the board. As the nail...
Vector Mechanics for Engineers: Statics, 11th Edition
Locate the centroid of the area. Prob. 9-17
Engineering Mechanics: Statics
Determine the velocity of block D if end A of the rope is pulled down with a speed of vA = 3 m/s.
Engineering Mechanics: Dynamics (14th Edition)
Convert the following quantities from English to SI units: a. 98 Btu/(hr-ft-F) b. 0.24 Btu/(lbm-F) C. 0.04 Ibm/...
Heating Ventilating and Air Conditioning: Analysis and Design
List several uses of the arbor press.
Machine Tool Practices (10th Edition)
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
- Can someone please help me to solve question 6? Please show all work, formulas, and diagrams. Please and thank you!!!arrow_forwardCan someone please help me to solve question 10?Please show all work, formulas, and diagrams. Please and thank you!!!arrow_forwardUse your weight in pounds (while standing on the surface of the Earth) to calculate your mass in the following units (1 kg weighs approx. 2.205 lb on the surface of the Earth). Show all your calculation, how you cancel the units and use the correct number of digits to get credit. Use scientific notation. Weight in pounds = 200 mass in grams = mass in kilograms = mass in teragrams = mass in picograms =arrow_forward
- In Exercise 12.4 of your book, University Physics 15th edition (see End of the Chapter 12 section), what is the answer for sub-item (b) if the radius of the neutron star is 6.825 km? (express your answer in the proper SI unit and without scientific notation)arrow_forwardPlease solve the following question. Note that the second picture is the solution of the question from the book, I just want to know the steps to reach it.arrow_forwardPlease solve it within 20-30minutes in a neat sheet of paper. Avoid typingarrow_forward
- Completely solve and box the final answer. Please show the units to show the unit cancellations. Write legibly 4. A total of 10,000 BTU have been rejected from the condenser in two minutes. If the cooling capacity is 120 gallons per minute of water, compute the temperature of cooling water that enters the cooling tower. The cooling water is supplied from the cooling tower at 120ºF. Use the standard density of water.arrow_forwardthe last three digits of My ID for the height H__ in mm is (754)arrow_forwardI am confused because on my homework i got marked wrong for this, unless I used to many sig figs.arrow_forward
- 1-6 already answered, please help me study this TYSM!arrow_forwardSeawater can be purified by distillation into potable water. If it costs 15 cents per kilowatt-hour for energy, what is the cost of energy to produce 100.0 gallons of drinking water at 100.0 ˚C if the seawater starts at 25.00 ˚C? (1 watt × 1 second = 1 joule). Enter your answer to the nearest penny.arrow_forwardPART A only SOLVE CAREFULLY!! Please Write Clearly and Box the final Answer(s) Use THE CORRECT UNITS) Express your answer to three significant figures and include appropriate units. DRAW the KINEMATIC DIAGRAM and label it for this problem as well HINT : k = 370lb/ftarrow_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