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
Don't Use Chat GPT Will Upvote And Give Handwritten Solution Please
Use MATLAB, please make sure you use the numbers on the picture to make the graph that is also on the pictures. Make an exact copy of that graph and make sure that it runs on MATLAB, please send the code and a screenshot of the graph to show that it works. I need help with this.
I need these three parts answered, if you are unable to answer all three parts please leave it for another tutor to answer, thank you.
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
- please do need answer for d e and f With value of student 4arrow_forwardFor Questions 3 and 4: A cup of water was heated to a temperature of 90°. It was placed in a refrigerator that had a temperature of 11°C. The water cooled to a temperature of 17°C in 30 minutes. Let the following variables represent the relevant quantities. L = Temperature of the liquid S= Temperature of the surroundings t = Time B = Initial temperature of the liquid (Temperature at t = 0 k = Cooling constant 3. Using the Equation Solver, find the value of k in the equation L = (B - S)e -kt + S. Remember to set the equation equal to zero and then enter it into the Solver.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
- PART A Using the graph to the right, what would Air Pressure be (mb) at an altitude of 10 km? What is the approximate altitude where the air pressure is 400 mb? PART B At an altitude of 0 km, what is the air pressure in mb?arrow_forward4: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…arrow_forwardPlease help me with drawing.arrow_forward
- 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 •..arrow_forwardI need help solving problems 7, 8, and 9 pertaining to the print attached below.arrow_forwardI need the answer as soon as possiblearrow_forward
- Hello I’m trying to make the graph that you see in the picture, I’m trying the exact copy of that graph using this code but I’m having a hard time doing that. Could you change the code so that it looks like the graph that you see on the picture using MATLAB, please send the code when you are finished. % Sample data for Diesel and Petrol cars carPosition = linspace(1, 60, 50); % Assumed positions of cars % Fix the random seed for reproducibility rng(45); % Assumed positions of cars CO2Diesel = 25 + 5*cos(carPosition/60*2*pi) + randn(1, 50)*5; % Random data for Diesel CO2Petrol = 20 + 5*sin(carPosition/60*2*pi) + randn(1, 50)*5; % Random data for Petrol % Fit polynomial curves pDiesel = polyfit(carPosition, CO2Diesel, 3); pPetrol = polyfit(carPosition, CO2Petrol, 3); % Generate points for best fit lines fitDiesel = polyval(pDiesel, carPosition); fitPetrol = polyval(pPetrol, carPosition); % Plotting the data figure; hold on; scatter(carPosition, CO2Diesel, 'o', 'MarkerEdgeColor', [1 0.5…arrow_forwardHi I need help to make the line change into a different color, I half of the line to be orange and I need the other half of the line towards the end to be purple as shown in the picture. Also I need there be a box saying Diesel, petrol, diesel best fit, petrol best fit. This part is also shown in the graph. Please use this code and fix it in MATLAB: % Sample data for Diesel and Petrol cars carPosition = linspace(1, 60, 50); % Assumed positions of cars % Fix the random seed for reproducibility rng(50); % Assumed positions of cars CO2Diesel = 25 + 5*cos(carPosition/60*2*pi) + randn(1, 50)*5; % Random data for Diesel CO2Petrol = 20 + 5*sin(carPosition/60*2*pi) + randn(1, 50)*5; % Random data for Petrol % Fit polynomial curves pDiesel = polyfit(carPosition, CO2Diesel, 3); pPetrol = polyfit(carPosition, CO2Petrol, 3); % Generate points for best fit lines fitDiesel = polyval(pDiesel, carPosition); fitPetrol = polyval(pPetrol, carPosition); % Combine the best fit lines combinedFit =…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_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