Do 5 Excel problem

Anonymous
timer Asked: Mar 9th, 2019
account_balance_wallet $15

Question Description

Do these problems in a single MS-Excel document

1-"The Excel file Atlanta Airline Data provides arrival and taxi-in time statistics for one day at Atlanta Hartsfield International airport. Find the average and standard deviation of the difference between the scheduled and actual arrival times and the taxi-in time to the gate. Compute the z-scores for each of these variables."

2-"Compute descriptive statistics for liberal arts colleges and research universities in the Excel file Colleges and Universities. Compare the two types of colleges. What can you conclude?"

3-"The Excel file EEO Employment Report shows the number of people employed in different professions for various racial and ethnic groups. Find the proportion of men and women in each ethnic group for the total employment and in each profession."

4-"Using PivotTables, compute the mean and standard deviation for each metric by year in the Excel file Freshman College Data. Are any differences apparent from year to year?"

5-"The Excel file Freshman College Data shows data for 4 years at a large urban university. Use PivotTables to examine differences in student high school performance and first-year retention among different colleges at this university. What conclusions do you reach?"

Unformatted Attachment Preview

Tutor Answer

pallveechem123
School: Boston College

Sorry I didn't see your instruction.Please find single file for all the five questions

Delta Airline Flight Statistics, Atlanta Hartsfield International (ATL) December 24, 2009
Time
Taxi-in
Scheduled
Actual
Difference
Time
Arrival
Time
Arrival
Time
(Minutes)
(Minutes) i er
Flight Number Origin Airport
8
IAH
19:04
19:19
15
14
0.183624512
16
LAX
15:10
15:04
-6
6
-0.198866942
22
MSY
16:33
16:24
-9
11
-0.253508578
24
LAS
14:33
14:27
-6
9
-0.198866942
28
MCO
14:10
14:15
5
13
0.001485724
38
MCO
16:10
15:48
-22
6
-0.490289002
57
JFK
19:41
19:54
13
12
0.147196754
61
LAX
19:02
19:22
20
11
0.274693906
64
LAS
18:00
17:58
-2
10
-0.126011427
66
DFW
15:18
15:14
-4
9
-0.162439185
68
SFO
14:44
14:35
-9
7
-0.253508578
74
MIA
15:41
15:39
-2
18
-0.126011427
101
LAX
17:41
17:56
15
13
0.183624512
105
DTW
17:35
17:26
-9
8
-0.253508578
108
MCO
17:09
16:52
-17
11
-0.399219609
116
LAX
16:19
16:18
-1
7
-0.107797548
130
SLC
14:15
14:38
23
7
0.329335542
147
EWR
19:32
19:19
-13
23
-0.326364093
151
SLC
15:25
15:50
25
12
0.3657633
152
LAX
20:31
20:43
12
21
0.128982876
365
LGA
10:53
10:33
-20
9
-0.453861245
371
IAD
07:34
07:21
-13
7
-0.326364093
373
RDU
08:44
09:09
25
9
0.3657633
377
MSP
13:49
14:12
23
11
0.329335542
409
CLT
08:48
09:17
29
8
0.438618815
418
SJU
11:07
10:59
-8
6
-0.2352947
420
SJU
13:05
13:02
-3
11
-0.144225306
422
SJU
17:24
17:06
-18
6
-0.417433487
424
SJU
18:43
18:22
-21
7
-0.472075124
428
SJU
19:40
19:42
2
17
-0.053155912
438
STX
19:06
19:06
0
23
-0.08958367
509
ROC
08:55
08:26
-29
7
-0.617786154
529
CHS
07:22
07:02
-20
11
-0.453861245
543
DFW
08:42
09:11
29
19
0.438618815
547
SNA
16:02
15:43
-19
10
-0.435647366
660
STT
17:15
17:13
-2
6
-0.126011427
665
ORD
09:00
09:02
2
15
-0.053155912
674
STT
19:11
19:18
7
12
0.037913482
675
MSP
09:00
10:03
63
13
1.057890693
676
STT
20:34
20:28
-6
9
-0.198866942
687
CVG
08:49
08:40
-9
22
-0.253508578
1,005
PHL
08:33
09:03
30
7
0.456832693
1,007
PHL
10:04
10:45
41
10
0.65718536
1,009
PHL
11:02
11:09
7
9
0.037913482
1,013
PHL
14:03
14:01
-2
12
-0.126011427
1,014
ABQ
13:07
13:02
-5
5
-0.180653063
1,015
PHL
15:18
15:10
-8
10
-0.2352947
1,016
SAT
14:10
14:19
9
8
0.074341239

