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
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 solutionStudents have asked these similar questions
2. 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 AN
4:16
Search
Expert Q&A
Done
Please solve question 16-109 below this in the
follwoing way:
• Please include a kinamatic diagram (one for
velocity and one for acceleration).
• Please DO NOT solve this using velocity
analysis (cartesian vector analysis). I would
like it to be solved using scalar method. We
dont use 3D in this course. We only use scalar
analysis for the relative velocity equation
(writing the x and y components of the
equation and solving the equations for the
unknowns). I have attached a sample question
with solution in order to get an idea on how to
use the scalar method to solve my question. I
would like question 16-109 to be solved in a
similar way. Thank you for your
understanding.
If you can solve it as soon as possible that
would be great and I will give you a thumps up
and positive feedback :)
16-109. Member AB has the angular motions shown.
Determine the angular velocity and angular acceleration of
members CB and DC.
100 mm
D
60°
450 mm
W
AB
α AB
84
= 2 rad/s
= 4…
2:01
ul 4G 4.
A sulms.su.edu.om
While constructing a building, an engineer need to fix
two steel beams together using a bracket as shown
in Figure 1. Using absolute coordinate system,
construct a G-code program for drilling hole number
3 only. To remove the metal chips the hole should be
done in three equal steps. During the drilling, coolant
should be on before spindle starts and stop after
spindle stops. The spindle speed set to 1750 RPM.
Drilling bit in rack number 2 and it should be 1 mm
over the work piece. Drilling feed rate is 20 mm/min.
Explain each code used in the program in a
column
57.5-
12.5
Hole (4)
Hole (3)
30
Hole (1)
Hole (2)
ΧΟ Υ0ΖΟ
All dimensions shown are in mm
Figure 1
B.
->
28
•..
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
Locate the centroid of the area. Prob. 9-17
Engineering Mechanics: Statics
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
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
The moment of inertia Iy for the slender rod in terms of the rod’s total mass m .
Engineering Mechanics: Statics & Dynamics (14th Edition)
Steady state conduction rate to the warm compressor to the net power produces theoretically by thermodynamic ba...
Introduction to Heat Transfer
A biological fluid moves at a flow rate of m=0.02kg/s through a coiled, thin-walled, 5-mm-diameter tube submerg...
Fundamentals of Heat and Mass Transfer
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
- Select the graph showing Tmax versus D1 after answering the question.arrow_forwardQUESTION 2 Consider the following dataset and separator. What is the width of margin (distance between the two paralel lines )? Please use real numbers instead of rations. Eg, f your result is1/2, enter 0.5 w.x+b = +1 w.x+b =0 w.x+b= -1 2.0 0. 05 VW.warrow_forwardScenario You are assigned a role as a mechanical engineer for a vehicle design manufacturing company. Your department has a software to perform numerical differentiation and integration. To be able to verify the results of using the software and validate these results, your department manager has asked you to analytically perform some tasks to validate the results generated by the software. Q: is the last two digits of your student Id number. If your number is (20110092) then Q=92. P: is the last digit of your student Id Number. If your number is (20110092) then P=2, If that digit equals zero then use P=1. Example: If your number is (20110040) then P=1. Task 1 Determine the gradient of following functions at the given points: a) x(t) = (2t7 + P t-2)² + (6vi – 5) when t = 1 5s+7 b) v(s) = when s = 3 (s²-P)2 c) i(t) = 5(1 – In(2t – 1) ) when t= 1 sec. d) V(t) =5sin(100nt + 0.2) Volts , find i(t) = 10 × x10-6 dV©) Ampere when t= 1ms. dt e) y(t) = e¬(t-n) sin(Qt + P) when t = n radian f)…arrow_forward
- You own a wheat warehouse with a capacity of 20,000bushels. At the beginning of month 1, you have 6,000 bushels of wheat. Each month, wheat can be bought and sold at theprice per 1000 bushels given in Table 46.The sequence of events during each month is as follows:a You observe your initial stock of wheat.b You can sell any amount of wheat up to your initialstock at the current month’s selling price.c You can buy (at the current month’s buying price) asmuch wheat as you want, subject to the warehouse sizelimitation.Your goal is to formulate an LP that can be used to determine how to maximize the profit earned over the next 10monthsarrow_forwardPosted below is a picture of a data table and a diagram of an experiment. In the experiment you rolled a marble down a ruler ramp off the end of a coffee table to observe projectiles and conservation of energy. You do 3 trials for each initial height. Each height is measured in meters. h= initial height of marble off of table Y= height of table off floor X= horizontal distance marble goes from edge of table to where it strikes the floor a) use the table to find information you need to solve for theoretical range and % of error in measured range.arrow_forwardUse the following information to answer the next three questions Mobile power plants, such as the one illustrated below, are used in remote locations. Flowing water turns a turbine, which then moves a coil of wire through a magnetic field. Mobile Power Plant Moving water Stream flowing downhill Location I Water turning turbine Location II -Spinning turbine -Permanent magnet Rotating wire coil Split-ring commutator Metal brush 10. The components that connect to the spinning turbine in the illustration on the previous page form a O ammeter O generator O motor 1. O transformer Your reasoning: MacBook Proarrow_forward
- convert height to cm File Edit View Insert Format Data Tools 100% % .0 .00 123 D20 fx | A 1 5 feet 2 11 inches 3 cm 4 The preceding image shows a Google Sheet used to convert length in feet and inches to cm. What formula should be entered into A3 so that the correct length is computed in cm (in cell A3)? Your answer must work with any values the user might enter in cells A1 and A2. Choose all that apply a) = A1*12*2.54 + A2*2.54 b) = (5*12 + 11) * 2.54 %3D c) = B1*12*2.54 + B2*2.54 d) A1*12*2.54 + A2*2.54 e) = (A1*12 + A2) * 2.54 f) = A1*12 + A2 * 2.54 %24 田arrow_forwardWhat is the weight of 1 m3 of kerosene if it has a mass of 25 kg? O 245.25 N 25 N 25.26 N O 60.23 N A Moving to another question will save this response.arrow_forwardFor a given heat flux, the temperature gradient and the thermal conductivity are O A. twice the size of the heat flux O B. directly proportional OC. the same OD. inversely proportional Type here to search Et 99+arrow_forward
- I wanted to create two spheres that overlap each other in MATLAB. The image has my code and results. I only see one sphere in the results. Why is that? Can you give me the code that will create two overlaying spheres in one plot?arrow_forwardI downloaded this question multiple times but I had no answerarrow_forwardusing the sine bar technique, find the value of the angle for the given data: the stacked height was composed of the following values, 30, 20, 5, 2 and 1.1 mm. The length of the sine bar is 150 mm. Support your answer by sketch.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
Dimensional Analysis - in physics; Author: Jennifer Cash;https://www.youtube.com/watch?v=c_ZUnEUlTbM;License: Standard youtube license