5-2 Activity- Analysis and Summary Pace
.docx
keyboard_arrow_up
School
Southern New Hampshire University *
*We aren’t endorsed by this school
Course
220
Subject
Mechanical Engineering
Date
Apr 3, 2024
Type
docx
Pages
2
Uploaded by ChancellorPenguin3235
Prechea Pace 5-2 Activity: Analysis and Summary
02/09/2024
DAD 220 Analysis and Summary Template
1.
Analyze the data
you’ve been provided with to identify themes
:
a.
Which parts are being replaced most?
i.
The part that undergoes the highest number of replacements is the Fuel tank, with 95 instances. The others would be tire repair (74) and tire replacement (66). I was able to find this information using the SQL command mysql> select distinct(Part_Replacement), Count(*) FROM Parts_Maintenance group by Part_Replacement;
b.
Is there a region of the country that experiences more part failures and replacements than others?
i.
Identify region:
Prechea Pace 5-2 Activity: Analysis and Summary
02/09/2024
The Midwest region reports the highest number of repairs, totaling 260.
ii.
How might the fleet maintenance team use the information to update its maintenance schedule? 1.
[The maintenance team is able to use this information to stock up on the parts that are sold the most.
c.
Which parts are being replaced most due to corrosion or rust?
i.
[The Wheel Arch sees the most replacements due to corrosion or rust.]
d.
Which parts are being replaced most because of mechanical failure or accident, like a flat tire or rock through the windshield?
i.
[Tire repairs are the most frequent type of repairs, with 74 instances.]
2.
Write a brief summary of your analysis
that
takes the information from Step 1 and presents it in
a way that nontechnical stakeholders can understand.
a.
By using Codio, I was able to thoroughly analyze the Fleet Maintenance Records. I was also able to identify the parts that were being replaced the most, such as windshields, tires, fenders, and brake lines. I was also able to identify which regions experienced the most repairs; and Northeast had 208 Midwest totaling 260. I was also able to view which parts were being replaced most due to rust; between 50 and 55 replacements. I also identified that tires and windshields are the most replaced parts due to mechanical failure or accident.]
3.
Outline the approach
that you took to conduct the analysis. a.
What queries did you use to identify trends or themes in the data?
i.
[SELECT, COUNT(*), WHERE, LIKE, AS, OR, GROUP BY, and ORDER BY.]
b.
What are the benefits of using these queries to retrieve the information in a way that allows you to provide valuable information to your stakeholders?
i.
[Using these types of queries makes sorting through the data quickly and efficient while narrowing down searches to specific parts and reasons for replacement.]
4.
Explain how the functions in the analysis tool allowed you to organize the data and retrieve records quickly.
a.
[Using commands such as GROUP BY, COUNT(*), and ORDER BY DESC made the information in the table easier to view and understand by sorting out the data.]
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Related Questions
The following tools / resources may be useful for you to complete the assignment:a. Chatgpt (You may use it to learn Matlab coding or any other computer language. An example is given here: https://shareg.pt/mXHGne9 ). Please take note that code generated by chatgpt can be directly copied and pasted.b. Matlabi) Useful cheat sheet (https://n.ethz.ch/~marcokre/download/ML-CheatSheet.pdf)ii) Getting started with Matlab (https://matlabacademy.mathworks.com/en/details/gettingstarted )iii) Getting 30-day Matlab trial license (https://www.mathworks.com/campaigns/products/trials.html ) iv) Polyfit (https://www.mathworks.com/help/matlab/ref/polyfit.html )v) Exponential Fit (https://www.mathworks.com/matlabcentral/answers/91159-how-do-i-fit-an-exponential-curve-to-my-data)c. PlotDigitizer (https://plotdigitizer.sourceforge.net/ ) or a free online app that does not requires installation (https://plotdigitizer.com/app )You may use your own engineering judgement to make any assumptions on any…
arrow_forward
Motiyo
Add explanation
arrow_forward
Identify the lines
arrow_forward
You are assigned as the head of the engineering team to work on selecting the right-sized blower that will go on your new line of hybrid vehicles.The fan circulates the warm air on the inside of the windshield to stop condensation of water vapor and allow for maximum visibility during wintertime (see images). You have been provided with some info. and are asked to pick from the bottom table, the right model number(s) that will satisfy the requirement. Your car is equipped with a fan blower setting that allow you to choose between speeds 0, 1,2 and 3. Variation of the convection heat transfer coefficient is dependent upon multiple factors, including the size and the blower configuration.You can only use the following parameters:
arrow_forward
.
arrow_forward
You are a biomedical engineer working for a small orthopaedic firm that fabricates rectangular shaped fracture
fixation plates from titanium alloy (model = "Ti Fix-It") materials. A recent clinical report documents some problems with the plates
implanted into fractured limbs. Specifically, some plates have become permanently bent while patients are in rehab and doing partial
weight bearing activities.
Your boss asks you to review the technical report that was generated by the previous test engineer (whose job you now have!) and used to
verify the design. The brief report states the following... "Ti Fix-It plates were manufactured from Ti-6Al-4V (grade 5) and machined into
solid 150 mm long beams with a 4 mm thick and 15 mm wide cross section. Each Ti Fix-It plate was loaded in equilibrium in a 4-point bending
test (set-up configuration is provided in drawing below), with an applied load of 1000N. The maximum stress in this set-up was less than the
yield stress for the Ti-6Al-4V…
arrow_forward
7
Create your own 3 unique problems on the First Law of Thermodynamics/Forms of Energy and Equations of State with detailed Solutions. Include diagrams as much as possible
arrow_forward
In the automotive industry, supercars are highly accredited with how they are manufacture; from the
type of car chassis used to the type of materials employed. Often enough, companies like BMW,
Mercedes & Audi produces supercars that exemplifies a better reliability compared to other automotive
manufacturing companies. This is because they pay close attention to the details on how the car is
manufactured; right from raw materials to a finished supercar. The task given to you is to watch the
video link provided below & explain the electrostatic process acquired for the two different models of
BMW vehicles.
https://www.youtube.com/watch?v=sUqKUbmdOr0
Pls watch the video before answering
arrow_forward
I want the answer of part c
arrow_forward
I need help with the first part and Matlab for this problem
arrow_forward
Don't copy paste someone else answer if I get to know I'll report and downvote too do on your own and only handwritten with proper steps not that handwritten only
arrow_forward
11)
arrow_forward
Which of the follow statement(s) correctly completes the following sentence fragment?
The setup() function in an Arduino sketch ...
(There may be more than one correct answer)
a) is executed only once after a new sketch is uploaded to the Arduino board, or the Arduino
board is reset (user presses "reset" button).
b) can be replaced by a user-defined function like "my_setup()"
c) must always start by making a serial connection to the host computer with Serial.begin().
d) is executed only once when an Arduino board that has been disconnected from the USB
cable is reconnected to that cable. (Assume that the other end of the USB cable is connected
to a computer)
arrow_forward
Could you please fix my code it’s supposed to look like the graph that’s on the picture. But the lines do not cross eachother at the beginning. Could you make the lines look like the lines on the graph?
Use this code in MATLAB and fix it.
% Sample data for Diesel and Petrol cars
carPosition = linspace(1, 60, 50); % Assumed positions of cars
% Define your seed here
seed = 50;
rand('seed',seed); % Set the seed for reproducibility
% Assumed CO2 emissions for Diesel and Petrol
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 with a reduced degree of 2
pDiesel = polyfit(carPosition, CO2Diesel, 2);
pPetrol = polyfit(carPosition, CO2Petrol, 2);
% Generate points for best fit lines
fitDiesel = polyval(pDiesel, carPosition);
fitPetrol = polyval(pPetrol, carPosition);
% Plotting the data
figure;
hold on;
% Plot Diesel best fit line…
arrow_forward
Choose the correct answer, please, I need the solution as soon as possible
arrow_forward
I need help solving this problem.
arrow_forward
For the air compressor shown in Figure below, the air enters from a large area and
exit from small one, explain why?
Instructions for answering this question: The answer to this questian is required as handwritten where you are
aiso required to add a Handwritten integrity Statement. Pieose follow the below steps:
1 Write on a blank poper your AUM student ID, full name, course code, section and date
2 Write the following integrity statement and sign:
"7 offirm that I have neither given nor received any help on this assessment and that personally compieted it
on my own."
3. Write your onswer to the obove question as required
4. Put your Original Civil ID card or AUM ID card on the poper
5 Toke o picture or scan, and uplood
Important note: if handwritten document is submitted without the integrity stotement including ID (Civil ID or
AUM ID), then the related handwritten question(s) will not be groded.
arrow_forward
Esker on Demand- Customer X Chat Process Jobs In Hyderaba x
(Messages | Mynaukri
M Chegg Expert Hiring | Complet x
O Zoho Creator - Chegg Expert
experthiring.cheggindia.com/%23Form:Subject test?privateLink=bF53Pq3tqOdXDb6qq0PKbXBKnU6s212F4b2fdONuXXgZX2DTmgJz56EF3A79haQq4A..
Q
S Paused
Apps
State Bank of India...
Welcome to Esker o...
I Feet to Inches conv...
en Watch Super Hit Ful...
IRCTC Next Generat...
A TASHRM
A Time Tracker Time
Prime Video: Good...
Chin Expert Hr
saKANOLA
Subect Test
Determine the Sommerfeld number of a bearing whose clearance ratio is 600 and the
bearing load is 750 lbf . The length and radius of the given bearing is 1.75 in. and 0.75 in.
respectively. The viscosity of the oil inside the bearing is u=6 µreyn. The bearing is
rotating at a speed of 1800 rpm.
a) 0.28
b) 0.58
c) 0.23
d) 0.36
Activate Windows
Go to Settings to activate Windows.
453 PM
ヘ)み
OType here to search
THan-21
oms UP
...
arrow_forward
please in detaild
arrow_forward
Please recheck and provide clear and complete step-by-step solution in scanned handwriting or computerized output thank you
arrow_forward
For all the following problems,
a)
b)
4.
You need to show at least 3 iterations calculated manually with all steps.
You do not need to include the M.files for the bisection method (bisect.m) and for false position (falspos.m). You
must, however, show the command lines for the given functions with their variables and other parameters.
Zero-pressure specific heat of dry air
Mechanical engineers, as well as most other engineers, use thermodynamics extensively
in their work.
The following polynomial can be used to relate the zero-pressure specific heat of
dry air cp kJ/(kg K) to temperature (K):
11
0.99403 +1.671×10-4T + 9.7215-10-8T²-9.5838×10-
Cp
=
T3+1.9520×10-14T4
(a) Develop a plot of cp versus a range of T=0 to 1200 K.
(b) Use bisection to determine the temperature T that corresponds to a specific heat of 1.1 kJ/(kg K).
(c) What will be the value of T if you use false position method?
(d) What is the percentage error between the results of (b) and (c)?
For both methods use maximum…
arrow_forward
Hartley Electronics, Inc., in Nashville, producesshort runs of custom airwave scanners for the defense industry.The owner, Janet Hartley, has asked you to reduce inventory byintroducing a kanban system. After several hours of analysis, youdevelop the following data for scanner connectors used in onework cell. How many kanbans do you need for this connector?Daily demand 1,000 connectorsLead time 2 daysSafety stock 12 dayKanban size 500 connectors
arrow_forward
https://ethuto.cut.ac.za/webapps x
Content
Take Test: Main assessment link - x
ethuto.cut.ac.za/webapps/assessment/take/launch.jsp?course_assessment_id= 26832 1&course_id3_10885_1&content_id%3 625774 1&step3Dnull
Question Completion Status:
QUESTION 20
A single-stage, single-acting air compressor with runs at speed 600 rpm. It has a polytropic index of
1.26. The induced volume flow rate is 7.2 cubic meters per min and the air must be delivered at a
pressure of 668 kPa. The free air conditions are 101.3 kPa and 18 degrees Celsius. The clearance
volume is 6% of the stroke volume and the stroke/bore ratio is 1.6/1. Calculate the delivery air.
Hint answer usaully in C and no need for °C.
arrow_forward
I need a clear answer by hand, not by keyboard and fast answer within 20 minutes. Thank you | dybala
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
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
Related Questions
- The following tools / resources may be useful for you to complete the assignment:a. Chatgpt (You may use it to learn Matlab coding or any other computer language. An example is given here: https://shareg.pt/mXHGne9 ). Please take note that code generated by chatgpt can be directly copied and pasted.b. Matlabi) Useful cheat sheet (https://n.ethz.ch/~marcokre/download/ML-CheatSheet.pdf)ii) Getting started with Matlab (https://matlabacademy.mathworks.com/en/details/gettingstarted )iii) Getting 30-day Matlab trial license (https://www.mathworks.com/campaigns/products/trials.html ) iv) Polyfit (https://www.mathworks.com/help/matlab/ref/polyfit.html )v) Exponential Fit (https://www.mathworks.com/matlabcentral/answers/91159-how-do-i-fit-an-exponential-curve-to-my-data)c. PlotDigitizer (https://plotdigitizer.sourceforge.net/ ) or a free online app that does not requires installation (https://plotdigitizer.com/app )You may use your own engineering judgement to make any assumptions on any…arrow_forwardMotiyo Add explanationarrow_forwardIdentify the linesarrow_forward
- You are assigned as the head of the engineering team to work on selecting the right-sized blower that will go on your new line of hybrid vehicles.The fan circulates the warm air on the inside of the windshield to stop condensation of water vapor and allow for maximum visibility during wintertime (see images). You have been provided with some info. and are asked to pick from the bottom table, the right model number(s) that will satisfy the requirement. Your car is equipped with a fan blower setting that allow you to choose between speeds 0, 1,2 and 3. Variation of the convection heat transfer coefficient is dependent upon multiple factors, including the size and the blower configuration.You can only use the following parameters:arrow_forward.arrow_forwardYou are a biomedical engineer working for a small orthopaedic firm that fabricates rectangular shaped fracture fixation plates from titanium alloy (model = "Ti Fix-It") materials. A recent clinical report documents some problems with the plates implanted into fractured limbs. Specifically, some plates have become permanently bent while patients are in rehab and doing partial weight bearing activities. Your boss asks you to review the technical report that was generated by the previous test engineer (whose job you now have!) and used to verify the design. The brief report states the following... "Ti Fix-It plates were manufactured from Ti-6Al-4V (grade 5) and machined into solid 150 mm long beams with a 4 mm thick and 15 mm wide cross section. Each Ti Fix-It plate was loaded in equilibrium in a 4-point bending test (set-up configuration is provided in drawing below), with an applied load of 1000N. The maximum stress in this set-up was less than the yield stress for the Ti-6Al-4V…arrow_forward
- 7 Create your own 3 unique problems on the First Law of Thermodynamics/Forms of Energy and Equations of State with detailed Solutions. Include diagrams as much as possiblearrow_forwardIn the automotive industry, supercars are highly accredited with how they are manufacture; from the type of car chassis used to the type of materials employed. Often enough, companies like BMW, Mercedes & Audi produces supercars that exemplifies a better reliability compared to other automotive manufacturing companies. This is because they pay close attention to the details on how the car is manufactured; right from raw materials to a finished supercar. The task given to you is to watch the video link provided below & explain the electrostatic process acquired for the two different models of BMW vehicles. https://www.youtube.com/watch?v=sUqKUbmdOr0 Pls watch the video before answeringarrow_forwardI want the answer of part carrow_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