1,017
1,021
1,022
1,023
1,024
1,026
1,030
1,032
1,035
1,036
1,038
1,041
1,044
1,048
1,050
1,052
1,054
1,055
1,060
1,064
1,066
1,068
1,070
1,074
1,077
1,078
1,082
1,084
1,085
1,086
1,088
1,091
1,092
1,118
1,122
1,136
1,140
1,148
1,159
1,162
1,164
1,175
1,177
1,186
1,202
1,213
1,215
1,221
1,228
1,248
1,253
1,258

PHL
PHL
PNS
PHL
PHX
PHX
PHX
PHX
CMH
PHX
SAN
JAX
SAN
SAN
SEA
SEA
SEA
TPA
SEA
SFO
SFO
SFO
SFO
SFO
MSP
LAS
LAS
BDL
MCO
LAS
LAS
CMH
LAS
MCO
EYW
RSW
PBI
MCO
BUF
PBI
DTW
DTW
RDU
JAX
RSW
ROC
SRQ
BNA
RSW
PBI
PIT
MSY

16:26
19:22
18:03
20:52
12:43
13:49
17:49
19:40
16:40
06:18
13:34
09:59
18:27
05:37
13:48
14:57
19:40
09:14
06:12
13:37
16:07
19:40
21:59
06:21
11:16
13:21
17:05
15:50
09:24
19:42
20:37
14:09
06:13
18:34
14:45
18:07
20:49
13:34
18:59
16:40
09:00
12:37
13:53
15:00
12:44
18:10
15:03
08:57
15:22
12:59
09:00
08:34

16:22
19:01
17:55
20:27
12:54
13:53
17:40
22:18
16:30
06:05
13:32
09:24
18:04
05:35
13:56
15:12
20:02
09:12
06:05
13:36
16:07
19:42
21:49
06:07
12:36
13:17
17:03
15:38
09:22
19:55
20:25
14:10
06:02
18:31
14:42
17:48
20:55
13:33
18:36
17:24
08:42
12:46
13:47
14:45
12:39
18:06
14:54
08:51
15:17
13:05
08:32
08:43

-4
-21
-8
-25
11
4
-9
158
-10
-13
-2
-35
-23
-2
8
15
22
-2
-7
-1
0
2
-10
-14
80
-4
-2
-12
-2
13
-12
1
-11
-3
-3
-19
6
-1
-23
44
-18
9
-6
-15
-5
-4
-9
-6
-5
6
-28
9

9
11
14
10
9
11
10
9
10
7
7
7
11
14
12
10
10
13
9
8
9
13
6
13
9
6
9
9
8
29
12
10
9
15
10
13
39
13
12
13
12
7
10
16
11
12
10
9
17
11
11
17

-0.162439185
-0.472075124
-0.2352947
-0.544930639
0.110768997
-0.016728155
-0.253508578
2.788209175
-0.271722457
-0.326364093
-0.126011427
-0.727069426
-0.508502881
-0.126011427
0.056127361
0.183624512
0.311121663
-0.126011427
-0.217080821
-0.107797548
-0.08958367
-0.053155912
-0.271722457
-0.344577972
1.367526631
-0.162439185
-0.126011427
-0.308150215
-0.126011427
0.147196754
-0.308150215
-0.071369791
-0.289936336
-0.144225306
-0.144225306
-0.435647366
0.019699603
-0.107797548
-0.508502881
0.711826996
-0.417433487
0.074341239
-0.198866942
-0.362791851
-0.180653063
-0.162439185
-0.253508578
-0.198866942
-0.180653063
0.019699603
-0.599572275
0.074341239

