{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Data","Sheet1","Sheet2"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Data","index":0,"n_rows":51,"n_cols":17,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
["ID","Salary","Compa","Midpoint ","Age","Performance Rating","Service","Gender","Raise","Degree","Gender1","Gr"]
[1,63.9,1.121,57,34,85,8,0,5.7,0,"M","E",null,"The ongoing question that the weekly assignments will focus on is:  Are males and females paid the same for equal work (under the Equal Pay Act)?  "]
[2,27.7,0.89200000000000002,31,52,80,7,0,3.9,0,"M","B",null,"Note: to simplfy the analysis, we will assume that jobs within each grade comprise equal work."]
[3,34.299999999999997,1.105,31,30,75,5,1,3.6,1,"F","B"]
[4,57.6,1.01,57,42,100,16,0,5.5,1,"M","E",null,"The column labels in the  table mean:"]
[5,47.4,0.98699999999999999,48,36,90,16,0,5.7,1,"M","D",null,"ID – Employee sample number ",null,null,"Salary – Salary in thousands     "]
[6,75.2,1.1220000000000001,67,36,70,12,0,4.5,1,"M","F",null,"Age – Age in years",null,null,"Performance Rating - Appraisal rating (employee evaluation score)"]
[7,41.9,1.048,40,32,100,8,1,5.7,1,"F","C",null,"Service – Years of service (rounded)",null,null,"Gender – 0 = male, 1 = female  "]
[8,23.4,1.018,23,32,90,9,1,5.8,1,"F","A",null,"Midpoint – salary grade midpoint    ",null,null,"Raise – percent of last raise"]
[9,74,1.105,67,49,100,10,0,4,1,"M","F",null,"Grade – job/pay grade",null,null,"Degree (0= BS\\BA 1 = MS)"]
[10,24.2,1.054,23,30,80,7,1,4.7,1,"F","A",null,"Gender1 (Male or Female)",null,null,"Compa - salary divided by midpoint"]
[11,23.7,1.032,23,41,100,19,1,4.8,1,"F","A"]
[12,58.3,1.022,57,52,95,22,0,4.5,0,"M","E"]
[13,41.4,1.034,40,30,100,2,1,4.7,0,"F","C"]
[14,23.7,1.03,23,32,90,12,1,6,1,"F","A"]
[15,23,1.0009999999999999,23,32,80,8,1,4.9000000000000004,1,"F","A"]
[16,41.5,1.0369999999999999,40,44,90,4,0,5.7,0,"M","C"]
[17,63.6,1.115,57,27,55,3,1,3,1,"F","E"]
[18,34.299999999999997,1.107,31,31,80,11,1,5.6,0,"F","B"]
[19,24.7,1.073,23,32,85,1,0,4.5999999999999996,1,"M","A"]
[20,35.5,1.1439999999999999,31,44,70,16,1,4.8,0,"F","B"]
[21,78.099999999999994,1.1659999999999999,67,43,95,13,0,6.3,1,"M","F"]
[22,49,1.02,48,48,65,6,1,3.8,1,"F","D"]
[23,23.1,1.0049999999999999,23,36,65,6,1,3.3,0,"F","A"]
[24,56.8,1.1830000000000001,48,30,75,9,1,3.8,0,"F","D"]
[25,24.2,1.0529999999999999,23,41,70,4,0,4,0,"M","A"]
[26,23.1,1.0029999999999999,23,22,95,2,1,6.2,0,"F","A"]
[27,45.3,1.1319999999999999,40,35,80,7,0,3.9,1,"M","C"]
[28,76.400000000000006,1.141,67,44,95,9,1,4.4000000000000004,0,"F","F"]
[29,74.599999999999994,1.113,67,52,95,5,0,5.4,0,"M","F"]
[30,48.2,1.0049999999999999,48,45,90,18,0,4.3,0,"M","D"]
[31,23.1,1.006,23,29,60,4,1,3.9,1,"F","A"]
[32,27.8,0.89800000000000002,31,25,95,4,0,5.6,0,"M","B"]
[33,61.7,1.083,57,35,90,9,0,5.5,1,"M","E"]
[34,27.5,0.88600000000000001,31,26,80,2,0,4.9000000000000004,1,"M","B"]
[35,23.7,1.032,23,23,90,4,1,5.3,0,"F","A"]
[36,25.1,1.093,23,27,75,3,1,4.3,0,"F","A"]
[37,23.4,1.016,23,22,95,2,1,6.2,0,"F","A"]
[38,60.1,1.054,57,45,95,11,0,4.5,0,"M","E"]
[39,36.700000000000003,1.1839999999999999,31,27,90,6,1,5.5,0,"F","B"]
[40,25.1,1.0900000000000001,23,24,90,2,0,6.3,0,"M","A"]
[41,38.799999999999997,0.97099999999999997,40,25,80,5,0,4.3,0,"M","C"]
[42,23,1.0009999999999999,23,32,100,8,1,5.7,1,"F","A"]
[43,75,1.1200000000000001,67,42,95,20,1,5.5,0,"F","F"]
[44,64.400000000000006,1.129,57,45,90,16,0,5.2,1,"M","E"]
[45,47.4,0.98799999999999999,48,36,95,8,1,5.2,1,"F","D"]
[46,68.7,1.2050000000000001,57,39,75,20,0,3.9,1,"M","E"]
[47,59.6,1.0449999999999999,57,37,95,5,0,5.5,1,"M","E"]
[48,65.900000000000006,1.1559999999999999,57,34,90,11,1,5.3,1,"F","E"]
[49,69.099999999999994,1.2130000000000001,57,41,95,21,0,6.6,0,"M","E"]
[50,65.2,1.143,57,38,80,12,0,4.5999999999999996,0,"M","E"]

{"sheet":"Sheet1","index":1,"n_rows":51,"n_cols":30,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
["Sal","Compa","G","Mid","Age","EES","SR","G","Raise","Deg",null,"SUMMARY OUTPUT",null,null,null,null,null,null,null,null,null,"SUMMARY OUTPUT"]
[24,1.0449999999999999,1,23,32,90,9,1,5.8,1]
[24.2,1.0529999999999999,1,23,30,80,7,1,4.7,1,null,"Regression Statistics",null,null,null,null,null,null,null,null,null,"Regression Statistics"]
[23.4,1.018,1,23,41,100,19,1,4.8,1,null,"Multiple R",0.70501794842985532,null,null,null,null,null,null,null,null,"Multiple R",0.99312869349657118]
[23.4,1.0169999999999999,1,23,32,90,12,1,6,1,null,"R Square",0.4970503076082422,null,null,null,null,null,null,null,null,"R Square",0.9863046018462065]
[22.6,0.98299999999999998,1,23,32,80,8,1,4.9000000000000004,1,null,"Adjusted R Square",0.41322535887628253,null,null,null,null,null,null,null,null,"Adjusted R Square",0.98402203548724088]
[22.9,0.995,1,23,36,65,6,1,3.3,0,null,"Standard Error",5.6125268582035627E-2,null,null,null,null,null,null,null,null,"Standard Error",2.4352822665038429]
[23.1,1.0029999999999999,1,23,22,95,2,1,6.2,0,null,"Observations",50,null,null,null,null,null,null,null,null,"Observations",50]
[23.3,1.0109999999999999,1,23,29,60,4,1,3.9,1]
[22.7,0.98499999999999999,1,23,23,90,4,1,5.3,0,null,"ANOVA",null,null,null,null,null,null,null,null,null,"ANOVA"]
[23.5,1.0229999999999999,1,23,27,75,3,1,4.3,0,null,null,"df","SS","MS","F","Significance F",null,null,null,null,null,"df","SS","MS","F","Significance F"]
[23,1.002,1,23,22,95,2,1,6.2,0,null,"Regression",7,0.13075007751696333,1.8678582502423331E-2,5.9296225661601101,7.8290637269444325E-5,null,null,null,null,"Regression",7,17938.424611862978,2562.632087408997,432.1033638177276,5.2990627368433731E-37]
[24,1.042,1,23,32,100,8,1,5.7,1,null,"Residual",42,0.13230192248303668,3.1500457734056353E-3,null,null,null,null,null,null,"Residual",42,249.08518813701997,5.9305997175480947]
[35.5,1.145,1,31,30,75,5,1,3.6,1,null,"Total",49,0.26305200000000001,null,null,null,null,null,null,null,"Total",49,18187.5098]
[34.700000000000003,1.119,1,31,31,80,11,1,5.6,0]
[35.5,1.1459999999999999,1,31,44,70,16,1,4.8,0,null,null,"Coefficients","Standard Error","t Stat","P-value","Lower 95%","Upper 95%","Lower 95.0%","Upper 95.0%",null,null,"Coefficients","Standard Error","t Stat","P-value","Lower 95%","Upper 95%","Lower 95.0%","Upper 95.0%"]
[35.200000000000003,1.1359999999999999,1,31,27,90,6,1,5.5,0,null,"Intercept",0.94862387718438568,8.1716771562214172E-2,11.608680311876507,1.0882066072837762E-14,0.78371275568128651,1.1135349986874847,0.78371275568128651,1.1135349986874847,null,"Intercept",-4.8714544587187794,3.545700710020335,-1.3739045839237911,0.17675990371725467,-12.026968185281191,2.2840592678436318,-12.026968185281191,2.2840592678436318]
[40.4,1.01,1,40,32,100,8,1,5.7,1,null,"Mid",3.499502670290448E-3,6.4925677403678862E-4,5.3900133356054241,2.9767069189295201E-6,2.1892494541758747E-3,4.8097558864050212E-3,2.1892494541758747E-3,4.8097558864050212E-3,null,"Mid",1.2284155048098966,2.8171330813468291E-2,43.60516416294432,1.3201933389408255E-36,1.1715634575511906,1.2852675520686025,1.1715634575511906,1.2852675520686025]
[42.7,1.0680000000000001,1,40,30,100,2,1,4.7,0,null,"Age",5.5277380746407249E-4,1.4459445856619024E-3,0.38229252555417409,0.70417210068627067,-2.3652605041496119E-3,3.4708081190777569E-3,-2.3652605041496119E-3,3.4708081190777569E-3,null,"Age",3.6827942499583918E-2,6.273971237505592E-2,0.58699571779079407,0.56034892823337712,-8.9785923084608463E-2,0.16344180808377629,-8.9785923084608463E-2,0.16344180808377629]
[53.4,1.1120000000000001,1,48,48,65,6,1,3.8,1,null,"EES",-1.8462553145368759E-3,1.0252154676297679E-3,-1.8008461370616065,7.8910553902186875E-2,-3.9152238912069674E-3,2.2271326213321556E-4,-3.9152238912069674E-3,2.2271326213321556E-4,null,"EES",-8.2157978513185431E-2,4.4484224498897988E-2,-1.8469014451453625,7.1814722532508438E-2,-0.1719307780384795,7.6148210121086551E-3,-0.1719307780384795,7.6148210121086551E-3]
[51.5,1.0720000000000001,1,48,30,75,9,1,3.8,0,null,"SR",-4.1822879254405261E-4,1.8278101282994377E-3,-0.22881413450376561,0.82012389798666652,-4.1068989686913844E-3,3.2704413836032791E-3,-4.1068989686913844E-3,3.2704413836032791E-3,null,"SR",-7.7848452897062825E-2,7.9308904962790139E-2,-0.98158527007260377,0.33192499687371424,-0.23790030287303665,8.2203397078911E-2,-0.23790030287303665,8.2203397078911E-2]
[49.8,1.0369999999999999,1,48,36,95,8,1,5.2,1,null,"G",6.4664996148208267E-2,1.8339669712288294E-2,3.5259629624016728,1.0348659908465242E-3,2.7654044266105626E-2,0.10167594803031091,2.7654044266105626E-2,0.10167594803031091,null,"G",2.9145083112459003,0.79576051130325731,3.6625445342502134,6.935490244597128E-4,1.3085985835593454,4.5204180389324549,1.3085985835593454,4.5204180389324549]
[68.3,1.198,1,57,27,55,3,1,3,1,null,"Raise",1.4654956444420752E-2,1.3908897630199507E-2,1.0536389607614463,0.29807223223832158,-1.3414335369459717E-2,4.272424825830122E-2,-1.3414335369459717E-2,4.272424825830122E-2,null,"Raise",0.67632948244030267,0.60350876888781324,1.1206622294597117,0.26879887643418288,-0.54160052154267946,1.8942594864232847,-0.54160052154267946,1.8942594864232847]
[65.400000000000006,1.1479999999999999,1,57,34,90,11,1,5.3,1,null,"Deg",1.4675988098542369E-3,1.6109824944310614E-2,9.1099612499050631E-2,0.92784654706147784,-3.1043344145867204E-2,3.397854176557568E-2,-3.1043344145867204E-2,3.397854176557568E-2,null,"Deg",3.4504448199028981E-2,0.69900727416595609,4.9362073148951302E-2,0.96086475323928,-1.3761493419322841,1.4451582383303423,-1.3761493419322841,1.4451582383303423]
[78.400000000000006,1.17,1,67,44,95,9,1,4.4000000000000004,0]
[75.900000000000006,1.133,1,67,42,95,20,1,5.5,0]
[24,1.044,0,23,32,85,1,0,4.5999999999999996,1]
[23.3,1.012,0,23,41,70,4,0,4,0]
[24.1,1.0489999999999999,0,23,24,90,2,0,6.3,0]
[27.5,0.88700000000000001,0,31,52,80,7,0,3.9,0,null,"t-Test: Two-Sample Assuming Equal Variances"]
[27.1,0.875,0,31,25,95,4,0,5.6,0]
[27.7,0.89500000000000002,0,31,26,80,2,0,4.9000000000000004,1,null,null,"Variable 1","Variable 2"]
[40.799999999999997,1.0189999999999999,0,40,44,90,4,0,5.7,0,null,"Mean",1.0668399999999998,1.04836]
[43.9,1.097,0,40,35,80,7,0,3.9,1,null,"Variance",4.3016399999999998E-3,6.4809899999999998E-3]
[41,1.0249999999999999,0,40,25,80,5,0,4.3,0,null,"Observations",25,25]
[48.7,1.014,0,48,36,90,16,0,5.7,1,null,"Pooled Variance",5.3913150000000007E-3]
[49.4,1.0289999999999999,0,48,45,90,18,0,4.3,0,null,"Hypothesized Mean Difference",0]
[64.400000000000006,1.1299999999999999,0,57,34,85,8,0,5.7,0,null,"df",48]
[64.5,1.1319999999999999,0,57,42,100,16,0,5.5,1,null,"t Stat",0.88983527837444776]
[58.9,1.0329999999999999,0,57,52,95,22,0,4.5,0,null,"P(T<=t) one-tail",0.18899628704919752]
[57.9,1.016,0,57,35,90,9,0,5.5,1,null,"t Critical one-tail",1.6772241961243386]
[59,1.0349999999999999,0,57,45,95,11,0,4.5,0,null,"P(T<=t) two-tail",0.37799257409839504]
[63.3,1.111,0,57,45,90,16,0,5.2,1,null,"t Critical two-tail",2.0106347576242314]
[56.8,0.996,0,57,39,75,20,0,3.9,1]
[58,1.0169999999999999,0,57,37,95,5,0,5.5,1]
[62.4,1.0940000000000001,0,57,41,95,21,0,6.6,0]
[63.8,1.1200000000000001,0,57,38,80,12,0,4.5999999999999996,0]
[79,1.179,0,67,36,70,12,0,4.5,1]
[77,1.149,0,67,49,100,10,0,4,1]
[74.8,1.1160000000000001,0,67,43,95,13,0,6.3,1]
[76,1.135,0,67,52,95,5,0,5.4,0]

{"sheet":"Sheet2","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}