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
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 solutionStudents have asked these similar questions
Oz Lawn Care Inc. manufactures and assembles lawnmowers that are shipped to dealers
throughout the United States and Canada. Two different procedures have been proposed for
mounting the engine on the frame of the lawnmower. PB (Minutes) UPB (Minutes
)345798632 5 Is there a difference in the methods' mean time to mount the engines on
the frames of the lawnmowers? The answer must be in handwriting. Please write your answer
using a ball - point pen on plain paper. Submit your homework by uploading it to the canvas.
Good Luck!
A dog is pulling on his lead at an angle of 39 degrees with a force of 50 Newtons.
What is the force downward?
Newtons.
What is the force horizontally?
Newtons.
Note: You can type the trig in the answer box for all these problems. For example if the answer is
50cos(10), you can just type that into the answer box. To get inverse trig functions type arcsin, arccos or
arctan.
Match each of the following terms to the phrase that describes it. Answers are used only once.
I have the answers to the questions but I need them checked for accuracy.
Answers:
All numbers are horizontal on the print - UnidirectionalGuidelines for size and spacing - ContourOrdinate - DepthLeader should have one - Reference
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
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
- This question is the solution to the student’s number. My number is 39914140664014. The temperature starts at 39 degrees and ends with the last two numbers 14. This is for me.arrow_forwardIn the blank space within your drawing template, draw the 3rd angle orthographic projection layout of the object shown. Also redraw the object shown in the top right hand corner of your page. You can use the scale markings to determine your own scale that fits appropriately on your paper. You can use mm or inches.arrow_forwardCompletely solve and box the final answer. Please show the units to show the unit cancellations. Write legibly 7. A fire tube boiler develops 75 metric tons of steam at a pressure of 12.5 mpa and a temperature of 680°C for a period of 8 hours. The feedwater temperature is maintained at 95°C. If the boiler efficiency is 87.5%, find the average amount of coal burned in kg per hour if its heating value is 12,500 Kcal/kg.arrow_forward
- I need parts 3 and 4 answered pertaining to the print provided. I asked this question previously on here and I received the wrong answers to the 2 parts Im asking about, so I am reposting the question again to have another tutor answer it. Part 3: I need to tell what was ommited. Part 4: I need to tell what the triangle equals? Lower right or J1 zone has the answer.arrow_forward**pleace, I want FULL answer for this question with ALL steps for three sub questions, espicially the Mohr's circle. in addition to neat handwriting or electronic writing. pleace do not coppy the Answersarrow_forwardMatch each of the following terms to the phrase that describes it. Answers are used only once. NOTE: In image 2 I have the answers, I need my answers double checked.arrow_forward
- Part C Also, what are the normal reaction at A and B when it begins to move? Express your answers in pounds using three significant figures separated by a comma. NA, NB= Submit VAΣ vec Request Answer ? lbarrow_forwardPlease show your solution and at the same time BOX and SPECIFY the answers that corresponds to each blank on the question. Make sure to fill all the blanks. Thank you. STRICKLY FOLLOW THIS: Calculated Answers Express your answers without rounding off and without scientific notation unless instructed otherwise. Multiple Blanks Write powers or subscript as is. Ex: Use b2 if you mean b2 or b2 Spell out Greek letters. Ex: Use pi if you mean greek letter pi Write answers without spaces. Ex: Use 2epsilon0r3 if you mean 3e0r3 Write fractions with a slash. Ex: Use 1/2arrow_forwardQ1: write a program to enter any text and compute its length. Q2: Design a form with a text box. Use select statement so that when user enters g, b, r and y then form colored to green, blue, red, and yellow respectively. Q3: Write a program to print multipliers of 5 (from 5 to 50)arrow_forward
- Solve the following questionarrow_forwardIf, on average, an academic advisor sees 20% of students for career advising for 30 minutes, 60% short resume reviews for 15 minutes, and 20% concentration advising for 20 minutes, what is his cycle time in minutes? Please format and round your answer to the nearest whole number (no decimals).arrow_forwardFive points are equally spaced on a circle. A five-pointed star (pentagram) is formed by joining nonconsecutive points two at a time. What is the degree measure of an arc determined by two consecutive points?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