Using Research Questions

RQ1: What is the relationship between flight crew age and the incidence of aviation events, and how does this relationship vary between pilots and co-pilots?

RQ2: How do flight hours as pilot in command (PIC) and total flight hours correlate with the severity of injuries incurred during aviation events, considering different light and weather conditions?

RQ3: What patterns can be identified in the number of reported aviation events from 2013 to 2022 in relation to environmental factors such as light conditions (day or night) and weather conditions (IFR or VFR)?

Provide step by step and show solutions using JMP. More specifically, you will do the following: 1. Conduct descriptive analyses of all 8 variables and summarize these results in APA formatted tables. 2. Conduct the below analysis a. Conduct an independent samples t test (there are multiple options here, but you only need to conduct one t test); you will select the variables for this analysis. b. Conduct a one-way between subjects ANOVA; you will select the variables for this analysis (Hint: the independent variable must have at least 3 levels). c. Conduct a bivariate Pearson correlation; you will select the variables for this analysis

Dataset:

Number of Events	Flight Crew Age	Flight Crew Category	Total Hours as PIC	Total Hours Overall	Light Conditions	Weather Conditions	Injury Type
17	29	Co-pilot	2698	2856	Night	IFR	FATAL
21	47	Pilot	1205	3263	Night	VFR	FATAL
18	36	Co-pilot	1670	3598	Day	VFR	FATAL
25	48	Pilot	3277	4234	Night	IFR	FATAL
30	44	Co-pilot	940	6564	Night	VFR	FATAL
30	44	Pilot	8612	13043	Day	VFR	FATAL
20	41	Co-pilot	975	13518	Day	VFR	FATAL
24	53	Pilot	14149	17750	Day	VFR	FATAL
23	54	Pilot	9000	23650	Day	VFR	FATAL
30	44	Co-pilot	171	1449	Day	VFR	MINOR
13	27	Pilot	840	1700	Day	VFR	MINOR
16	26	Co-pilot	595	2105	Night	IFR	MINOR
17	29	Pilot	2240	2450	Day	VFR	MINOR
13	27	Pilot	2400	3200	Night	VFR	MINOR
12	38	Pilot	1900	4050	Night	VFR	MINOR
30	44	Co-pilot	4500	4818	Night	VFR	MINOR
22	35	Pilot	4524	4837	Night	VFR	MINOR
26	37	Co-pilot	2586	5300	Day	VFR	MINOR
30	44	Pilot	3967	5472	Night	IFR	MINOR
21	30	Pilot	3074	5616	Night	VFR	MINOR
26	37	Pilot	4246	6045	Night	VFR	MINOR
26	37	Co-pilot	2900	6100	Day	VFR	MINOR
21	47	Pilot	2208	7145	Day	VFR	MINOR
20	41	Co-pilot	1880	7700	Night	VFR	MINOR
22	50	Pilot	2350	7850	Day	VFR	MINOR
25	42	Co-pilot	6655	8895	Day	VFR	MINOR
25	42	Pilot	6000	11000	Day	IFR	MINOR
25	42	Pilot	6678	11725	Day	VFR	MINOR
23	54	Pilot	5538	12518	Night	IFR	MINOR
28	49	Pilot	7458	14619	Day	VFR	MINOR
18	56	Pilot	14000	20000	Day	IFR	MINOR
26	52	Pilot	15000	22000	Day	VFR	MINOR
21	30	Co-pilot	161	325	Day	VFR	NONE
12	33	Co-pilot	241	573	Day	VFR	NONE
3	23	Co-pilot	350	800	Day	VFR	NONE
12	32	Co-pilot	290	847	Night	VFR	NONE
13	27	Co-pilot	430	900	Day	VFR	NONE
10	25	Co-pilot	222	917	Day	VFR	NONE
23	34	Co-pilot	180	950	Day	VFR	NONE
10	28	Co-pilot	580	1005	Day	VFR	NONE
16	26	Co-pilot	370	1100	Night	IFR	NONE
16	26	Co-pilot	263	1157	Day	VFR	NONE
10	25	Co-pilot	529	1532	Day	VFR	NONE
16	26	Co-pilot	715	1729	Day	VFR	NONE
12	32	Pilot	987	1846	Night	VFR	NONE
20	31	Co-pilot	1505	1860	Night	IFR	NONE
16	26	Co-pilot	356	1919	Night	VFR	NONE
12	33	Pilot	1485	2025	Day	VFR	NONE
17	29	Co-pilot	220	2166	Night	IFR	NONE
17	29	Co-pilot	450	2200	Day	VFR	NONE
16	26	Co-pilot	1270	2247	Day	VFR	NONE
20	41	Pilot	490	2280	Night	VFR	NONE
16	26	Co-pilot	1150	2550	Day	IFR	NONE
13	27	Co-pilot	2373	2590	Night	IFR	NONE
21	30	Co-pilot	450	2600	Day	VFR	NONE
16	26	Pilot	1250	2680	Day	VFR	NONE
18	36	Co-pilot	1300	2800	Day	VFR	NONE
13	27	Pilot	912	2989	Night	IFR	NONE
33	40	Pilot	2607	3009	Night	VFR	NONE
17	29	Pilot	1000	3200	Night	VFR	NONE
20	31	Pilot	2308	3427	Night	VFR	NONE
12	33	Co-pilot	1936	3500	Night	VFR	NONE
13	27	Pilot	1600	3500	Day	VFR	NONE
22	35	Pilot	1500	3543	Day	VFR	NONE
26	52	Pilot	2529	3545	Night	VFR	NONE
20	31	Pilot	1785	3584	Day	VFR	NONE
23	34	Co-pilot	1600	3700	Day	IFR	NONE
16	26	Pilot	3260	3700	Night	VFR	NONE
20	31	Pilot	2328	3765	Day	IFR	NONE
27	43	Pilot	1574	3778	Day	VFR	NONE
17	29	Pilot	2566	3993	Day	VFR	NONE
20	31	Co-pilot	1000	4000	Day	VFR	NONE
21	30	Pilot	2700	4000	Day	VFR	NONE
26	37	Co-pilot	1823	4090	Night	VFR	NONE
12	38	Pilot	1970	4134	Day	VFR	NONE
33	40	Co-pilot	1700	4267	Night	IFR	NONE
25	42	Co-pilot	3500	4300	Day	VFR	NONE
17	29	Pilot	1600	4300	Day	VFR	NONE
12	38	Co-pilot	1516	4393	Day	VFR	NONE
17	29	Co-pilot	1635	4500	Night	VFR	NONE
20	31	Pilot	2320	4537	Day	VFR	NONE
22	39	Pilot	2392	4549	Night	IFR	NONE
20	41	Pilot	3360	4603	Day	VFR	NONE
20	31	Pilot	3319	4701	Day	VFR	NONE
10	28	Co-pilot	2903	4794	Day	VFR	NONE
30	45	Pilot	3525	4900	Night	IFR	NONE
12	33	Co-pilot	2827	4987	Day	VFR	NONE
23	34	Pilot	3752	4990	Day	IFR	NONE
33	40	Pilot	1000	5000	Day	VFR	NONE
12	32	Co-pilot	2951	5107	Day	VFR	NONE
12	32	Co-pilot	3437	5370	Night	VFR	NONE
21	47	Pilot	2150	5598	Day	VFR	NONE
23	34	Co-pilot	4500	6084	Day	VFR	NONE
20	31	Pilot	5500	6240	Day	VFR	NONE
22	35	Co-pilot	363	6421	Night	IFR	NONE
25	42	Pilot	4095	6449	Day	VFR	NONE
28	46	Pilot	3664	6515	Day	VFR	NONE
33	40	Co-pilot	2622	6573	Day	VFR	NONE
12	38	Pilot	3437	6666	Day	VFR	NONE
18	36	Co-pilot	4000	6700	Day	VFR	NONE
17	55	Pilot	1572	6842	Night	VFR	NONE
23	34	Pilot	4907	6950	Day	VFR	NONE
22	39	Pilot	4099	6997	Day	VFR	NONE
24	53	Pilot	994	7109	Day	VFR	NONE
22	35	Co-pilot	897	7142	Night	IFR	NONE
28	49	Pilot	1033	7300	Night	VFR	NONE
23	34	Pilot	4500	7500	Day	VFR	NONE
16	59	Co-pilot	2384	7610	Day	VFR	NONE
20	41	Pilot	5195	7772	Day	VFR	NONE
25	42	Co-pilot	0	7800	Night	VFR	NONE
12	33	Pilot	4000	7800	Day	VFR	NONE
22	35	Co-pilot	4400	7900	Day	VFR	NONE
21	47	Co-pilot	2614	7945	Night	VFR	NONE
20	41	Pilot	2000	8000	Night	IFR	NONE
22	35	Co-pilot	4707	8102	Night	VFR	NONE
30	44	Pilot	4100	8104	Night	VFR	NONE
27	43	Pilot	7915	8125	Day	VFR	NONE
28	49	Pilot	5575	8141	Night	VFR	NONE
21	47	Pilot	5000	8400	Night	VFR	NONE
26	37	Pilot	4777	8407	Day	VFR	NONE
20	41	Co-pilot	1490	8468	Night	VFR	NONE
26	37	Co-pilot	1682	8731	Day	VFR	NONE
22	50	Pilot	7000	8800	Night	VFR	NONE
25	42	Co-pilot	2250	9000	Night	VFR	NONE
25	48	Pilot	5000	9000	Night	VFR	NONE
25	42	Pilot	4956	9327	Night	IFR	NONE
22	50	Pilot	3100	9500	Night	IFR	NONE
26	37	Pilot	5475	9500	Day	VFR	NONE
20	51	Pilot	1446	9554	Day	VFR	NONE
20	51	Pilot	2995	9929	Day	VFR	NONE
23	54	Pilot	4000	10000	Day	VFR	NONE
20	51	Pilot	9800	10000	Day	VFR	NONE
17	55	Pilot	6000	10000	Day	VFR	NONE
30	45	Pilot	8000	10015	Night	VFR	NONE
30	44	Co-pilot	4238	10038	Night	IFR	NONE
25	48	Pilot	5135	10066	Night	IFR	NONE
20	51	Pilot	3755	10100	Night	VFR	NONE
28	46	Co-pilot	2300	10200	Day	VFR	NONE
26	52	Pilot	10100	10500	Day	VFR	NONE
30	45	Pilot	5212	10509	Day	VFR	NONE
25	42	Pilot	7041	10669	Night	VFR	NONE
28	49	Pilot	9865	11142	Night	IFR	NONE
25	42	Pilot	9518	11728	Night	VFR	NONE
24	53	Pilot	6836	11783	Night	VFR	NONE
24	53	Pilot	4061	11903	Day	VFR	NONE
27	43	Co-pilot	8500	11997	Day	VFR	NONE
20	51	Pilot	11700	12000	Day	VFR	NONE
16	59	Pilot	9000	12500	Day	VFR	NONE
28	46	Pilot	6941	12845	Night	VFR	NONE
20	51	Pilot	3656	12871	Day	IFR	NONE
26	52	Pilot	6340	12920	Day	VFR	NONE
23	54	Co-pilot	9100	13000	Night	IFR	NONE
24	53	Pilot	8349	13004	Day	VFR	NONE
20	41	Pilot	7323	13026	Day	VFR	NONE
15	57	Pilot	9000	13390	Night	VFR	NONE
26	52	Pilot	6797	13615	Day	VFR	NONE
26	37	Pilot	2121	13644	Day	IFR	NONE
30	45	Pilot	7100	14000	Day	VFR	NONE
28	46	Pilot	11600	14000	Night	IFR	NONE
30	44	Pilot	12580	14200	Day	VFR	NONE
24	53	Pilot	12009	14265	Day	VFR	NONE
25	48	Pilot	7135	14762	Day	VFR	NONE
30	44	Pilot	7500	14900	Day	VFR	NONE
26	37	Pilot	11000	15000	Day	VFR	NONE
30	45	Co-pilot	8000	15000	Day	VFR	NONE
18	56	Pilot	11628	15537	Night	IFR	NONE
24	53	Pilot	5000	16000	Night	VFR	NONE
24	53	Co-pilot	985	16900	Day	VFR	NONE
16	59	Pilot	12000	17000	Day	VFR	NONE
28	46	Pilot	9500	17000	Day	VFR	NONE
28	49	Pilot	1967	18005	Day	VFR	NONE
23	54	Pilot	13422	18553	Night	IFR	NONE
17	55	Pilot	14872	18905	Night	IFR	NONE
28	49	Pilot	21000	23000	Day	VFR	NONE
20	58	Pilot	16339	24769	Day	VFR	NONE
18	56	Pilot	23500	27000	Night	VFR	NONE
26	52	Pilot	20000	27300	Night	VFR	NONE
10	25	Co-pilot	287	1052	Day	VFR	SERIOUS
23	34	Co-pilot	2500	1200	Day	VFR	SERIOUS
21	30	Co-pilot	1100	1700	Day	VFR	SERIOUS
10	28	Pilot	600	1900	Day	VFR	SERIOUS
10	28	Co-pilot	571	2020	Day	VFR	SERIOUS
13	27	Co-pilot	953	2213	Day	VFR	SERIOUS
3	23	Co-pilot	574	2493	Night	VFR	SERIOUS
10	25	Co-pilot	1000	2500	Day	VFR	SERIOUS
22	35	Co-pilot	2188	2540	Day	IFR	SERIOUS
21	30	Co-pilot	800	2650	Day	VFR	SERIOUS
13	27	Co-pilot	507	2700	Night	VFR	SERIOUS
18	36	Pilot	1850	2700	Day	VFR	SERIOUS
10	25	Co-pilot	847	2965	Day	IFR	SERIOUS
22	50	Pilot	1100	3000	Night	VFR	SERIOUS
18	56	Co-pilot	540	3002	Night	VFR	SERIOUS
10	28	Co-pilot	1400	3139	Day	VFR	SERIOUS
28	49	Co-pilot	1710	3260	Day	VFR	SERIOUS
28	46	Pilot	204	3369	Night	VFR	SERIOUS
16	26	Pilot	2049	3749	Night	VFR	SERIOUS
21	30	Pilot	1925	3800	Day	VFR	SERIOUS
20	31	Pilot	2400	3830	Day	VFR	SERIOUS
10	28	Pilot	1900	4000	Day	VFR	SERIOUS
20	41	Co-pilot	1660	4097	Day	IFR	SERIOUS
10	28	Pilot	2026	4290	Night	VFR	SERIOUS
10	28	Pilot	1890	4510	Night	VFR	SERIOUS
30	44	Co-pilot	3000	4600	Day	VFR	SERIOUS
17	29	Pilot	3400	4600	Day	VFR	SERIOUS
12	32	Co-pilot	1300	4600	Night	VFR	SERIOUS
17	29	Pilot	3704	4913	Day	IFR	SERIOUS
21	30	Pilot	1500	5000	Day	VFR	SERIOUS
26	52	Pilot	3000	5000	Night	VFR	SERIOUS
22	35	Co-pilot	1200	5000	Day	VFR	SERIOUS
15	57	Pilot	2501	5004	Night	VFR	SERIOUS
23	34	Co-pilot	2303	5107	Night	VFR	SERIOUS
26	52	Co-pilot	3610	5284	Night	VFR	SERIOUS
21	30	Co-pilot	2000	5500	Day	IFR	SERIOUS
10	28	Pilot	1408	5531	Day	VFR	SERIOUS
25	48	Pilot	3847	5582	Day	IFR	SERIOUS
20	41	Pilot	3845	5641	Night	IFR	SERIOUS
20	41	Pilot	2200	6000	Day	IFR	SERIOUS
20	41	Co-pilot	2500	6000	Day	IFR	SERIOUS
25	42	Pilot	3969	6117	Day	VFR	SERIOUS
12	38	Co-pilot	2500	6500	Day	VFR	SERIOUS
30	45	Pilot	5520	6900	Day	VFR	SERIOUS
27	43	Co-pilot	4000	7000	Night	VFR	SERIOUS
25	42	Pilot	4300	7000	Night	VFR	SERIOUS
28	49	Co-pilot	3139	7064	Day	VFR	SERIOUS
12	33	Co-pilot	4000	7292	Night	IFR	SERIOUS
18	36	Co-pilot	568	7300	Day	VFR	SERIOUS
30	44	Pilot	2477	7658	Night	IFR	SERIOUS
27	43	Pilot	5000	7800	Night	VFR	SERIOUS
33	40	Co-pilot	4000	7800	Day	IFR	SERIOUS
33	40	Co-pilot	3361	7847	Day	VFR	SERIOUS
23	34	Pilot	3401	7896	Day	VFR	SERIOUS
30	45	Pilot	5102	7908	Day	VFR	SERIOUS
18	36	Co-pilot	5000	8000	Day	IFR	SERIOUS
12	38	Pilot	2800	8000	Night	VFR	SERIOUS
16	59	Pilot	2502	8137	Day	IFR	SERIOUS
24	53	Pilot	5863	8210	Day	VFR	SERIOUS
22	35	Co-pilot	2637	8360	Day	VFR	SERIOUS
30	44	Co-pilot	3000	9000	Night	VFR	SERIOUS
27	43	Pilot	5500	9000	Night	VFR	SERIOUS
24	53	Pilot	4385	9088	Day	VFR	SERIOUS
22	35	Pilot	5500	9100	Day	IFR	SERIOUS
21	47	Pilot	2330	9145	Day	VFR	SERIOUS
26	37	Pilot	7725	9296	Day	VFR	SERIOUS
21	47	Pilot	3000	9300	Day	VFR	SERIOUS
23	34	Pilot	8950	9800	Day	IFR	SERIOUS
26	52	Co-pilot	1839	9846	Day	VFR	SERIOUS
30	45	Pilot	2461	9871	Night	VFR	SERIOUS
18	36	Co-pilot	7500	10000	Night	VFR	SERIOUS
26	37	Co-pilot	5000	10000	Day	IFR	SERIOUS
22	39	Pilot	6500	10000	Night	IFR	SERIOUS
22	39	Pilot	3816	10039	Day	VFR	SERIOUS
28	46	Co-pilot	2399	10064	Day	VFR	SERIOUS
24	53	Pilot	6472	10257	Night	VFR	SERIOUS
25	48	Pilot	3500	10500	Day	VFR	SERIOUS
25	48	Pilot	6709	10811	Day	VFR	SERIOUS
15	57	Pilot	3129	11244	Day	VFR	SERIOUS
27	43	Pilot	9750	11600	Night	VFR	SERIOUS
26	52	Pilot	3445	11829	Day	VFR	SERIOUS
17	55	Pilot	9281	11898	Day	IFR	SERIOUS
27	43	Pilot	3499	11926	Day	IFR	SERIOUS
24	53	Pilot	10000	12000	Day	IFR	SERIOUS
20	51	Co-pilot	4038	12125	Night	IFR	SERIOUS
30	44	Pilot	3417	12204	Day	VFR	SERIOUS
25	48	Pilot	11363	12384	Day	VFR	SERIOUS
26	37	Pilot	4700	12500	Day	VFR	SERIOUS
28	46	Pilot	8560	12830	Day	VFR	SERIOUS
25	42	Pilot	11000	13000	Day	VFR	SERIOUS
20	41	Co-pilot	3700	13000	Day	VFR	SERIOUS
24	53	Pilot	1200	13200	Night	VFR	SERIOUS
24	53	Pilot	13199	13233	Day	VFR	SERIOUS
28	49	Pilot	7681	13811	Night	VFR	SERIOUS
30	45	Pilot	9200	14000	Day	IFR	SERIOUS
15	57	Pilot	4525	14404	Day	VFR	SERIOUS
25	48	Pilot	6922	14500	Night	VFR	SERIOUS
33	40	Pilot	13404	14718	Night	VFR	SERIOUS
27	43	Pilot	12000	14800	Day	VFR	SERIOUS
30	44	Co-pilot	9000	15000	Day	IFR	SERIOUS
25	48	Pilot	13500	15000	Day	VFR	SERIOUS
24	53	Pilot	8000	15200	Day	VFR	SERIOUS
28	46	Pilot	6500	16000	Day	VFR	SERIOUS
20	51	Pilot	4800	16000	Day	VFR	SERIOUS
30	45	Co-pilot	7400	16000	Night	VFR	SERIOUS
28	49	Pilot	10976	16176	Day	VFR	SERIOUS
20	51	Pilot	5000	16302	Night	VFR	SERIOUS
25	48	Pilot	6519	16491	Day	IFR	SERIOUS
20	51	Pilot	8290	16504	Day	VFR	SERIOUS
4	61	Pilot	6689	16571	Night	IFR	SERIOUS
20	51	Pilot	6745	16750	Day	VFR	SERIOUS
17	55	Pilot	10000	17000	Day	VFR	SERIOUS
21	47	Pilot	15000	17400	Day	IFR	SERIOUS
20	58	Pilot	6790	17531	Day	VFR	SERIOUS
20	51	Pilot	15000	18000	Day	VFR	SERIOUS
22	50	Pilot	9000	18700	Day	IFR	SERIOUS
20	58	Pilot	5381	19597	Day	VFR	SERIOUS
17	55	Pilot	15000	20000	Day	VFR	SERIOUS
15	57	Pilot	18000	20000	Day	IFR	SERIOUS
27	43	Co-pilot	6000	22000	Night	VFR	SERIOUS
1	63	Pilot	11712	24130	Night	IFR	SERIOUS
20	58	Pilot	14361	24440	Day	IFR	SERIOUS
3	60	Pilot	11471	26606	Night	IFR	SERIOUS