Review this example before starting the exercise Relative to your academic major, identify one, robust, open-source database for analysis and interpretation. The database must be in Excel for

 

Review this example before starting the exercise.

1. Relative to your academic major, identify one, robust, open-source database for analysis and interpretation. The database must be in Excel format or importable to Excel.  (You may use the database provided above if needed. However, you should pose different questions if you use it.)

 

2. In the top rows above the data as shown in the example, postulate at least one appropriate question to be asked and answered from the database. See the example spreadsheet above.

3. Provide the answers to your questions as shown in the example spreadsheet above, as well as an interpretation.

Cain_Data_GA_All

Collepals.com Plagiarism Free Papers

Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.

Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS

Why Hire Collepals.com writers to do your paper?

Quality- We are experienced and have access to ample research materials.

We write plagiarism Free Content

Confidential- We never share or sell your personal information to third parties.

Support-Chat with us today! We are always waiting to answer all your questions.

Related Posts

All Rights Reserved Terms and Conditions
College pals.com Privacy Policy 2010-2018

Source: https://www.ntsb.gov/investigations/data/Documents/datafiles/AnnualReview_2015_Public_4_GA_20171106.xlsx
Results Interpretation
Question 1. How many GA acidents occurred in 2015? 1218 =COUNT(B13:B1300)
Question 2. How many fatal GA accidents occurred in 2015? 231 =COUNTIF(K11:K1300,"FATL") 19% of GA accidents in 2015 involved fatalities.
Question 3. How many GA accidents occurred in Florida, Georgia, and Alabama in 2015? 149 =COUNTIF(G4:G1300,"FL")+COUNTIF(G4:G1300,"GA")+COUNTIF(G4:G1300,"AL") GA accidents in Florida, Georgia, and Alabama were 65% of the enitre country's fatal GA accidents.
Question 4. How many GA accidents occurred in the takeoff and landing phases of flight in 2015? 509 =COUNTIF(T5:T1301,"TOF")+COUNTIF(T5:T1301,"LDG") TOF and LDG accidents accounted for 42% of all 2015 GA accidents.
General Aviation Accident Aircraft, 2015
ntsb_no aircraft_key ev_date latitude longitude ev_city ev_state ev_country inj_tot_f inj_tot_s ev_highest_injury damage far_part oper_pax_cargo oper_dom_int oper_sched acft_category type_fly CICTTEvent CICTTPhase IllegalAct Synopsis
WPR15CA073A9:A1222 1 1/1/15 322624N 1141648W Yuma AZ USA MINR SUBS 091 AIR PERS LOCI TOF No Synopsis
WPR15CA074 1 1/3/15 351414N 1203827W San Luis Obispo CA USA NONE SUBS 091 AIR PERS ARC LDG No Synopsis
ERA15FA088 1 1/2/15 370201N 0881008W Kuttawa KY USA 4 1 FATL SUBS 091 AIR PERS FUEL ENR No Synopsis
ERA15CA089 1 1/2/15 181235N 0661738W Barranquitas PR USA MINR SUBS 091 HELI PERS ARC LDG No Synopsis
WPR15CA076 1 1/4/15 383442N 1222608W Angwin CA USA NONE SUBS 091 AIR PERS USOS LDG No Synopsis
WPR15LA077 1 1/3/15 364315N 1194903W Fresno CA USA NONE SUBS 091 AIR PERS SCFPP ENR No Synopsis
WPR15CA078 1 1/4/15 344836N 1114760W Sedona AZ USA NONE SUBS 091 AIR PERS LOCG LDG No Synopsis
CEN15CA097 1 1/5/15 462113N 0872347W Marquette MI USA NONE SUBS 091 AIR PERS LOCG TOF No Synopsis
CEN15LA098 1 1/4/15 400647N 0851433W Parker City IN USA 1 SERS SUBS 091 AIR PERS LOCI MNV No Synopsis
ERA15LA092 1 1/6/15 354312N 0810824W Long View NC USA 1 SERS SUBS 091 AIR PERS SCFPP ICL No Synopsis
ERA15CA093 1 1/1/15 294339N 0850133W Apalachicola FL USA NONE SUBS 091 AIR PERS GCOL TXI No Synopsis
CEN15LA099 1 1/6/15 304703N 0983560W Llano TX USA NONE SUBS 091 AIR PERS LOCG TOF No Synopsis
ERA15LA094 1 1/6/15 364649N 0762803W Norfolk VA USA NONE SUBS 091 AIR INST SCFPP ICL No Synopsis
ERA15CA095 1 1/7/15 440927N 0702853W Lewiston ME USA NONE SUBS 091 AIR PERS LOCG STD No Synopsis
WPR15FA081 1 1/9/15 341221N 1182914W Van Nuys CA USA 1 FATL SUBS 091 AIR PERS FUEL ICL No Synopsis
ERA15FA096 1 1/10/15 182724N 0660554W Catano PR USA 1 FATL DEST 091 HELI INST LOCI APR No Synopsis
WPR15LA083 1 1/10/15 382237N 1204738W Jackson CA USA NONE SUBS 091 AIR PERS LOCG LDG No Synopsis
WPR15FA082 1 1/9/15 404635N 1122933W Tooele UT USA 1 FATL SUBS 091 AIR PERS UIMC ENR No Synopsis
CEN15FA101 1 1/11/15 395929N 1043536W Brighton CO USA 1 FATL DEST 091 AIR PERS SEC MNV Yes Synopsis
WPR15LA084 1 1/11/15 441710N 1205411W Prineville OR USA 1 FATL DEST 091 AIR PERS LOCI ICL No Synopsis
ERA15LA097 1 1/10/15 341202N 0864817W Cullman AL USA MINR SUBS 091 AIR INST LOCG STD No Synopsis
ERA15FA099 1 1/13/15 290223N 0805343W New Smyrna Beach FL USA 1 FATL SUBS 091 AIR PERS LOCI APR No Synopsis
ERA15CA100 1 1/14/15 373343N 0823359W Pikeville KY USA MINR SUBS 091 AIR PERS LOCI LDG No Synopsis
CEN15LA103 1 1/10/15 403838N 0855412W Peru IN USA 1 SERS NONE 091 BALL PERS ARC LDG No Synopsis
ERA15CA101 1 1/15/15 422738N 0713104W Stow MA USA NONE SUBS 091 AIR INST LOCI APR No Synopsis
ERA15FA102 1 1/16/15 272723N 0812033W Sebring FL USA 2 FATL SUBS 091 AIR ASHO LOCI MNV No Synopsis
WPR15LA086 1 1/16/15 210817N 1564901W Ualapue HI USA 1 SERS SUBS 091 AIR INST SCFPP ENR No Synopsis
ERA15FA103 1 1/16/15 323252N 0834937W Fort Valley GA USA 1 1 FATL SUBS 091 AIR INST LOCI APR No Synopsis
CEN15LA104 1 1/16/15 301159N 0952835W The Woodlands TX USA 1 FATL SUBS 091 HELI PERS SCFNP ENR No Synopsis
WPR15LA085 1 1/16/15 350547N 1200349W San Luis Obispo CA USA NONE SUBS 091 AIR PERS SCFPP ENR No Synopsis
CEN15LA107 1 1/14/15 374448N 0995803W Dodge City KS USA 1 SERS SUBS