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 3ICA
| A | B | C | D | E | F | |
| 1 | ||||||
| 2 | 45 | |||||
| 3 | meters | |||||
| 4 | horses | |||||
| 5 | canoes | |||||
| 6 | 99 | |||||
| 7 | four | |||||
| 8 | equator | |||||
| 9 | Dabo | |||||
| 10 | 33.3333 | |||||
| 11 |
The worksheet displayed was designed to reflect on our understanding of the use of cell references.
Answer the following questions using the worksheet.
- a. If we want to calculate the average of all of the cells in the range A2:A10, what do we type into cell B5?
- b. If we want to calculate the sum of each individual numeric value (by individual cell, not range), what do we type into cell B6?
- c. If we want to concatenate every cell that contains text (in order from lowest numbered row to highest numbered row) in the range A2:A10, what is the resulting string of text that would appear in cell B7?
- d. If we want to concatenate every cell that contains text (in order from highest numbered row to lowest numbered row) in the range A2:A10, what would we write in cell B8 to generate that string of text?
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
A triangular distributed load of max intensity w acts on beam
AB. The beam is supported by a pin at A and member CD,
which is connected by pins at C and D respectively.
Determine the largest load intensity, Wmax, that can be
applied if the pin at D can support a maximum force of
18000 N. Also determine the reactions at A and C
and express each answer in Cartesian components. Assume
the masses of both beam and member ✓ are
negligible.
Dwas
шал
=
A
BY NC SA
2016 Eric Davishahl
C
D
-a-
Ур
-b-
X
B
W
Values for dimensions on the figure are given in the following
table. Note the figure may not be to scale.
Variable Value
a
6.6 m
b
11.88 m
C
4.29 m
The maximum load intensity is
=
wmax
N/m.
The reaction at A is A =
The reaction at C is
=
i+
Ĵ N.
ĴN.
12
i+
The beam is supported by a pin at B and a roller at C and is
subjected to the loading shown with w =110 lb/ft, and F
205 lb.
a.) If M
=
2,590 ft-lb, determine the support reactions at B
and C. Report your answers in both Cartesian components.
b.) Determine the largest magnitude of the applied couple M
for which the beam is still properly supported in equilibrium
with the pin and roller as shown.
2013 Michael Swanbom
CC
BY NC SA
M
ру
W
B⚫
C
F
ka
b
Values for dimensions on the figure are given in the following
table. Note the figure may not be to scale.
Variable Value
a
3.2 ft
b
6.4 ft
C
3 ft
a.) The reaction at B is B =
The reaction at C is C =
ĵ lb.
i+
Ĵ lb.
b.) The largest couple that can be applied is M
ft-lb.
==
i+
The beam ABC has a mass of 79.0 kg and is supported by
the rope BDC that runs through the frictionless pulley at D
. The winch at C has a mass of 36.5 kg. The tension in the
rope acts on the beam at points B and C and counteracts
the moments due to the beam's weight (acting vertically at
the midpoint of its length) and the weight of the winch
(acting vertically at point C) such that the resultant moment
about point A is equal to zero. Assume that rope segment
CD is vertical and note that rope segment BD is NOT
necessarily perpendicular to the beam.
a.) Compute the tension in the rope.
b.) Model the two forces the rope exerts on the beam as a
single equivalent force and couple moment acting at point B.
Enter your answer in Cartesian components.
c.) Model the two forces the rope exerts on the beam as a
single equivalent force (no couple) and determine the
distance from A to the point along the beam where the
equivalent force acts (measured parallel to the beam from A
). Enter your answer…
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
What types of coolant are used in vehicles?
Automotive Technology: Principles, Diagnosis, And Service (6th Edition) (halderman Automotive Series)
A nozzle at A discharges water with an initial velocity of 36 ft/s at an angle with the horizontal. Determine ...
Vector Mechanics For Engineers
Look at the following description of a problem domain:
Starting Out with Java: From Control Structures through Data Structures (4th Edition) (What's New in Computer Science)
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
In Exercises 1 through 22, determine the output displayed in the text box or list box by the lines of code.
Introduction To Programming Using Visual Basic (11th Edition)
What are the design issues for character string types?
Concepts Of Programming Languages
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
- w1 Three distributed loads act on a beam as shown. The load between A and B increases linearly from 0 to a maximum intensity of w₁ = 12.8 lb/ft at point B. The load then varies linearly with a different slope to an intensity of w₂ = 17.1 lb/ft at C. The load intensity in section CD of the beam is constant at w3 10.2 lb/ft. For each load region, determine the resultant force and the location of its line of action (distance to the right of A for all cases). cc 10 BY NC SA 2016 Eric Davishahl = WI W2 W3 -b- C Values for dimensions on the figure are given in the following table. Note the figure may not be to scale. Variable Value a 4.50 ft b 5.85 ft с 4.28 ft The resultant load in region AB is FR₁ = lb and acts ft to the right of A. The resultant load in region BC is FR2 lb and acts = ft to the right of A. The resultant load in region CD is FR3 = lb and acts ft to the right of A.arrow_forwardThe T-shaped structure is embedded in a concrete wall at A and subjected to the force F₁ and the force-couple system F2 1650 N and M = 1,800 N-m at the locations shown. Neglect the weight of the structure in your calculations for this problem. = a.) Compute the allowable range of magnitudes for F₁ in the direction shown if the connection at A will fail when subjected to a resultant moment with a magnitude of 920 N- m or higher. b.) Focusing on the forces and igonoring given M for now. Using the value for F1, min that you calculated in (a), replace the two forces F₁ and F2 with a single force that has equivalent effect on the structure. Specify the equivalent →> force Feq in Cartesian components and indicate the horizontal distance from point A to its line of action (note this line of action may not intersect the structure). c.) Now, model the entire force system (F1,min, F2, and M) as a single force and couple acting at the junction of the horizontal and vertical sections of the…arrow_forwardThe heated rod from Problem 3 is subject to a volumetric heating h(x) = h0 x L in units of [Wm−3], as shown in the figure below. Under the heat supply the temperature of the rod changes along x with the temperature function T (x). The temperature T (x) is governed by the d following equations: − dx (q(x)) + h(x) = 0 PDE q(x) =−k dT dx Fourier’s law of heat conduction (4) where q(x) is the heat flux through the rod and k is the (constant) thermal conductivity. Both ends of the bar are in contact with a heat reservoir at zero temperature. Determine: 1. Appropriate BCs for this physical problem. 2. The temperature function T (x). 3. The heat flux function q(x). Side Note: Please see that both ends of bar are in contact with a heat reservoir at zero temperature so the boundary condition at the right cannot be du/dx=0 because its not thermally insulated. Thank youarrow_forward
- The elastic bar from Problem 1 spins with angular velocity ω about an axis, as shown in the figure below. The radial acceleration at a generic point x along the bar is a(x) = ω2x. Under this radial acceleration, the bar stretches along x with displacement function u(x). The displacement d u(x) is governed by the following equations: dx (σ(x)) + ρa(x) = 0 PDE σ(x) = E du dx Hooke’s law (2) where σ(x) is the axial stress in the rod, ρ is the mass density, and E is the (constant) Young’s modulus. The bar is pinned on the rotation axis at x = 0 and it is also pinned at x = L. Determine: 1. Appropriate BCs for this physical problem. 2. The displacement function u(x). 3. The stress function σ(x). SIDE QUESTION: I saw a tutor solve it before but I didn't understand why the tutor did not divide E under the second term (c1x) before finding u(x). The tutor only divided E under first term. please explain and thank youarrow_forwardcalculate the total power required to go 80 mph in a VW Type 2 Samba Bus weighing 2310 lbs. with a Cd of 0.35 and a frontal area of 30ft^2. Consider the coefficient of rolling resistance to be 0.018. What is the increase in power required to go the same speed if the weight is increased by 2205 pounds (the rated carrying capacity of the vehicle). If the rated power for the vehicle is 49 bhp, will the van be able to reach 80 mph at full carrying capacity?arrow_forwardA distillation column with a total of 13 actual stages (including a partial condenser) is used to perform a separation which requires 7 ideal stages. Calculate the overall column efficiency, and report your answer in %arrow_forward
- 6. Consider a 10N step input to the mechanical system shown below, take M = 15kg, K = 135N/m, and b = 0.4 Ns/m. (a) Assume zero initial condition, calculate the (i) System pole (ii) System characterization, and (iii) The time domain response (b) Calculate the steady-state value of the system b [ www K 个 х M -F(+)arrow_forward2. Solve the following linear time invariant differential equations using Laplace transforms subject to different initial conditions (a) y-y=t for y(0) = 1 and y(0) = 1 (b) ÿ+4y+ 4y = u(t) for y(0) = 0 and y(0) = 1 (c) y-y-2y=0 for y(0) = 1 and y(0) = 0arrow_forward3. For the mechanical systems shown below, the springs are undeflected when x₁ = x2 = x3 = 0 and the input is given as fa(t). Draw the free-body diagrams and write the modeling equations governing each of the systems. K₁ 000 K₂ 000 M₁ M2 -fa(t) B₂ B₁ (a) fa(t) M2 K₂ 000 B K₁ x1 000 M₁ (b)arrow_forward
- This question i m uploading second time . before you provide me incorrect answer. read the question carefully and solve accordily.arrow_forward1. Create a table comparing five different analogous variables for translational, rotational, electrical and fluid systems. Include the standard symbols for each variable in their respective systems.arrow_forward2) Suppose that two unequal masses m₁ and m₂ are moving with initial velocities v₁ and v₂, respectively. The masses hit each other and have a coefficient of restitution e. After the impact, mass 1 and 2 head to their respective gaps at angles a and ẞ, respectively. Derive expressions for each of the angles in terms of the initial velocities and the coefficient of restitution. m1 m2 8 m1 m2 β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
Dimensional Analysis - in physics; Author: Jennifer Cash;https://www.youtube.com/watch?v=c_ZUnEUlTbM;License: Standard youtube license