DAD 220 Analysis and Summary Medeiros
.docx
keyboard_arrow_up
School
Southern New Hampshire University *
*We aren’t endorsed by this school
Course
220
Subject
Mechanical Engineering
Date
Jan 9, 2024
Type
docx
Pages
8
Uploaded by rwmedeiros
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.
Explanation:
Created a table names
PartsMaintenance
using the following command:
CREATE TABLE PartsMaintenance (vehicle_id VARCHAR(20),
state VARCHAR(2), repair VARCHAR(50), reason VARCHAR(50),
year INT, make VARCHAR(20), body_type VARCHAR(50));
I was then able to show the command worked using the following
show table
command:
show tables;
1.
Analyze the data
you’ve been provided with to
identify themes
:
a.
Which parts are being replaced most?
Explanation:
Using the commands below:
SELECT repair AS PART_REPAIR, COUNT(*) AS NUMBER_OF_REPAIRS
FROM PartsMaintenance
GROUP BY PART_REPAIR
ORDER BY NUMBER_OF_REPAIRS DESC;
We can identify that the “
Fule” tank
(Fuel tank) is the most replaced part coming in at
95
replacements
.
b.
Is there a region of the country that experiences more part failures and replacements
than others?
i.
Identify region:
Explanation:
We can identify which region of the country that experiences more part failures and
replacements using the command below:
SELECT 'SOUTHWEST' AS REGION, COUNT(*) AS NUMBER_OF_REPAIRS
FROM PartsMaintenance
WHERE UPPER(state) IN ('AZ','NM','TX','OK')
UNION
SELECT 'NORTHEAST' AS REGION, COUNT(*) AS NUMBER_OF_REPAIRS
FROM PartsMaintenance
WHERE UPPER(state) IN ('PA','NJ','NY','CT','RI','MA','VT','ME','NH')
UNION
SELECT 'SOUTHEAST' AS REGION, COUNT(*) AS NUMBER_OF_REPAIRS
FROM PartsMaintenance
WHERE UPPER(state) IN ('AR','LA','AL','GA','TN','SC','NC','VA','WV','DE','MD')
UNION
SELECT 'MIDWEST' AS REGION, COUNT(*) AS NUMBER_OF_REPAIRS
FROM PartsMaintenance
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 PartsMaintenance
WHERE UPPER(state) IN ('WA','ID','MT','OR','WY','CO','UT','NV','CA')
ORDER BY NUMBER_OF_REPAIRS DESC;
The result of this query identifies the
Midwest
as experiencing the most part failures with
260
repairs
while the nest closest region is the
Northeast
with
208 repairs.
Using the
UNION
command to combine the multiple results that were received from
each
SELECT
statement that represented their own specific region.
ii.
How might the fleet maintenance team use the information to update its
maintenance schedule?
1.
Fleet Maintenance can use this information to alter their maintenance
schedule.
2.
More resources can be allotted to the regions with the highest number
of repairs.
3.
The team can from this point schedule and do more preventative
maintenance in those higher regions.
4.
Combining the previous tables with this information can also allow the
inventory and logistics departments to use more warehouse space for
the more pertinent parts that are needed.
c.
Which parts are being replaced most due to corrosion or rust?
i.
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
Choose the correct answer, please, I need the solution as soon as possible
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
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
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
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
Please draw the right side view.
Don't copy from anywhere else. Please write the dimensions as well.
arrow_forward
The first photo is the question, where the 2nd shows some problem solving strategies
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
Please draw 5 and 6
arrow_forward
Q1: write a program to enter any text and compute its length.
Q2: Design a form with a text box. Use select statement so
that when user enters g, b, r and y then form colored to
green, blue, red, and yellow respectively.
Q3: Write a program to print multipliers of 5 (from 5 to 50)
arrow_forward
Draw it on the graph provided please!
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
4. Documents business requirements use-case narratives.for only one process
note: please i want Documents like this in pic
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
Matlab code:
Read images from a folder with the
directory using the MATLAB code.
Be specific and don't write general
answer.
arrow_forward
Please Asap
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
Don't Use Chat GPT Will Upvote And Give Handwritten Solution Please
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
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
The picture that has two graphs are generated by this code. Every time I run it on MATLAB it keeps generating graphs with different curves. The picture that shows one graph is the curve that I want to keep. Please keep the color of the lines and the circles and keep the title of the graph the same. I want everything to be the same except I want the line to look exactly like the picture with one graph on it.
Use this code on MATLAB and fix it and then send the correct code back please.
% Sample data for Diesel and Petrol cars
carPosition = linspace(1, 60, 50); % Assumed positions of cars
% Use the 'seed' function instead of 'rng'
seed = 50; % Define your seed here
rand('seed',seed);
% 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,…
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
Q4: Create a Visual Basic Project to find the value of the following series:
h? h4 h3
cos(h) = h –
2!
3!
4!
Write the code program so that the value of angle (h) is entered into inputbox.
Estimate the value of series (cos(h)) so that the absolute value of any term is
greater or equal to 10-6. Display the required number of terms (N) which it used in
this series in a text box and display the result of series (cos(h)) in another separate
text box.
arrow_forward
INSTRUCTIONS:
Please write clearly and understandable way.
Write all the corresponding GIVEN with their corresponding symbols and units.
List all the MISSING/REQUIRED, and list all the FORMULA that will be used.
• DRAW/ILLUSTRATE THE DIAGRAM/CIRCUIT OR DRAWINGS that is related to the
problem, IF POSSIBLE, which is HIGHLY REQUIRED.
The CONVERSION calculations with their corresponding symbols and units is
required.
The problem's SOLUTION must be solved in a step-by-step, no shortcut, again, with
their corresponding symbols and units.
• BOXED the Final Answer.
PROBLEM:
The compressor of a large gas turbine power plant receives 12kg/s of surrounding air at
95kPa and 20°C. At the compressor outlet, air exits at 1.52MPa, 430°C, Determine the
flow energy requirements in MW.
a) 1.412
b) 2.42
c) 1.01
d) 1.614
arrow_forward
Can you help me with this problem?
P1 is where the blue dot is
arrow_forward
Please make this on MATLAB, make the graph shown on the picture, copy the orange and blue circles and the line please make sure that they are on the exact same spots. Make the exact copy of the graph please. Nothing different, just make the same graph and put the orange and blue circles on the exact spots and make sure the lines are the same and make sure the title of the graph is their as well. They rest of the pictures that has numbers are the data that is believed to be the orange and blue dots . Take your time please. I need help with this.
arrow_forward
Question number 1
arrow_forward
write one command for each case: take data name is 'x' and file name is 'database'
Import data form Excel sheet to MATLAB.
1. Export data form MATLAB to Excel sheet.
2.
Save data as text file.
3. Load data form text file.
4. Open and close file.
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_forwardChoose the correct answer, please, I need the solution as soon as possiblearrow_forwardEvery 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
- 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_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_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_forward
- Please draw the right side view. Don't copy from anywhere else. Please write the dimensions as well.arrow_forwardThe first photo is the question, where the 2nd shows some problem solving strategiesarrow_forwardThere 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
- Please draw 5 and 6arrow_forwardQ1: write a program to enter any text and compute its length. Q2: Design a form with a text box. Use select statement so that when user enters g, b, r and y then form colored to green, blue, red, and yellow respectively. Q3: Write a program to print multipliers of 5 (from 5 to 50)arrow_forwardDraw it on the graph provided please!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