5_2 Analysis and Summary Bryan Ehrhart
docx
keyboard_arrow_up
School
Southern New Hampshire University *
*We aren’t endorsed by this school
Course
220
Subject
Mechanical Engineering
Date
Dec 6, 2023
Type
docx
Pages
3
Uploaded by BryanEhrhart
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.
1.
Analyze the data
you’ve been provided with to
identify themes
:
a.
Which parts are being replaced most? Fuel tank (95 times)
b.
Is there a region of the country that experiences more part failures and replacements
than others?
i.
Identify region: Midwest suffers more part failures
ii.
How might the fleet maintenance team use the information to update its
maintenance schedule?
1.
They have the option to employ additional personnel in that region and
establish additional businesses to ensure timely completion of all
repairs.
c.
Which parts are being replaced most due to corrosion or rust? The wheel arch
undergoes the highest frequency of replacement, primarily 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? The most frequent replacements occur with
tires repair.
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.
The Midwest region requires a substantial number of mechanics to stay ahead of car
repairs. The most vulnerable components, susceptible to rust or corrosion, include the
wheel arch, fenders, rockers, and brakes. Given mechanical failures or accidents, tires
often bear the brunt of damage, underscoring the importance of maintaining tire
condition and driving with caution.
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.
I employed SELECT queries, inserting them following each screenshot.
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.
I utilized the 'IN' function to retrieve multiple items simultaneously without
resorting to the use of 'OR.' Additionally, I employed the GROUP BY clause to
display only distinct data and utilized COUNT to ascertain the frequency of
occurrences for items that were malfunctioning.
4.
Explain how the functions in the analysis tool
allowed you to organize the data and retrieve
records quickly.
a.
Identifying the regions with the highest repair frequency was straightforward due to the
well-organized data. All the information I required about the parts and repairs was
readily available.
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 Documents
Related Questions
Astronomy Question:
Read the questions slowly and answer with precise and long details about each of the questions. Answer correctly and follow my guidelines for a long and wonderful review after results. Your target/main observable galaxy is the whirlpool galaxy. Target: Whirlpool Galaxy Object Type: Galaxy Distance: 37 million light-years Constellation: Canes Venatici. DO NOT COPY AND PASTE OTHER WORK OR THINGS FROM THE INTERNET, use your own words.Provide refernces if used
In 500 words, please explain the relevance of this object to the physics course material in university andits importance to astronomy. (Some question you may seek to answer are: What beyond the objectitself is learned by studying this class of objects? What sorts of telescopes and observations would beneeded for more detailed, broader reaching studies of this source and objects of its nature?)
arrow_forward
The first photo is the question, where the 2nd shows some problem solving strategies
arrow_forward
Please make the charts for the questions. Please refer to Successful Project Management (7th Edition). Attached is the example
Thank you.
arrow_forward
Directions: modify the standard SolidWorks ANSI B Landscape layout for your own engineering
consulting company. Include a logo, change the legal notice, and make other changes as you see fit.
Be creative! Save this as a SolidWorks drawing layout template and use in subsequent submissions.
Usual DRAWN BY.
Deliverable: screenshot of your personalized layout/template without any drawings on it.
arrow_forward
A Team of Engineers asked for an internal combustion engine to use it in a designed car. Your role is to describe the operation sequence of different types of available engines, explain their mechanical efficiency, and deliver a detailed technical report to show your approach in solving and discussing the following tasks and issues.
You must follow the following steps to help the team:
STEP 1
Describe the operational sequence of four-stroke spark ignition and four-stroke compression ignition engines with the aid of sketches by constructing simple sketch representing the operation and plotting the P-V diagrams for each process during the cycle to show the following:
The input and output heat and net output work
The expansion and compression strokes
The air-fuel mixture intake and exhaust gasses
The spark plug when it is in the active mode
The complete cycle of ideal Otto and Diesel cycles that shows the input and output heat and net output work.
STEP 2
Explain the mechanical…
arrow_forward
I need answers to questions 1, 2, and 3 pertaining to the print provided.
Note: A tutor keeps putting 1 question into 3 parts and wasted so many of my questions. Never had a issue before until now, please allow a different tutor to answer because I was told I am allowed 3 of these questions.
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
LESSON: AUTODESK AUTOCAD
Choose from the choices:
arrow_forward
Direction: Graph the heating curve of ethanol using the information given. Check off each item as you add additional information to your graph so that none is missed.
Background information of Ethanol:
Boiling Point = 78 0C
Melting Point = -114 0C
Starting Temperature = -120 0C
After two minutes, frozen cold ethanol starts to melt. It takes two minutes to melt completely.
After eight more minutes, it begins to boil. It boils for six minutes.
Heat is added for two more minutes until ethanol reaches 80 0C.
Label “melting” where this takes place.
Label “vaporization” where this takes place.
Label “phase change” where a phase change occurs.
Indicate where ethanol is only a SOLID, only a LIQUID, and only a GAS.
Of the three phases, label which phase has: weakest IMF, strongest IMF, and medium IMF.
arrow_forward
I need answers to questions 13, 14, and 15 pertaining to the print provided.
Note: A tutor keeps putting 1 question into 3 parts and wasted so many of my questions. Never had a issue before until now, please allow a different tutor to answer because I was told I am allowed 3 of these questions.
arrow_forward
I need parts 8, 9, and 10 answered. Number 1 is an example of how it should be answered.
NOTE: Read the instructions, no where does it say any drawing is required. It is really frustrating when I wait all this time for an answer to a question and some tutor does even read the instructions and just declines it...its ridicilous.
arrow_forward
Case Study – The New Engineer
Jeff was just hired by GSI, Inc. to be their Environmental and Safety Coordinator. This is Jeff's first position after completing his engineering degree. He had taken a course in safety engineering as part of his studies and felt confident that he could handle the job.
Management at GSI, Inc. has assured him that they are committed to maintaining a safe workplace. They have never had an individual dedicated to this task full-time. They will implement his recommendations if he can justify them.
As Jeff begins to get familiar with the operations, he spends considerable time on the production floor. He notices workers clean their tools before break with a liquid from an unmarked 55-gallon drum. They also use this liquid to clean residue from their skin. They use paper towels to dry their tools and hands, throw these towels in the trash, and head to the break room for a snack and/or smoke.
In talking with the workers, Jeff learns of some of…
arrow_forward
Case Study – The New Engineer
Jeff was just hired by GSI, Inc. to be their Environmental and Safety Coordinator. This is Jeff's first position after completing his engineering degree. He had taken a course in safety engineering as part of his studies and felt confident that he could handle the job.
Management at GSI, Inc. has assured him that they are committed to maintaining a safe workplace. They have never had an individual dedicated to this task full-time. They will implement his recommendations if he can justify them.
As Jeff begins to get familiar with the operations, he spends considerable time on the production floor. He notices workers clean their tools before break with a liquid from an unmarked 55-gallon drum. They also use this liquid to clean residue from their skin. They use paper towels to dry their tools and hands, throw these towels in the trash, and head to the break room for a snack and/or smoke.
In talking with the workers, Jeff learns of some of…
arrow_forward
I need answers to problems 7, 8, and 9.
NOTE: Please stop wasting my time and yours by rejecting my question because it DOES NOT REQUIRE YOU TO DRAW anything at all. They are simple questions pertaining to the print provided. READ THE INSTRUCTIONS of the assignment before you just reject it for a FALSE reason or leave it for someone to answer that actually wants to do their job. Thanks.
arrow_forward
Please solve do not rejcet my questions please give me answers
arrow_forward
Alert for not submit AI generated answer. I need unique and correct answer. Don't try to copy from anywhere. Do not give answer in image formet and hand writing
arrow_forward
Hello. I just want to make sure the answers I chosen on the image attached are correct because I am unsure.
arrow_forward
I need answers for problems 13, 14, and 15 pertaining to the print provided.
NOTE: If you refuse to answers all 3 parts and insist on wasting my question by breaking down 1 simple question into 3 parts, then just leave it for someone else to answer. Thank you.
arrow_forward
Please give me the answers for this i been looking at this for a hour and my head hurts
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
- Astronomy Question: Read the questions slowly and answer with precise and long details about each of the questions. Answer correctly and follow my guidelines for a long and wonderful review after results. Your target/main observable galaxy is the whirlpool galaxy. Target: Whirlpool Galaxy Object Type: Galaxy Distance: 37 million light-years Constellation: Canes Venatici. DO NOT COPY AND PASTE OTHER WORK OR THINGS FROM THE INTERNET, use your own words.Provide refernces if used In 500 words, please explain the relevance of this object to the physics course material in university andits importance to astronomy. (Some question you may seek to answer are: What beyond the objectitself is learned by studying this class of objects? What sorts of telescopes and observations would beneeded for more detailed, broader reaching studies of this source and objects of its nature?)arrow_forwardThe first photo is the question, where the 2nd shows some problem solving strategiesarrow_forwardPlease make the charts for the questions. Please refer to Successful Project Management (7th Edition). Attached is the example Thank you.arrow_forward
- Directions: modify the standard SolidWorks ANSI B Landscape layout for your own engineering consulting company. Include a logo, change the legal notice, and make other changes as you see fit. Be creative! Save this as a SolidWorks drawing layout template and use in subsequent submissions. Usual DRAWN BY. Deliverable: screenshot of your personalized layout/template without any drawings on it.arrow_forwardA Team of Engineers asked for an internal combustion engine to use it in a designed car. Your role is to describe the operation sequence of different types of available engines, explain their mechanical efficiency, and deliver a detailed technical report to show your approach in solving and discussing the following tasks and issues. You must follow the following steps to help the team: STEP 1 Describe the operational sequence of four-stroke spark ignition and four-stroke compression ignition engines with the aid of sketches by constructing simple sketch representing the operation and plotting the P-V diagrams for each process during the cycle to show the following: The input and output heat and net output work The expansion and compression strokes The air-fuel mixture intake and exhaust gasses The spark plug when it is in the active mode The complete cycle of ideal Otto and Diesel cycles that shows the input and output heat and net output work. STEP 2 Explain the mechanical…arrow_forwardI need answers to questions 1, 2, and 3 pertaining to the print provided. Note: A tutor keeps putting 1 question into 3 parts and wasted so many of my questions. Never had a issue before until now, please allow a different tutor to answer because I was told I am allowed 3 of these questions.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_forwardLESSON: AUTODESK AUTOCAD Choose from the choices:arrow_forwardDirection: Graph the heating curve of ethanol using the information given. Check off each item as you add additional information to your graph so that none is missed. Background information of Ethanol: Boiling Point = 78 0C Melting Point = -114 0C Starting Temperature = -120 0C After two minutes, frozen cold ethanol starts to melt. It takes two minutes to melt completely. After eight more minutes, it begins to boil. It boils for six minutes. Heat is added for two more minutes until ethanol reaches 80 0C. Label “melting” where this takes place. Label “vaporization” where this takes place. Label “phase change” where a phase change occurs. Indicate where ethanol is only a SOLID, only a LIQUID, and only a GAS. Of the three phases, label which phase has: weakest IMF, strongest IMF, and medium IMF.arrow_forward
- I need answers to questions 13, 14, and 15 pertaining to the print provided. Note: A tutor keeps putting 1 question into 3 parts and wasted so many of my questions. Never had a issue before until now, please allow a different tutor to answer because I was told I am allowed 3 of these questions.arrow_forwardI need parts 8, 9, and 10 answered. Number 1 is an example of how it should be answered. NOTE: Read the instructions, no where does it say any drawing is required. It is really frustrating when I wait all this time for an answer to a question and some tutor does even read the instructions and just declines it...its ridicilous.arrow_forwardCase Study – The New Engineer Jeff was just hired by GSI, Inc. to be their Environmental and Safety Coordinator. This is Jeff's first position after completing his engineering degree. He had taken a course in safety engineering as part of his studies and felt confident that he could handle the job. Management at GSI, Inc. has assured him that they are committed to maintaining a safe workplace. They have never had an individual dedicated to this task full-time. They will implement his recommendations if he can justify them. As Jeff begins to get familiar with the operations, he spends considerable time on the production floor. He notices workers clean their tools before break with a liquid from an unmarked 55-gallon drum. They also use this liquid to clean residue from their skin. They use paper towels to dry their tools and hands, throw these towels in the trash, and head to the break room for a snack and/or smoke. In talking with the workers, Jeff learns of some of…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