DAD 220 Analysis and Summary lab 5
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 DoctorMaskDinosaur13
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?
i.
Fuel tank is being replaced the most with 95 replacements follow by 74 repairs for tires, 66 replacements for tires. b.
Is there a region of the country that experiences more part failures and replacements than others?
i.
Identify region:
1.
Midwest with 260 repairs
ii.
How might the fleet maintenance team use the information to update its maintenance schedule? 1.
This information is helpful because it provides adequate numbers of staff and supplies needed in each region to accommodate the projected number of repairs. c.
Which parts are being replaced most due to corrosion or rust?
Wheel Arches are being replaced then fenders and rocker panels.
d.
Which parts are being replaced most because of mechanical failure or accident, like a flat tire or rock through the windshield?
Tire repairs are the most parts being repaired with 74 listed. 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.
Looking at the data provided I can see that the mid-western region has 260 listed reports, following close behind is the north-east with reports. The most common repair is the fuel tank sitting at 95 repairs, tire repair is at 74. For corrosion or rust I can see that the most common repair was either the wheel arch, fender, and rocker panel. 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 repair AS PART_REPAIR, COUNT(*) AS NUMBER_OF_REPAIRS FROM Part Maintenance
GROUP BY PART_REPAIR ORDER BY NUMBER_OF_REPAIRS DESC
Most repairs by region:
SELECT ‘SOUTHWEST’ AS REGION COUNT(*) AS NUMBER_OF_REPAIRS FROM Parts Maintenance WHERE UPPER(state) IN (‘AZ’, ‘NM’, ‘TX’, ‘OK’) 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 ‘SOUTHEAST’ AS REGION, COUNT(*) AS NUMBER_OF_REPAIRS
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.
The information from using these queries helps us retrieve how many repairs in each region as well as what type of repair it is, the make, model, year and body type of the vehicle that is having the repairs then they can dive further into their
numbers with the pricing lists to see how much revenue that the parts maintenance is bringing in. 4.
Explain how the functions in the analysis tool allowed you to organize the data and retrieve records quickly.
a.
The function allowed me to organize the data fairly quickly and easily.
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
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
Please make the charts for the questions. Please refer to Successful Project Management (7th Edition). Attached is the example
Thank you.
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
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
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
Don't use chatgpt will upvote
arrow_forward
Please give me the answers for this i been looking at this for a hour and my head hurts
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
I need problems 6 and 7 solved.
I got it solved on 2 different occasions and it is not worded correctly.
NOTE: Problem 1 is an example of how it should be answered. Below are 2 seperate links to same question asked and once again it was not answered correctly. 1. https://www.bartleby.com/questions-and-answers/it-vivch-print-reading-for-industry-228-class-date-name-review-activity-112-for-each-local-note-or-c/cadc3f7b-2c2f-4471-842b-5a84bf505857
2. https://www.bartleby.com/questions-and-answers/it-vivch-print-reading-for-industry-228-class-date-name-review-activity-112-for-each-local-note-or-c/bd5390f0-3eb6-41ff-81e2-8675809dfab1
arrow_forward
I asked for problems 6 and 7 to be answered, but I did not get a properly structured answered as the example shows on problem number 1. Here is the link to the questions I already had answered, could you please rewrite the answer so its properly answered as the example shows (Problem 1)?
https://www.bartleby.com/questions-and-answers/it-vivch-print-reading-for-industry-228-class-date-name-review-activity-112-for-each-local-note-or-c/cadc3f7b-2c2f-4471-842b-5a84bf505857
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
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
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
Please make the exact graph that you see in the picture, along with the graph are numbers that are data. Please make the exact graph do not make anything thing different, the blue and orange circles should be there and the lines should be the same including the titles. Please make sure everything is exactly the same. Use MATLAB, and send the code and please make sure no error signs comes up. Take your time please I need help.
arrow_forward
I submitted the below question and received the answer i copied into this question as well. Im unsure if it is correct, so looking for a checkover. i am stuck on the part tan-1 (0.05) = 0.04996 radians. Just unsure where the value for the radians came from. Just need to know how they got that answer and how it is correct before moving on to the next part. If any of the below information is wrong, please feel free to give me a new answer or an entire new explanation.
An Inclining experiment done on a ship thats 6500 t, a mass of 30t was moved 6.0 m transvesly causing a 30 cm deflection in a 6m pendulum, calculate the transverse meta centre height.
Here is the step-by-step explanation:
Given:
Displacement of the ship (W) = 6500 tonnes = 6500×1000=6,500,000kg
Mass moved transversely (w) = 30 tonnes=30×1000=30,000kg
The transverse shift of mass (d) = 6.0 meters
Pendulum length (L) = 6.0 meters
Pendulum deflection (x) = 30 cm = 0.30 meters
Step 1: Formula for Metacentric Height…
arrow_forward
please help solve A-F. thank you
You are an engineer working on a project and your prototype has failed prematurely. You question whether or not a key component of the prototype was manufactured with the correct material. There are two way to check for the material properties. The first way is to have a material certification done to confirm the exact material composition. This will take some time. The second method to confirm the material properties is to make an ASTM test sample and test for the material properties. This tensile test was completed on a test sample with an initial diameter of .501” and an initial length of 2”. The Load-Deflection data for this tensile test is below. Use this data to answer the first set of questions on the Final Exam in eLearning. A. Determine the Ultimate Tensile Strength B. Determine the 0.2% Offset Yield Strength C. Determine the value of the Proportional Limit D. Determine the Modulus of Elasticity E. Determine the Strain at Yield F. Calculate %…
arrow_forward
LESSON: AUTODESK AUTOCAD
Choose from the choices:
arrow_forward
This is Mechanical Engineering. Please answer with clear work and answers. Thank you
arrow_forward
I need the answers to this part, I have submitted this question twice on this site and both times received way different answers...as I am unsure which tutor to listen to, I am uploading this question for the third time and I am asking a very highly knowledgable tutor to help me solve this. If you are uncertain, please leave it for another tutor.
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_forwardYou 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
- Please make the charts for the questions. Please refer to Successful Project Management (7th Edition). Attached is the example Thank you.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_forwardI 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
- 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_forwardDon't use chatgpt will upvotearrow_forwardPlease give me the answers for this i been looking at this for a hour and my head hurtsarrow_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_forwardI need problems 6 and 7 solved. I got it solved on 2 different occasions and it is not worded correctly. NOTE: Problem 1 is an example of how it should be answered. Below are 2 seperate links to same question asked and once again it was not answered correctly. 1. https://www.bartleby.com/questions-and-answers/it-vivch-print-reading-for-industry-228-class-date-name-review-activity-112-for-each-local-note-or-c/cadc3f7b-2c2f-4471-842b-5a84bf505857 2. https://www.bartleby.com/questions-and-answers/it-vivch-print-reading-for-industry-228-class-date-name-review-activity-112-for-each-local-note-or-c/bd5390f0-3eb6-41ff-81e2-8675809dfab1arrow_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