80.2K

Verified Solution

Link Copied!

The table below shows performance data for 100 flights betweencities A - G for some airline, including: date, flight #, origin,destination, # passengers flown (load), and tardiness (late, inhours).

write a VBA code (N=10000) to simulate the following:

1. (I7): number of flights which were late for at least 0.75hrs.

2. (I10) average load of flights originated from C with loadexceeding 250.

3. (I13): smallest tardiness of flights from B to E between9/1/18 and 9/3/18.

4. (I16): total load of flights flown from A to C, D, and E on9/4/18.

5. (I19): the flight # of the flight with the maximal load amongall flights from A to G with tardiness less than 0.6 hrs.

Date	Flight #	From	To	Load	Late
09/01/18	7136	C	A	258	0.33
09/01/18	2770	G	E	179	0.50
09/01/18	2368	A	B	203	0.82
09/01/18	6690	G	F	189	0.96
09/01/18	7553	A	E	219	0.31
09/01/18	8323	G	A	246	0.80
09/01/18	7381	D	C	205	0.95
09/01/18	9008	B	C	281	0.52
09/01/18	8664	A	G	214	0.48
09/01/18	2826	G	E	171	0.62
09/01/18	6641	C	E	245	0.62
09/01/18	5402	A	F	194	0.06
09/01/18	3184	A	G	234	0.58
09/01/18	6806	B	A	257	0.46
09/01/18	9117	D	C	295	0.15
09/01/18	1259	E	G	283	0.54
09/01/18	5543	B	E	305	0.92
09/02/18	8008	A	D	319	0.39
09/02/18	8556	A	B	214	0.67
09/02/18	7559	D	F	285	0.08
09/02/18	8068	C	B	245	0.67
09/02/18	4717	E	C	286	0.71
09/02/18	6325	F	B	190	0.77
09/02/18	7037	A	F	259	0.73
09/02/18	5623	D	C	268	0.10
09/02/18	5431	F	C	302	0.90
09/02/18	3347	C	G	220	0.46
09/02/18	6860	F	E	224	0.96
09/02/18	1640	C	D	221	0.57
09/02/18	4486	D	G	206	0.06
09/02/18	9696	A	G	314	0.12
09/02/18	8081	G	E	270	0.46
09/02/18	9974	G	E	219	0.44
09/02/18	9724	B	C	245	0.20
09/02/18	3443	B	E	174	0.66
09/02/18	7582	B	E	218	0.27
09/03/18	2634	G	E	246	0.17
09/03/18	2617	B	D	172	0.08
09/03/18	7589	E	D	231	0.74
09/03/18	7545	D	B	226	0.72
09/03/18	8667	E	B	256	0.34
09/03/18	6576	B	F	199	0.07
09/03/18	8485	C	E	242	0.19
09/03/18	4958	D	F	281	0.17
09/03/18	8681	F	G	263	0.19
09/03/18	6224	C	F	281	0.97
09/03/18	6110	B	D	178	0.52
09/03/18	5971	D	A	188	0.11
09/03/18	5822	B	A	184	0.54
09/03/18	2075	D	A	242	0.62
09/03/18	9603	A	E	255	0.84
09/03/18	4909	D	G	252	0.51
09/03/18	4495	A	G	308	0.05
09/03/18	2861	D	A	316	0.20
09/03/18	8728	A	F	177	0.74
09/03/18	1327	B	G	216	0.76
09/04/18	9191	A	D	235	0.30
09/04/18	9239	E	C	235	0.72
09/04/18	5160	E	F	294	0.23
09/04/18	6930	E	D	227	0.52
09/04/18	9500	F	E	228	0.47
09/04/18	9861	D	B	248	0.92
09/04/18	5956	D	A	183	0.36
09/04/18	9071	A	D	267	0.53
09/04/18	7290	E	G	197	0.69
09/04/18	9086	A	C	310	0.08
09/04/18	5870	D	B	285	0.99
09/04/18	9595	B	A	231	0.56
09/04/18	9609	D	C	308	0.54
09/04/18	3446	C	B	288	0.27
09/04/18	9011	G	B	228	0.80
09/04/18	8651	G	D	225	0.87
09/04/18	2771	F	G	177	0.39
09/04/18	1360	B	A	231	0.33
09/04/18	7293	G	F	214	0.11
09/04/18	1412	G	C	256	0.62
09/04/18	2659	A	B	233	0.59
09/04/18	2847	E	F	182	0.47
09/04/18	4691	D	E	211	0.23
09/04/18	3392	E	A	232	0.48
09/04/18	3245	C	A	213	0.97
09/04/18	2691	E	A	248	0.07
09/04/18	9582	G	B	227	0.89
09/04/18	1591	G	B	280	0.25
09/05/18	5674	B	G	313	0.81
09/05/18	8560	E	G	288	0.09
09/05/18	1428	D	F	264	0.64
09/05/18	4483	C	E	221	0.73
09/05/18	3652	G	A	201	0.46
09/05/18	3474	A	C	206	0.92
09/05/18	8309	F	C	227	0.74
09/05/18	8774	B	A	209	0.65
09/05/18	2887	A	D	267	0.02
09/05/18	3499	D	E	183	0.33
09/05/18	8134	C	A	264	1.00
09/05/18	8516	E	D	315	0.83
09/05/18	7388	C	B	251	0.92
09/05/18	9037	E	C	319	0.45
09/05/18	1120	E	C	274	0.40
09/05/18	5919	B	F	254	0.65