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 16ICA
Refer to the Worksheet shown, set up to calculate the displacement of a spring. Hooke's law states that the force (F, in newtons) applied to a spring is equal to the stiffness of the spring (k, in newtons per meter) times the displacement {x, in meters): F = kx.
Cell A3 contains a data validation list of springs. The stiffness (cell 83) and maximum displacement (cell C3) values are found using a VLOOKUP function linked to the table shown at the right side of the worksheet. These data are then used to determine the displacement of the spring at various mass values. A warning is issued if the displacement determined is greater than the maximum displacement for the spring. Use this information to determine the answers to the following questions.
- a. Write the expression, in Excel notation, that you would type into cell 86 to determine the displacement of the spring. Assume you will copy this expression to cells 87 to B 17.
- b. Fill in the following information in the VLOOKUP function used to determine the maximum displacement in cell C3 based on the choice of spring in cell A3.
=VLOOKUP(_(1)__,_(2)_,_(3)_,_(4)_)
- c. Fill in the following information in the IF function used to determine the warning given in cell C6, using the maximum displacement in cell C3. Assume you will copy this expression to cells C7 to C17.
=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
Please write the answer in a paper and apload it because I cannot see it if you don't wrote it in a paper thank you
c,b and a values in this question is:
c=2
b=0
a=7
please solve it all
no handwritten , solve it in clear writting in computer
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
the internal loading at point B.
Engineering Mechanics: Statics & Dynamics (14th Edition)
The crate starts from rest and is towed by the 100-Ib force. Prob. F15-2
Engineering Mechanics: Dynamics (14th Edition)
Figure 8.15 shows a system for delivering lawn fertilizer in liquid form. The nozzle on the end of the hose req...
Applied Fluid Mechanics (7th Edition)
If the bolt exerts a force of 50 lb on the pipe in the direction shown, determine the forces FA and FB that the...
Engineering Mechanics: Statics
In each case, determine the largest internal shear force resisted by the bolt. Include all necessary free-body ...
Mechanics of Materials (10th Edition)
9.4 Calculate the stress developed in the following members that are each subjected to an axial tensile load of...
Applied Statics and Strength of Materials (6th 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
- 1. For the following concentration expressions, indicate whether they are uniform or nonuniform and in how many dimensions (OD, 1D, 2D, or 3D), and steady or unsteady. Then for the following control volume and origin, and table of constants, use Excel or Matlab to graph profiles that show how concentration changes within the control volume and over time to a limit of 20 for the following: C(x,0,0,0), C(0,y,0,0), C(0,0,z,0) and C(0,0,0,t). On each graph, show which parameters are held constant, the CV boundaries, and the point where all four plots overlap. 20 C(x=0) 10 a 0.0001 b 0.001 | 20 0.01 k 0.1 100 All of the following functions are C(space, time) and so not necessarily just x as suggested. a. C,(x)= C,(x = 0)x exp{- ax}arrow_forwardFor the Following question Graph all 4 : [I just need all 4 graphs and please explain and make clean solution] Position vs time Velocity vs time Acceleration vs time Force vs time [For your convenience, I have solved the numerical solutions for the problem] (Please Look at the picture since it is much cleaner) Question : A 550 kilogram mass initially at rest acted upon by a force of F(t) = 50et Newtons. What are the acceleration, speed, and displacement of the mass at t = 4 second ? a =(50 e^t)/(550 ) [N/kg] v = ∫_0^t▒(50 e^t )dt/(550 )= v_0 +(50 e^t-50)/550=((e^t- 1))/11 x = ∫_0^t▒(e^t- 1)dt/(11 )= x_0 +(e^t- t - 1)/(11 ) a(4s)=(50*54.6)/550= 4.96[m/s^2 ] v(4s)=((e^4-1))/11= 4.87[m/s] x(4s)=((e^4- 4 - 1))/11= 4.51 [m]arrow_forward2. There were 42 mangoes in each crate. 12 such crates of mangoes were delivered to a factory. 4 mangoes were rotten and had to be thrown away. The remaining mangoes were packed into boxes of 10 mangoes each. Write a numerical expression in MATLAB syntax to represent this situation and then find how many boxes of mangoes were there? OFocus 4:20 AM 28°C Mostly clear 3/26/2022 LG CVENUENS THANOS BOBBLEHEAD AMANLANTE A ON CABIA ANn POCKET YOP! AVENGES KEYCHAIN INFINITY WAR Handy Fan THANOS BOBBLE HEAD IGENA ERANLIA P COs CA ANarrow_forward
- Q4/B/ the value of X-bai Q4/ For the figure below, all 0.987 dimensions in inch. A/The total O 2.5 Area : * O 0.857 O 0.254 y 0.398 O 1.06 1.5 O 2 0.65 2.5 0.5 2.5 O 0.487 0.55 2.5 2.5 Other: 3.arrow_forwardSolve for the resultant forces and moments at points A and B in diagram belowarrow_forwardQuestion 12 kana.Full explain this question and text typing work only We should answer our question within 2 hours takes more time then we will reduce Rating Dont ignore this linearrow_forward
- The figure shows the normal force on a jumping person as measured using a force table. A: From the graph, determine the weight of the jumping person. B: What is the maximum net force on the jumping person during the jump phase? C: Approximate the average net force during the jumping phase.arrow_forwardMotiyo Add explanationarrow_forwardno handwritten will be accepted mechanical vibrationarrow_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
Mechanical SPRING DESIGN Strategy and Restrictions in Under 15 Minutes!; Author: Less Boring Lectures;https://www.youtube.com/watch?v=dsWQrzfQt3s;License: Standard Youtube License