Describing Data with Numbers and/or Graphs

profileheaher9
atlanta_airline_data.xlsx
Home>Business & Finance homework help>Describing Data with Numbers and/or Graphs

Atlanta Airline Data

Delta Airline Flight Statistics, Atlanta Hartsfield International (ATL) December 24, 2009
Flight Number Origin Airport Scheduled Arrival Time Actual Arrival Time Time Difference (Minutes) Taxi-in Time (Minutes)
8 IAH 19:04 19:19 15 14
16 LAX 15:10 15:04 -6 6
22 MSY 16:33 16:24 -9 11
24 LAS 14:33 14:27 -6 9
28 MCO 14:10 14:15 5 13
38 MCO 16:10 15:48 -22 6
57 JFK 19:41 19:54 13 12
61 LAX 19:02 19:22 20 11
64 LAS 18:00 17:58 -2 10
66 DFW 15:18 15:14 -4 9
68 SFO 14:44 14:35 -9 7
74 MIA 15:41 15:39 -2 18
101 LAX 17:41 17:56 15 13
105 DTW 17:35 17:26 -9 8
108 MCO 17:09 16:52 -17 11
116 LAX 16:19 16:18 -1 7
130 SLC 14:15 14:38 23 7
147 EWR 19:32 19:19 -13 23
151 SLC 15:25 15:50 25 12
152 LAX 20:31 20:43 12 21
365 LGA 10:53 10:33 -20 9
371 IAD 07:34 07:21 -13 7
373 RDU 08:44 09:09 25 9
377 MSP 13:49 14:12 23 11
409 CLT 08:48 09:17 29 8
418 SJU 11:07 10:59 -8 6
420 SJU 13:05 13:02 -3 11
422 SJU 17:24 17:06 -18 6
424 SJU 18:43 18:22 -21 7
428 SJU 19:40 19:42 2 17
438 STX 19:06 19:06 0 23
509 ROC 08:55 08:26 -29 7
529 CHS 07:22 07:02 -20 11
543 DFW 08:42 09:11 29 19
547 SNA 16:02 15:43 -19 10
660 STT 17:15 17:13 -2 6
665 ORD 09:00 09:02 2 15
674 STT 19:11 19:18 7 12
675 MSP 09:00 10:03 63 13
676 STT 20:34 20:28 -6 9
687 CVG 08:49 08:40 -9 22
1,005 PHL 08:33 09:03 30 7
1,007 PHL 10:04 10:45 41 10
1,009 PHL 11:02 11:09 7 9
1,013 PHL 14:03 14:01 -2 12
1,014 ABQ 13:07 13:02 -5 5
1,015 PHL 15:18 15:10 -8 10
1,016 SAT 14:10 14:19 9 8
1,017 PHL 16:26 16:22 -4 9
1,021 PHL 19:22 19:01 -21 11
1,022 PNS 18:03 17:55 -8 14
1,023 PHL 20:52 20:27 -25 10
1,024 PHX 12:43 12:54 11 9
1,026 PHX 13:49 13:53 4 11
1,030 PHX 17:49 17:40 -9 10
1,032 PHX 19:40 22:18 158 9
1,035 CMH 16:40 16:30 -10 10
1,036 PHX 06:18 06:05 -13 7
1,038 SAN 13:34 13:32 -2 7
1,041 JAX 09:59 09:24 -35 7
1,044 SAN 18:27 18:04 -23 11
1,048 SAN 05:37 05:35 -2 14
1,050 SEA 13:48 13:56 8 12
1,052 SEA 14:57 15:12 15 10
1,054 SEA 19:40 20:02 22 10
1,055 TPA 09:14 09:12 -2 13
1,060 SEA 06:12 06:05 -7 9
1,064 SFO 13:37 13:36 -1 8
1,066 SFO 16:07 16:07 0 9
1,068 SFO 19:40 19:42 2 13
1,070 SFO 21:59 21:49 -10 6
1,074 SFO 06:21 06:07 -14 13
1,077 MSP 11:16 12:36 80 9
1,078 LAS 13:21 13:17 -4 6
1,082 LAS 17:05 17:03 -2 9
1,084 BDL 15:50 15:38 -12 9
1,085 MCO 09:24 09:22 -2 8
1,086 LAS 19:42 19:55 13 29
1,088 LAS 20:37 20:25 -12 12
1,091 CMH 14:09 14:10 1 10
1,092 LAS 06:13 06:02 -11 9
1,118 MCO 18:34 18:31 -3 15
1,122 EYW 14:45 14:42 -3 10
1,136 RSW 18:07 17:48 -19 13
1,140 PBI 20:49 20:55 6 39
1,148 MCO 13:34 13:33 -1 13
1,159 BUF 18:59 18:36 -23 12
1,162 PBI 16:40 17:24 44 13
1,164 DTW 09:00 08:42 -18 12
1,175 DTW 12:37 12:46 9 7
1,177 RDU 13:53 13:47 -6 10
1,186 JAX 15:00 14:45 -15 16
1,202 RSW 12:44 12:39 -5 11
1,213 ROC 18:10 18:06 -4 12
1,215 SRQ 15:03 14:54 -9 10
1,221 BNA 08:57 08:51 -6 9
1,228 RSW 15:22 15:17 -5 17
1,248 PBI 12:59 13:05 6 11
1,253 PIT 09:00 08:32 -28 11
1,258 MSY 08:34 08:43 9 17
1,259 RDU 18:44 19:15 31 49
1,270 MCI 15:57 16:36 39 23
1,271 RSW 13:50 13:28 -22 8
1,279 BDL 13:18 13:01 -17 8
1,291 STL 15:12 15:02 -10 16
1,292 PBI 10:05 09:55 -10 17
1,296 TUS 19:25 19:14 -11 14
1,297 JFK 08:49 08:39 -10 14
1,302 MCO 06:57 06:47 -10 7
1,304 MCO 08:11 07:52 -19 8
1,306 FLL 18:56 19:04 8 13
1,308 MCO 10:19 10:16 -3 16
1,310 MCO 11:04 10:50 -14 8
1,312 MCO 12:05 11:54 -11 8
1,314 MCO 13:08 13:07 -1 10
1,318 MCO 15:10 14:57 -13 15
1,324 MCO 18:10 18:04 -6 14
1,326 MCO 19:16 19:00 -16 15
1,328 MCO 20:14 19:53 -21 9
1,483 PIT 10:10 10:57 47 7
1,494 SAT 08:48 08:48 0 10
1,500 JAX 18:30 18:29 -1 9
1,502 SAT 11:10 11:05 -5 9
1,510 MEM 13:59 14:00 1 7
1,512 SLC 16:40 16:45 5 16
1,513 CMH 07:45 07:26 -19 8
1,516 AUS 19:17 19:31 14 16
1,517 JAX 06:40 06:31 -9 7
1,518 SNA 14:14 14:06 -8 8
1,520 JAX 17:05 17:02 -3 8
1,521 PHL 20:01 20:04 3 14
1,528 PBI 18:09 17:57 -12 12
1,531 JAX 11:35 11:17 -18 11
1,536 JAC 19:07 19:30 23 45
1,538 PDX 14:06 14:24 18 9
1,542 SLC 19:28 19:41 13 18
1,553 SAV 16:31 16:14 -17 10
1,554 BHM 08:11 08:30 19 30
1,555 BUF 16:28 16:13 -15 9
1,559 BDL 09:56 09:37 -19 15
1,561 JAX 07:44 07:32 -12 9
1,563 MSP 18:08 19:10 62 10
1,564 IND 19:12 19:15 3 18
1,565 MSP 14:55 15:06 11 10
1,577 MCI 10:10 09:54 -16 8
1,586 SLC 12:38 12:51 13 13
1,588 PBI 19:40 19:43 3 19
1,591 RDU 12:30 12:19 -11 7
1,598 SNA 18:38 18:30 -8 10
1,599 IAD 10:09 10:02 -7 24
1,601 BDL 09:00 08:34 -26 10
1,604 MDW 18:15 18:18 3 14
1,605 CVG 18:19 18:20 1 29
1,606 MSY 17:42 17:44 2 14
1,610 MCI 08:41 08:49 8 28
1,612 RSW 07:45 07:35 -10 8
1,615 RDU 16:35 16:38 3 13
1,617 MEM 16:09 16:36 27 13
1,618 CHS 16:51 16:39 -12 9
1,620 MSP 19:45 19:58 13 10
1,623 CHS 08:26 08:13 -13 11
1,627 MSP 16:43 16:59 16 14
1,628 MCI 19:09 19:49 40 14
1,629 RDU 09:51 09:51 0 15
1,632 TPA 17:45 17:28 -17 12
1,633 MSY 09:49 09:34 -15 7
1,634 EGE 17:59 17:48 -11 11
1,636 MEM 08:21 08:13 -8 9
1,637 IAD 14:10 14:02 -8 11
1,638 PBI 09:00 09:08 8 9
1,640 MOB 08:23 08:30 7 15
1,641 JFK 11:13 10:55 -18 9
1,649 ORF 08:58 09:04 6 14
1,652 SMF 19:29 19:45 16 17
1,653 MKE 08:53 09:00 7 10
1,655 MSP 21:00 21:19 19 10
1,659 SAV 12:53 12:57 4 7
1,664 MCI 12:34 12:41 7 12
1,675 ABQ 18:24 18:27 3 10
1,684 SJC 13:57 14:18 21 11
1,688 RSW 19:34 19:28 -6 18
1,689 BDL 18:10 17:51 -19 9
1,693 SNA 21:20 21:00 -20 7
1,694 SLC 22:37 22:49 12 8
1,695 CMH 18:45 18:54 9 16
1,696 STL 08:45 08:58 13 10
1,703 CMH 08:57 09:00 3 11
1,705 DTW 20:08 20:22 14 8
1,706 AUS 10:01 10:02 1 14
1,708 DTW 07:45 07:54 9 8
1,709 ORD 10:10 11:09 59 9
1,711 DTW 11:26 11:27 1 11
1,714 ONT 13:41 14:07 26 12
1,716 CLT 09:43 10:02 19 12
1,717 IND 08:56 08:55 -1 15
1,720 SLC 06:20 06:40 20 8
1,723 JFK 13:46 13:17 -29 7
1,727 JFK 22:04 21:19 -45 8
1,728 RIC 07:45 07:24 -21 8
1,731 DAY 07:45 07:39 -6 17
1,734 MIA 20:53 20:45 -8 13
1,737 JFK 16:40 16:10 -30 8
1,738 SRQ 12:49 12:39 -10 12
1,739 CVG 16:16 16:14 -2 9
1,740 MSY 12:29 12:42 13 11
1,747 MSP 10:08 10:54 46 15
1,759 MDW 10:05 09:56 -9 13
1,766 HDN 18:04 18:03 -1 11
1,769 LGA 08:44 08:19 -25 9
1,771 LGA 09:46 09:39 -7 9
1,775 LGA 12:02 11:24 -38 10
1,779 LGA 13:58 13:28 -30 7
1,781 LGA 14:53 14:18 -35 11
1,783 LGA 15:50 15:32 -18 9
1,785 LGA 16:50 16:27 -23 8
1,787 LGA 17:55 17:39 -16 28
1,789 LGA 18:54 18:37 -17 15
1,790 SAT 16:40 17:15 35 10
1,793 LGA 20:55 20:28 -27 9
1,797 LGA 22:49 22:22 -27 9
1,844 SLC 21:02 20:54 -8 10
1,850 SAV 06:41 06:33 -8 7
1,851 BOS 08:52 08:25 -27 9
1,852 SRQ 07:39 07:36 -3 10
1,853 BOS 10:21 10:07 -14 20
1,854 PNS 09:06 09:08 2 14
1,855 BOS 11:42 11:13 -29 8
1,857 BOS 12:38 12:00 -38 5
1,859 BOS 14:07 13:48 -19 9
1,861 BOS 15:25 14:55 -30 9
1,865 BOS 17:49 17:25 -24 9
1,867 BOS 18:51 19:04 13 35
1,869 BOS 19:58 20:06 8 9
1,877 BWI 08:50 08:52 2 20
1,878 SAV 09:00 09:15 15 9
1,879 BWI 10:05 10:04 -1 11
1,881 BWI 11:57 11:56 -1 14
1,882 SAV 07:42 07:49 7 11
1,883 BWI 13:08 14:22 74 10
1,884 TUS 12:33 12:32 -1 9
1,885 BWI 14:33 14:36 3 9
1,887 BWI 15:35 15:25 -10 8
1,889 BWI 18:09 17:53 -16 7
1,891 PDX 19:39 19:50 11 9
1,896 DEN 05:56 06:17 21 6
1,897 PBI 07:44 07:51 7 10
1,898 DEN 11:09 11:48 39 7
1,899 RIC 08:51 13:16 265 7
1,900 DEN 12:22 13:00 38 7
1,902 DEN 13:36 14:29 53 9
1,904 DEN 15:59 15:59 0 8
1,908 DEN 18:10 18:44 34 7
1,910 DEN 20:45 20:55 10 11
1,914 DFW 10:08 10:13 5 9
1,917 BUF 08:48 08:37 -11 9
1,918 DFW 12:45 12:52 7 10
1,920 DFW 14:03 14:35 32 10
1,921 CHS 13:09 13:19 10 10
1,924 DFW 16:30 04:23 713 8
1,926 DFW 19:15 02:44 449 13
1,935 ORF 11:49 11:33 -16 9
1,943 ORD 15:10 15:08 -2 15
1,945 ORD 18:20 18:34 14 10
1,948 SAN 15:03 14:58 -5 8
1,951 DCA 08:00 07:59 -1 9
1,953 DCA 09:17 09:06 -11 14
1,954 DAB 07:30 07:38 8 11
1,955 DCA 10:05 10:01 -4 12
1,959 DCA 12:02 11:48 -14 11
1,960 PNS 10:10 10:03 -7 16
1,961 DCA 12:58 12:54 -4 8
1,962 ABQ 11:16 11:30 14 8
1,964 COS 12:33 12:46 13 11
1,965 DCA 15:01 14:59 -2 11
1,967 DCA 16:05 16:07 2 13
1,969 DCA 17:03 16:54 -9 8
1,971 DCA 18:00 18:08 8 11
1,973 DCA 19:09 19:05 -4 13
1,975 DCA 20:05 19:55 -10 10
1,978 SAT 19:26 19:25 -1 21
1,982 MIA 08:35 09:02 27 16
1,984 MIA 09:49 09:41 -8 12
1,988 MIA 13:28 13:36 8 11
1,989 IND 10:08 09:51 -17 11
1,990 MIA 14:30 14:32 2 23
1,991 EWR 09:00 08:49 -11 12
1,992 RSW 08:47 08:51 4 20
1,994 MIA 16:55 16:46 -9 14
1,995 BUF 13:54 13:53 -1 8
1,996 MIA 18:10 18:23 13 17
1,998 MIA 19:37 19:25 -12 10
1,999 JAX 09:00 09:19 19 9
2,007 EWR 10:10 10:03 -7 18
2,008 SRQ 08:44 08:52 8 14
2,009 EWR 11:13 15:33 260 12
2,011 EWR 13:04 12:45 -19 8
2,014 ELP 12:44 12:59 15 8
2,015 EWR 15:25 15:05 -20 9
2,016 JAX 13:09 15:35 146 8
2,017 EWR 16:39 16:05 -34 7
2,019 EWR 18:01 17:44 -17 11
2,028 FLL 08:50 08:49 -1 14
2,030 FLL 09:58 10:12 14 15
2,032 FLL 10:49 10:41 -8 10
2,034 FLL 12:07 12:01 -6 6
2,036 FLL 13:39 13:27 -12 9
2,042 FLL 15:54 15:45 -9 6
2,044 FLL 17:03 16:52 -11 8
2,046 FLL 18:26 18:06 -20 10
2,048 FLL 19:39 19:30 -9 13
2,050 FLL 20:52 20:48 -4 20
2,054 TPA 07:03 06:51 -12 7
2,056 TPA 08:09 07:58 -11 5
2,060 TPA 10:10 10:11 1 18
2,062 TPA 11:25 11:20 -5 9
2,064 TPA 12:46 12:47 1 13
2,066 TPA 14:04 13:49 -15 12
2,068 TPA 16:14 16:05 -9 10
2,072 TPA 18:59 19:00 1 29
2,074 TPA 20:14 19:49 -25 10
2,076 MSY 15:02 14:42 -20 7
2,079 MDW 12:40 12:52 12 8
2,080 LAX 13:24 13:20 -4 7
2,085 JAX 10:45 10:32 -13 9
2,086 PBI 14:52 14:29 -23 8
2,088 IAH 12:42 13:10 28 12
2,092 LAX 21:55 22:05 10 11
2,094 LAX 23:58 23:36 -22 7
2,096 LAX 06:10 05:49 -21 8
2,097 CLT 10:37 10:28 -9 9
2,098 LAX 07:08 06:56 -12 8