Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

An American College conducted a study in the early 2000 to examine if there were any gender pay gaps[1] in its four schools: Business, Health,

An American College conducted a study in the early 2000 to examine if there were any gender pay gaps[1] in its four schools: Business, Health, Liberal Studies and Sciences. Data were collected of a sample of 199 academics on their annual salary, years of service, rank, school, gender and age. The data file: Faculty Salary (Research Report Dataset).xlsx is available on Blackboard. A small portion of the data is shown below:

Faculty ID

Age

Years of Service

Rank

School

Gender M/F

Salary ($/year)

1

49

22

ASST

BUSINESS

F

106632

2

31

0

ASST

BUSINESS

F

80000

3

34

2

ASST

BUSINESS

F

114666

…

…

…

…

…

…

…










Legend: There are three academic ranks in the dataset: ASST, ASSO and PROF, which stand for Assistant Professor, Associate Professor and Professor respectively.

Task 1 (Boxplots and t-tests)

(a) Construct separate boxplots of salaries for male and female academics, and compare their distributions (central location, spread and skewness).

(b) Test if male academics on average earn more than their female counterparts at 1%.

(a) Considering assistant professors only, test if male assistant professors on average earn more than female assistant professors at 1%.

(b) Considering associate professors only, test if male associate professors on average earn more than female associate professors at 1%.

(c) Considering professors only, test if male professors on average earn more than female professors at 1%.


