A2 S435

.docx

School

Indiana University, South Bend *

*We aren’t endorsed by this school

Course

S435

Subject

Industrial Engineering

Date

Oct 30, 2023

Type

docx

Pages

1

Uploaded by EarlFreedomMonkey29

Thomas Garcia S435 Homework– A2 The questions I would like to answer in the Aviation Crash database are: Is there a specific aircraft manufacturer that has been more prone to making aircrafts that eventually crash? Is the overall trend in aviation crashes increasing or decreasing as time goes on? My first step in the data preprocessing of the aviation crash database was consolidating the data. To do this I exported all of the data tables from the 1920 to 2023 crashes into an excel file worksheet. This was very time consuming and for some reason all of the tables transferred over into excel as their own separate queries so I had to manually convert each query back to range in order to integrate. Next came the data cleaning which included removing the unnecessary aircraft type number and registration. I did this by creating a new column named aircraft manufacturer and used excels built in flash fill function to auto fill in the aircraft manufacturer type which excluded the unnecessary information. I then deleted the original “Aircraft type / Registration” column and replaced it with the newly created “Aircraft Manufacturer”. A few of the airplane crashes did not display the type of the aircraft manufacturer that crashed so I removed these from the table as they are obsolete. I also reformatted the dates of all the crashes to ensure they are all matching.
Discover more documents: Sign up today!
Unlock a world of knowledge! Explore tailored content for a richer learning experience. Here's what you'll get:
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help

Browse Popular Homework Q&A

Q: D
Q: The treasurer of a large corporation wants to invest $22 million in excess short-term cash in a…
Q: log₁ 6₂ = -4/09, 16 CASEDirect 800.423.1411 ww ●
Q: 3. (a) Describe what is meant by the proper motion of a star? (b) What is the distance to a star…
Q: Are there adverse health effects experienced overtime because of higher levels of 2,3-BPG for people…
Q: Compute the quantity, w, using w = w• w - 6 1 W = w•W (Type integers or simplified fractions.) 3.
Q: eq req req 2req 2req Write the expression for the equilibrium constant K, for the following…
Q: Over the years, the Red Cross has been guided in its use of donations by honoring donor intent. This…
Q: Exercise 5. Let X be a r.v. representing the outcome of rolling a fair, 6-sided die: f(1) = ƒ(2) = -…
Q: Consider the following reaction where Ke = 1.29x10-2 at 600 K: COCI₂ (9)CO (g) + Cl₂ (g) A reaction…
Q: to access important values if needed for this question. Consider the following system at equilibrium…
Q: Consider the beam shown in (Figure 1). Suppose that w=2.4 k/ft. Figure L. -9 ft 1 of 1 W ▼ Part A…
Q: Use the root test to determine if the following series converges or diverges. 00 18 Σ (2 + (1/n))n n…
Q: Icarus Airlines is proposing to go public, and you have been given the task of estimating the value…
Q: I have a biology, question: In aerobic respiration, energy is harvested from glucose molecules in a…
Q: 3x - 2y + 4z 8x + y - 9z passes through the point (-7, -2, 5). Solve your equation for z. Suppose…
Q: On January 1, 20X1, Popular Creek Corporation organized SunTime Company as a subsidiary in…
Q: 7. For the above Boost converter, what is the max voltage stress across S1 and S2? A. 10V, 10V Cazov…
Q: Use the formulas for resistance and blood pressure to answer the following: a. If the radius of a…
Q: onsider the following data. 0, 120, 124, 125, 150, 165, 170, 175, 17 '5, 176, 182, 185, 190, 261…
Q: May 1. Sold merchandise on account to Taiwan Palace Co., $36,730. The cost of the merchandise sold…
Q: Prepare Journal Entries in a Revenue Journal Shannon Consulting Company had the following…
Q: The following data is available for Coronado Service Corporation at December 31, 2020: Common stock,…
Q: If the set W is a vector space, find a set S of vectors that spans it. Otherwise, state that W is…
Q: Discuss Managing modern Internationalized Organizations in line with Sustainability Principles