1,259
1,270
1,271
1,279
1,291
1,292
1,296
1,297
1,302
1,304
1,306
1,308
1,310
1,312
1,314
1,318
1,324
1,326
1,328
1,483
1,494
1,500
1,502
1,510
1,512
1,513
1,516
1,517
1,518
1,520
1,521
1,528
1,531
1,536
1,538
1,542
1,553
1,554
1,555
1,559
1,561
1,563
1,564
1,565
1,577
1,586
1,588
1,591
1,598
1,599
1,601
1,604

RDU
MCI
RSW
BDL
STL
PBI
TUS
JFK
MCO
MCO
FLL
MCO
MCO
MCO
MCO
MCO
MCO
MCO
MCO
PIT
SAT
JAX
SAT
MEM
SLC
CMH
AUS
JAX
SNA
JAX
PHL
PBI
JAX
JAC
PDX
SLC
SAV
BHM
BUF
BDL
JAX
MSP
IND
MSP
MCI
SLC
PBI
RDU
SNA
IAD
BDL
MDW

18:44
15:57
13:50
13:18
15:12
10:05
19:25
08:49
06:57
08:11
18:56
10:19
11:04
12:05
13:08
15:10
18:10
19:16
20:14
10:10
08:48
18:30
11:10
13:59
16:40
07:45
19:17
06:40
14:14
17:05
20:01
18:09
11:35
19:07
14:06
19:28
16:31
08:11
16:28
09:56
07:44
18:08
19:12
14:55
10:10
12:38
19:40
12:30
18:38
10:09
09:00
18:15

19:15
16:36
13:28
13:01
15:02
09:55
19:14
08:39
06:47
07:52
19:04
10:16
10:50
11:54
13:07
14:57
18:04
19:00
19:53
10:57
08:48
18:29
11:05
14:00
16:45
07:26
19:31
06:31
14:06
17:02
20:04
17:57
11:17
19:30
14:24
19:41
16:14
08:30
16:13
09:37
07:32
19:10
19:15
15:06
09:54
12:51
19:43
12:19
18:30
10:02
08:34
18:18

31
39
-22
-17
-10
-10
-11
-10
-10
-19
8
-3
-14
-11
-1
-13
-6
-16
-21
47
0
-1
-5
1
5
-19
14
-9
-8
-3
3
-12
-18
23
18
13
-17
19
-15
-19
-12
62
3
11
-16
13
3
-11
-8
-7
-26
3

49
23
8
8
16
17
14
14
7
8
13
16
8
8
10
15
14
15
9
7
10
9
9
7
16
8
16
7
8
8
14
12
11
45
9
18
10
30
9
15
9
10
18
10
8
13
19
7
10
24
10
14

0.475046572
0.620757602
-0.490289002
-0.399219609
-0.271722457
-0.271722457
-0.289936336
-0.271722457
-0.271722457
-0.435647366
0.056127361
-0.144225306
-0.344577972
-0.289936336
-0.107797548
-0.326364093
-0.198866942
-0.38100573
-0.472075124
0.766468632
-0.08958367
-0.107797548
-0.180653063
-0.071369791
0.001485724
-0.435647366
0.165410633
-0.253508578
-0.2352947
-0.144225306
-0.034942033
-0.308150215
-0.417433487
0.329335542
0.238266148
0.147196754
-0.399219609
0.256480027
-0.362791851
-0.435647366
-0.308150215
1.039676814
-0.034942033
0.110768997
-0.38100573
0.147196754
-0.034942033
-0.289936336
-0.2352947
-0.217080821
-0.563144517
-0.034942033

1,605
1,606
1,610
1,612
1,615
1,617
1,618
1,620
1,623
1,627
1,628
1,629
1,632
1,633
1,634
1,636
1,637
1,638
1,640
1,641
1,649
1,652
1,653
1,655
1,659
1,664
1,675
1,684
1,688
1,689
1,693
1,694
1,695
1,696
1,703
1,705
1,706
1,708
1,709
1,711
1,714
1,716
1,71...

flag Report DMCA
Review

Anonymous
Top quality work from this guy! I'll be back!

Similar Questions
Hot Questions
Related Tags
Study Guides

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors