Thinking Like an Engineer: An Active Approach, Student Value Edition Plus MyLab Engineering with Pearson eText - Access Card Package (4th Edition)
4th Edition
ISBN: 9780134701264
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
For 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]
A vertical chemical reactor undergone a maintenance in which its internals were subjected inspection from bottom to top before catalyst loading. A site engineer (63.00 kg) was tasked to do the inspection and he stopped from time to time at each portion to inspect. A safety officer monitored the engineer’s position while watching from the top and reported his position (Refer to the photo attached. CORRECTION for data table at t=70.00 min, position=725.0 cm):
Solve for:
(a) Power he exerted at t = 50.00 min
(b) Power he exerted at t = 65.00 min
(c) Total Work he exerted throughout the inspection
(d) Average Power throughout the inspection
Briefly explain each of the following block (one sentence or less)a) G96 S200 M03b) G00G42X20.0Z2.0c) G92 X59.0 Z-50.0 R-2.5 F0.25 d) G72 P10 Q20 U1.0 W0.5 F0.2
Chapter 10 Solutions
Thinking Like an Engineer: An Active Approach, Student Value Edition Plus MyLab Engineering with Pearson eText - Access Card Package (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
- An aluminum plate measuring 15 cm long, 10 cm wide and 1 cm thick was cooled in air. At the time of cooling, the ambient temperature was equal to 23 °C. Experimental data were measured and are shown in Table 1. Calculate the Heat exchanged by the body in J. Consider in the answer one decimal place after the comma. Table 1 - Experimental data t(s) T (oC) 0 63 146 58 375 52 475 50 625 47 730 45 917 42 1056 40 1224 38 1391 36 1613 34 1895 32 Aluminum data: density = 2702 kg/m3; Cp = 903 J/kg K and k = 237 W/m Karrow_forwardEngr 215 Matlab Fahrenheit to Celsius using multiple statements Given a Fahrenheit value temperatureFahrenheit, write a statement that assigns temperatureCelsius with the equivalent Celsius value. While the equation is C = 5/9 * (F - 32), as an exercise use two statements, the first of which is "fractionalMultiplier = 5/9;"]arrow_forwardThe following table lists molecular weight data for a polypropylene material. Compute the number-average molecular weight, Molecular Weight Range (g/mol)//// xi////// wi 8,000–16,000//// 0.05/// 0.02 16,000–24,000 ///0.16// 0.10 24,000–32,000 ///0.24// 0.20 32,000–40,000 ///0.28// 0.30 40,000–48,000 ///0.20// 0.27 48,000–56,000 ///0.07// 0.11 Round your answer to 0 decimal places.arrow_forward
- The following table lists molecular weight data for a polypropylene material. Compute the weight-average molecular weight, Molecular Weight Range (g/mol)//// xi////// wi 8,000–16,000//// 0.05/// 0.02 16,000–24,000 ///0.16// 0.10 24,000–32,000 ///0.24// 0.20 32,000–40,000 ///0.28// 0.30 40,000–48,000 ///0.20// 0.27 48,000–56,000 ///0.07// 0.11 Round your answer to 0 decimal places.arrow_forwardusing matlab: 1. Write a code that demonstrates sin2(x) + cos2(x) = 1 with different values. Assign: x1 = pi/6 x2 = pi/4 x3 = pi/3 and test all values.arrow_forwardDraw each of the followings within a separate unit cell. a. [2201] e. [00̅1 ̅1] i. (00̅10) m. (010̅1)b. [1̅11̅] f. [31̅2] j. (21̅1) n. (2̅12)c. [̅1 ̅201] g. [̅1001] k. (1000) o. (̅2 1̅10)d. [2̅12] h. [301] l. (31̅3) p. (301)arrow_forward
- Suppose you're converting a bill of materials for machining feedstock from the British gravitational (U.S. system) of units to International System (SI) units. Your goal is to have all of the material quantities in kilograms. Your bill of materials lists values for required weights of brass rod in pounds. To convert to these values to kilograms you first you divide by gravitational acceleration in feet per second squared to get a mass in slugs, then convert slugs to kilograms using standard conversion factors. Group of answer choices True Falsearrow_forwardI am not entierly sure where I when wrong here but I ended up getting 38.188lbs as an incorrect answer. I am pretty confident in my meathod I just belive I made an algibraic error. Could you solve this for me? thank you so much.arrow_forwardThe amount of time it takes for a pendulum to swing “to-and-fro” through one complete cycle is called the “period” and is calculated using the following equation: where T = period in seconds, I = mass moment of inertia, m = mass of pendulum in kilograms g = gravitational acceleration, 9.8 m/s2, h = effective length of pendulum in meters What is the appropriate unit for I if the preceding equation is to be homogeneous in units? Please show all of your work.arrow_forward
- GIVE ME THE COMPLETE SOLUTION FOR THISTHIS IS THE ANSWER ACC TO THE ANSWER KEY I JUST NEED HELP FOR THE SOLUTION Theta3/T = ((5*s^2 + 9*s + 9))/(15*s^5 + 47*s^4 + 117*s^3 + 161*s^2 + 81*s)arrow_forward1. Circle weather the following statements are true or false. If the statement is true justify your reasoning if the statement is false correct the statement to make it true or justify why it is false a. Impulse is the integral of a force vs distance graph b. In two dimensions analyzing linear and angular momentum provides up to three scalar equations. c. Linear acceleration and angular acceleration both have units of ft/s^2 or m/s^2 d. When absolute motion or a rigid body it is important to find a function that relates linear and angular position then integrate to find velocity e. Instantaneous centers can only be determined for velocity and only for a snapshot in timearrow_forwardLemar Supermarket sells about 200 000 kilos of milk annually. The milk ispurchased for 4 MU/kg. Holding costs are 1.40 MU/kg/yr. Each order costs 35 MU. If theshelf life of the milk is only 5 days, how many kilos should be ordered at a time. Please mention formulas and do it in detail so I can understand.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