DAD 220 Analysis and Summary Template BROWN
.docx
keyboard_arrow_up
School
Southern New Hampshire University *
*We aren’t endorsed by this school
Course
220
Subject
Mechanical Engineering
Date
Feb 20, 2024
Type
docx
Pages
8
Uploaded by ChancellorKangaroo151
DAD 220 Analysis and Summary Template
Replace the bracketed text in this template with your responses and any supporting screenshots. Then submit it to the Module Five Activity for grading and feedback. Rename this document by adding your last name to the file name before you submit. Table Creation: CREATE TABLE Parts_Maintenance (vehicle_id VARCHAR(20), state VARCHAR(2), repair VARCHAR(50), reason VARCHAR(50), year INT, make VARCHAR(20), body_type VARCHAR(50));
Data Into File:
LOAD DATA INFILE '/home/codio/workspace/FleetMaintenanceRecords.csv' INTO Table Parts_Maintenance FIELDS TERMINATED BY ',' LINES TERMINATED BY '\r\n';
1.
Analyze the data
you’ve been provided with to identify themes
:
a.
Which parts are being replaced most?
From the information in the table below, it would appear as though the Fuel Tank is being replaced the most, with 95 replacements. This is followed by Tire Repair at 74 and Tire Replacement at 66.
Command: SELECT repair AS PART_REPAIR, COUNT(*) AS NUMBER_OF_REPAIRS
FROM Parts_Maintenance
GROUP BY PART_REPAIR
ORDER BY NUMBER_OF_REPAIRS DESC;
b.
Is there a region of the country that experiences more part failures and replacements than others?
i.
Identify region:
1.
The results of my query show that the Midwest region experiences more part failures and replacements than any other region with 260 total
Command: SELECT 'SOUTHWEST' AS REGION, COUNT(*) AS NUMBER_OF_REPAIRS
FROM Parts_Maintenance
WHERE UPPER(state) IN ('AZ','NM','TX','OK')
UNION
SELECT 'SOUTHEAST' AS REGION, COUNT(*) AS NUMBER_OF_REPAIRS
FROM Parts_Maintenance
WHERE UPPER(state) IN ('AR','LA','MS','AL','GA','FL','KY','TN','SC','NC','VA','WV','DE','MD')
UNION
SELECT 'NORTHEAST' AS REGION, COUNT(*) AS NUMBER_OF_REPAIRS
FROM Parts_Maintenance
WHERE UPPER(state) IN ('PA','NJ', 'NY','CT','RI','MA','VT','ME','NH')
UNION
SELECT 'MIDWEST' AS REGION, COUNT(*) AS NUMBER_OF_REPAIRS
FROM Parts_Maintenance
WHERE UPPER(state) IN ('ND','SD','KS','NE','MN','WI','IA','MO','MI','IN','IL','OH')
UNION
SELECT 'WEST' AS REGION, COUNT(*) AS NUMBER_OF_REPAIRS
FROM Parts_Maintenance
WHERE UPPER(state) IN ('WA','ID','MT','OR','WY','CO','UT','NV','CA')
ORDER BY NUMBER_OF_REPAIRS DESC;
ii.
How might the fleet maintenance team use the information to update its maintenance schedule?
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
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
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
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
Please draw the right side view.
Don't copy from anywhere else. Please write the dimensions as well.
arrow_forward
AutoSave
STATICS - Protected View• Saved to this PC -
O Search (Alt+Q)
Off
ERIKA JOY DAILEG
EJ
File
Home
Insert
Draw
Design
Layout
References
Mailings
Review
View
Help
Acrobat
O Comments
E Share
PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View.
Enable Editing
Situation 9 - A 6-m long ladder weighing 600 N is shown in the Figure. It is required to determine
the horizontal for P that must be exerted at point C to prevent the ladder from sliding. The
coefficient of friction between the ladder and the surface at A and B is 0.20.
25. Determine the reaction at A.
26. Determine the reaction at B.
27. Determine the required force P.
4.5 m
1.5 m
H=0.2
30°
Page 5 of 5
671 words
D. Focus
100%
C
ЕPIC
GAMES
ENG
7:24 pm
w
US
16/02/2022
IZ
arrow_forward
Create an illustration or diagram of the amusement park ride called THE BUMPER CAR RIDE, then proceed to add labels based on the guidelines provided within the image.
The screenshot is the example of the diagram BUT THAT IS A DIAGRAM OF THE GRAVITRON RIDE. I need an illustration DIAGRAM OF THE BUMPER CAR RIDE, do not answer using AI.
arrow_forward
4. Documents business requirements use-case narratives.for only one process
note: please i want Documents like this in pic
arrow_forward
I need help solving these 3 simple parts, if you can not answer all 3 parts then please leave it for another tutor, thank you.
arrow_forward
Draw it on the graph provided please!
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
The first photo is the question, where the 2nd shows some problem solving strategies
arrow_forward
Please do only C part with breif explanation. I want typed solution. Not hand written
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
Can you help me with this problem?
P1 is where the blue dot is
arrow_forward
I need help solving this problem.
arrow_forward
Every time I use this code the two lies come up but they keep on showing up separately. I need one line on top of the other or make it look like one line just like it’s shown on the picture I need the two line together and make it one line. If you can please make the lines less curved make it look line the line on the picture.
With what I’m asking from you please fix it using this code using MATLAB and send back the code.
% 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 =…
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
I drew it but I don't know where I have to connect it. Where do I put dashed lines (if needed) where are the solid lines? Did I do it right?
arrow_forward
There is a small space between the orange and purple line could you please connect the two lines together also can you please make the purple line shorter and then connect the purple line to the orange line, please take out the box that says “Diesel, petrol, Diesel best fit, petrol best fit”. Also when ever I run this code the graph shows up but there are still errors that comes up could you please fix them when you are running this on MATLAB.
Please use this code on MATLAB and fix it.
% 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 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
pDiesel = polyfit(carPosition, CO2Diesel, 3);
pPetrol = polyfit(carPosition, CO2Petrol, 3);
% Generate…
arrow_forward
Don't Use Chat GPT Will Upvote And Give Handwritten Solution Please
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
Can someone please help to solve all of the following problem showing all work and include a load chart. Thank you!
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
I was going over the equations for the notes in class and I had a thought. Based on the equations in the image, you could get negative propellant mass. So, I coded it in matlab and I got negative mass. How is that possible? I think I used practical values for the velocity and mass ratio and so on. Did I do something wrong?
arrow_forward
I want the answer of part c
arrow_forward
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
Please draw 5 and 6
arrow_forward
Identify the lines
arrow_forward
I want to answer all the questions by handwriting.
arrow_forward
Can you write me a program manuscript using geometric definition on FAPT language.
The starting point is P1 and starts where the blue dot is. P1 = 0,0
arrow_forward
arrow_forward
Oh no! Our expert couldn't answer your question.
Don't worry! We won't leave you hanging. Plus, we're giving you back one question for the inconvenience.
Here's what the expert had to say:
Hi and thanks for your question! Unfortunately we cannot answer this particular question due to its complexity. We've credited a question back to your account. Apologies for the inconvenience.
Ask Your Question Again
5 of 10 questions left
until 8/10/20
Question
Asked Jul 13, 2020
1 views
An air conditioning unit uses Freon (R-22) to adapt an office room at temperature 25 oC in the summer, if the temperature of the evaporator is 16 oC and of the condenser is 48 oC. The reciprocating compressor is single acting, number of cylinders are 2, the volumetric efficiency is 0.9, number of revolutions are 900 r.p.m. and L\D= 1.25. If the compressor consumes a power of 3 kW and its mechanical efficiency is 0.9. Find the following:
(A) Flow rate of the refrigerant per…
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
- 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_forwardWhich 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_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
- Please draw the right side view. Don't copy from anywhere else. Please write the dimensions as well.arrow_forwardAutoSave STATICS - Protected View• Saved to this PC - O Search (Alt+Q) Off ERIKA JOY DAILEG EJ File Home Insert Draw Design Layout References Mailings Review View Help Acrobat O Comments E Share PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing Situation 9 - A 6-m long ladder weighing 600 N is shown in the Figure. It is required to determine the horizontal for P that must be exerted at point C to prevent the ladder from sliding. The coefficient of friction between the ladder and the surface at A and B is 0.20. 25. Determine the reaction at A. 26. Determine the reaction at B. 27. Determine the required force P. 4.5 m 1.5 m H=0.2 30° Page 5 of 5 671 words D. Focus 100% C ЕPIC GAMES ENG 7:24 pm w US 16/02/2022 IZarrow_forwardCreate an illustration or diagram of the amusement park ride called THE BUMPER CAR RIDE, then proceed to add labels based on the guidelines provided within the image. The screenshot is the example of the diagram BUT THAT IS A DIAGRAM OF THE GRAVITRON RIDE. I need an illustration DIAGRAM OF THE BUMPER CAR RIDE, do not answer using AI.arrow_forward
- 4. Documents business requirements use-case narratives.for only one process note: please i want Documents like this in picarrow_forwardI need help solving these 3 simple parts, if you can not answer all 3 parts then please leave it for another tutor, thank you.arrow_forwardDraw it on the graph provided please!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 answeringarrow_forwardThe first photo is the question, where the 2nd shows some problem solving strategiesarrow_forwardPlease do only C part with breif explanation. I want typed solution. Not hand writtenarrow_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