Faculty IDAgeYears of ServiceRankSchoolGender M/FSalary ($/year)
14922ASSTBUSINESSF106632
2310ASSTBUSINESSF80000
3342ASSTBUSINESSF114666
4340ASSTBUSINESSF112000
5416ASSOBUSINESSF119962
6280ASSTBUSINESSF110000
75823ASSOLIBERAL STUDIESF94376
85222ASSTLIBERAL STUDIESF83506
9356ASSOLIBERAL STUDIESF81124
10377ASSOLIBERAL STUDIESF75116
11427ASSOLIBERAL STUDIESF83568
12303ASSTLIBERAL STUDIESF66958
135723PROFLIBERAL STUDIESF111758
145323PROFLIBERAL STUDIESF110750
15260ASSTLIBERAL STUDIESF74000
165930ASSTLIBERAL STUDIESF98926
17394ASSTLIBERAL STUDIESF66190
185119ASSOLIBERAL STUDIESF95138
19384ASSTLIBERAL STUDIESF66190
205421ASSOLIBERAL STUDIESF84870
214317ASSOLIBERAL STUDIESF78460
22350ASSTLIBERAL STUDIESF56700
23313ASSTLIBERAL STUDIESF63666
24416ASSOLIBERAL STUDIESF76908
25311ASSTLIBERAL STUDIESF62776
265621PROFLIBERAL STUDIESF105900
274318ASSOLIBERAL STUDIESF90310
284820ASSOLIBERAL STUDIESF92424
294921ASSTHEALTHF95386
304917ASSOHEALTHF87098
31407ASSOHEALTHF74218
32321ASSTHEALTHF64800
33374ASSTHEALTHF71314
345424PROFHEALTHF110770
35323ASSTHEALTHF66924
36387ASSOHEALTHF74410
37346ASSTHEALTHF65700
38283ASSTHEALTHF70218
39261ASSTHEALTHF76900
40352ASSTHEALTHF70210
41332ASSTHEALTHF71088
42408ASSOSCIENCESF78484
43351ASSTSCIENCESF66906
44363ASSTSCIENCESF69112
45323ASSTSCIENCESF71088
46292ASSTSCIENCESF73180
474312ASSTSCIENCESF82330
48375ASSTSCIENCESF70210
49347ASSOSCIENCESF81432
50348ASSTSCIENCESF73332
51359ASSTSCIENCESF67200
52416ASSTSCIENCESF67328
533911ASSTSCIENCESF79646
544417ASSOSCIENCESF98104
554612ASSTSCIENCESF73154
564211ASSTSCIENCESF68878
57361ASSOSCIENCESF81000
584318ASSTSCIENCESF82190
595119ASSTSCIENCESF81286
605116ASSOSCIENCESF87940
615419ASSTSCIENCESF85498
624510ASSTSCIENCESF72406
633811ASSOSCIENCESF85848
64398ASSTSCIENCESF74332
655019ASSTSCIENCESF83946
66332ASSTSCIENCESF73180
674411PROFBUSINESSM128750
68377ASSOBUSINESSM127002
69376ASSOBUSINESSM118852
704520ASSOBUSINESSM98116
71344PROFBUSINESSM189938
724721ASSTBUSINESSM109524
73369ASSOBUSINESSM111032
744418ASSOBUSINESSM91864
754011ASSOBUSINESSM113742
76315ASSTBUSINESSM121770
77292PROFBUSINESSM167266
78372ASSTBUSINESSM116000
794014ASSTBUSINESSM82550
804410PROFBUSINESSM127282
814517ASSTBUSINESSM100212
82337ASSOBUSINESSM116100
83353ASSOBUSINESSM138842
844922ASSOBUSINESSM115500
85369ASSOBUSINESSM112988
86326PROFBUSINESSM156614
87335PROFBUSINESSM147728
885924ASSOLIBERAL STUDIESM102856
894721ASSOLIBERAL STUDIESM91430
905927PROFLIBERAL STUDIESM112144
914012ASSTLIBERAL STUDIESM75096
924714PROFLIBERAL STUDIESM102144
93270ASSOLIBERAL STUDIESM78000
94378ASSTLIBERAL STUDIESM81016
954116ASSTLIBERAL STUDIESM74374
96417ASSOLIBERAL STUDIESM103774
975722ASSTLIBERAL STUDIESM92682
98290ASSTLIBERAL STUDIESM65812
996130PROFLIBERAL STUDIESM118512
1005924PROFLIBERAL STUDIESM119286
1015325PROFLIBERAL STUDIESM138838
1025419ASSOLIBERAL STUDIESM88126
1034722PROFLIBERAL STUDIESM112918
104408ASSOLIBERAL STUDIESM80000
1055023PROFLIBERAL STUDIESM112008
106367ASSOLIBERAL STUDIESM72828
1075118PROFLIBERAL STUDIESM94240
1085525ASSOLIBERAL STUDIESM99262
1094111PROFLIBERAL STUDIESM91164
1105924PROFLIBERAL STUDIESM110330
1115724PROFLIBERAL STUDIESM115032
1125522ASSOLIBERAL STUDIESM94506
113270ASSTLIBERAL STUDIESM63000
114377ASSOLIBERAL STUDIESM75922
1155322PROFLIBERAL STUDIESM116014
116340ASSTLIBERAL STUDIESM63000
1173712ASSOLIBERAL STUDIESM83714
118272ASSTLIBERAL STUDIESM64892
119300ASSTLIBERAL STUDIESM63000
1205824PROFLIBERAL STUDIESM116878
1215825PROFLIBERAL STUDIESM140036
1224720ASSOLIBERAL STUDIESM93688
1233611PROFLIBERAL STUDIESM130566
124338ASSOLIBERAL STUDIESM73170
1256228ASSOLIBERAL STUDIESM112672
126356ASSOLIBERAL STUDIESM71940
1274921PROFLIBERAL STUDIESM105308
1284924PROFLIBERAL STUDIESM108416
1295925PROFLIBERAL STUDIESM112510
1304116PROFLIBERAL STUDIESM93914
131398ASSOLIBERAL STUDIESM80002
1324616ASSOLIBERAL STUDIESM87362
133327ASSOLIBERAL STUDIESM81968
1345325PROFLIBERAL STUDIESM134086
1355122PROFLIBERAL STUDIESM131962
1365725PROFLIBERAL STUDIESM108328
1375018ASSTLIBERAL STUDIESM76948
1385924PROFLIBERAL STUDIESM116882
1394822ASSOLIBERAL STUDIESM98082
1404617ASSTLIBERAL STUDIESM79104
1415023ASSOLIBERAL STUDIESM95618
1425625PROFLIBERAL STUDIESM114312
143341ASSTHEALTHM70876
1444820ASSOHEALTHM94694
1455320PROFHEALTHM108514
146338ASSOHEALTHM95546
1475623PROFHEALTHM127950
148301ASSTHEALTHM70876
1494716PROFHEALTHM109672
150347ASSTHEALTHM71776
1515520PROFHEALTHM98176
1525523PROFHEALTHM131104
1535122ASSTHEALTHM90222
1545123ASSOHEALTHM112980
155332PROFHEALTHM216676
1565426ASSTHEALTHM111170
157372ASSTHEALTHM73988
1585321ASSOHEALTHM113858
1595321ASSOHEALTHM93740
1604617ASSOHEALTHM92314
161312ASSTSCIENCESM68998
162280ASSTSCIENCESM70400
1635824PROFSCIENCESM107188
164348ASSOSCIENCESM80462
165438ASSOSCIENCESM74336
166326ASSTSCIENCESM68016
1674217PROFSCIENCESM96036
168303ASSTSCIENCESM76796
1695218PROFSCIENCESM106422
1706328PROFSCIENCESM137980
171372ASSTSCIENCESM70880
1725525PROFSCIENCESM116100
173270ASSTSCIENCESM68000
1745926PROFSCIENCESM126018
175439ASSOSCIENCESM82836
1765021PROFSCIENCESM101558
1776129PROFSCIENCESM131302
1785523ASSOSCIENCESM107222
1796741ASSOSCIENCESM115342
180346ASSOSCIENCESM84418
1815021PROFSCIENCESM93946
1825523PROFSCIENCESM110138
183438ASSOSCIENCESM74478
1845325ASSOSCIENCESM102814
1854413PROFSCIENCESM119386
186330ASSTSCIENCESM69000
1874312ASSTSCIENCESM82266
188374ASSTSCIENCESM71088
1894314ASSTSCIENCESM78240
1904714ASSTSCIENCESM89808
1915522PROFSCIENCESM108284
192409ASSTSCIENCESM100324
1934822ASSOSCIENCESM125832
1944714PROFSCIENCESM107322
1954112PROFSCIENCESM94672
1964914PROFSCIENCESM89460
1973711ASSOSCIENCESM84378
1983610ASSTSCIENCESM72406
1994214ASSOSCIENCESM91458

Step by Step Solution

There are 3 Steps involved in it

Step: 1

Answer Values Gender MF Rank Count of Faculty ID Sum of Salary year Average F ASSO 20 1720790 86040 ... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Document Format ( 2 attachments)

PDF file Icon
635d9f2b2203a_177376.pdf

180 KBs PDF File

Word file Icon
635d9f2b2203a_177376.docx

120 KBs Word File

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Statistics The Art And Science Of Learning From Data

Authors: Alan Agresti, Christine A. Franklin

3rd Edition

9780321849281, 321755944, 321849280, 978-0321755940

More Books

Students also viewed these Accounting questions