BUS 308 WEEK 1

Data

ID	Salary	Compa	Midpoint	Age	Performance Rating	Service	Gender	Raise	Degree	Gender1	Gr
1	56.5	0.992	57	34	85	8	0	5.7	0	M	E	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	28.3	0.913	31	52	80	7	0	3.9	0	M	B	Note: to simplfy the analysis, we will assume that jobs within each grade comprise equal work.
3	34	1.097	31	30	75	5	1	3.6	1	F	B
4	64.5	1.132	57	42	100	16	0	5.5	1	M	E	The column labels in the table mean:
5	46.6	0.971	48	36	90	16	0	5.7	1	M	D	ID – Employee sample number	Salary – Salary in thousands
6	75.6	1.129	67	36	70	12	0	4.5	1	M	F	Age – Age in years	Performance Rating – Appraisal rating (employee evaluation score)
7	41.6	1.040	40	32	100	8	1	5.7	1	F	C	Service – Years of service (rounded)	Gender – 0 = male, 1 = female
8	24.6	1.070	23	32	90	9	1	5.8	1	F	A	Midpoint – salary grade midpoint	Raise – percent of last raise
9	74.6	1.114	67	49	100	10	0	4	1	M	F	Grade – job/pay grade	Degree (0= BS\BA 1 = MS)
10	24	1.044	23	30	80	7	1	4.7	1	F	A	Gender1 (Male or Female)	Compa – salary divided by midpoint
11	24.3	1.055	23	41	100	19	1	4.8	1	F	A
12	57.9	1.015	57	52	95	22	0	4.5	0	M	E
13	41.9	1.047	40	30	100	2	1	4.7	0	F	C
14	24.5	1.066	23	32	90	12	1	6	1	F	A
15	23.1	1.005	23	32	80	8	1	4.9	1	F	A
16	41.1	1.027	40	44	90	4	0	5.7	0	M	C
17	71.8	1.259	57	27	55	3	1	3	1	F	E
18	34.2	1.104	31	31	80	11	1	5.6	0	F	B
19	23.8	1.036	23	32	85	1	0	4.6	1	M	A
20	34.3	1.106	31	44	70	16	1	4.8	0	F	B
21	78.5	1.171	67	43	95	13	0	6.3	1	M	F
22	54.9	1.143	48	48	65	6	1	3.8	1	F	D
23	23.3	1.015	23	36	65	6	1	3.3	0	F	A
24	55.9	1.165	48	30	75	9	1	3.8	0	F	D
25	23.7	1.029	23	41	70	4	0	4	0	M	A
26	23.8	1.036	23	22	95	2	1	6.2	0	F	A
27	38.7	0.967	40	35	80	7	0	3.9	1	M	C
28	76.7	1.145	67	44	95	9	1	4.4	0	F	F
29	75.9	1.133	67	52	95	5	0	5.4	0	M	F
30	48.5	1.011	48	45	90	18	0	4.3	0	M	D
31	22.3	0.970	23	29	60	4	1	3.9	1	F	A
32	27	0.871	31	25	95	4	0	5.6	0	M	B
33	61.4	1.077	57	35	90	9	0	5.5	1	M	E
34	27.8	0.898	31	26	80	2	0	4.9	1	M	B
35	22.8	0.992	23	23	90	4	1	5.3	0	F	A
36	24.7	1.075	23	27	75	3	1	4.3	0	F	A
37	23.3	1.014	23	22	95	2	1	6.2	0	F	A
38	56.8	0.997	57	45	95	11	0	4.5	0	M	E
39	36.1	1.165	31	27	90	6	1	5.5	0	F	B
40	24	1.045	23	24	90	2	0	6.3	0	M	A
41	47.3	1.182	40	25	80	5	0	4.3	0	M	C
42	21.9	0.950	23	32	100	8	1	5.7	1	F	A
43	75.6	1.128	67	42	95	20	1	5.5	0	F	F
44	57.2	1.003	57	45	90	16	0	5.2	1	M	E
45	53.1	1.107	48	36	95	8	1	5.2	1	F	D
46	58.1	1.019	57	39	75	20	0	3.9	1	M	E
47	61	1.071	57	37	95	5	0	5.5	1	M	E
48	64.6	1.134	57	34	90	11	1	5.3	1	F	E
49	66.3	1.163	57	41	95	21	0	6.6	0	M	E
50	57.5	1.008	57	38	80	12	0	4.6	0	M	E

Sheet1

Sal	Compa	G	Mid	Age	EES	SR	G	Raise	Deg	SUMMARY OUTPUT									SUMMARY OUTPUT
24	1.045	1	23	32	90	9	1	5.8	1
24.2	1.053	1	23	30	80	7	1	4.7	1	Regression Statistics									Regression Statistics
23.4	1.018	1	23	41	100	19	1	4.8	1	Multiple R	0.7050179484								Multiple R	0.9931286935
23.4	1.017	1	23	32	90	12	1	6	1	R Square	0.4970503076								R Square	0.9863046018
22.6	0.983	1	23	32	80	8	1	4.9	1	Adjusted R Square	0.4132253589								Adjusted R Square	0.9840220355
22.9	0.995	1	23	36	65	6	1	3.3	0	Standard Error	0.0561252686								Standard Error	2.4352822665
23.1	1.003	1	23	22	95	2	1	6.2	0	Observations	50								Observations	50
23.3	1.011	1	23	29	60	4	1	3.9	1
22.7	0.985	1	23	23	90	4	1	5.3	0	ANOVA									ANOVA
23.5	1.023	1	23	27	75	3	1	4.3	0		df	SS	MS	F	Significance F					df	SS	MS	F	Significance F
23	1.002	1	23	22	95	2	1	6.2	0	Regression	7	0.1307500775	0.0186785825	5.9296225662	0.0000782906				Regression	7	17938.424611863	2562.632087409	432.1033638177	5.29906273684337E-37
24	1.042	1	23	32	100	8	1	5.7	1	Residual	42	0.1323019225	0.0031500458						Residual	42	249.085188137	5.9305997175
35.5	1.145	1	31	30	75	5	1	3.6	1	Total	49	0.263052							Total	49	18187.5098
34.7	1.119	1	31	31	80	11	1	5.6	0
35.5	1.146	1	31	44	70	16	1	4.8	0		Coefficients	Standard Error	t Stat	P-value	Lower 95%	Upper 95%	Lower 95.0%	Upper 95.0%		Coefficients	Standard Error	t Stat	P-value	Lower 95%	Upper 95%	Lower 95.0%	Upper 95.0%
35.2	1.136	1	31	27	90	6	1	5.5	0	Intercept	0.9486238772	0.0817167716	11.6086803119	0	0.7837127557	1.1135349987	0.7837127557	1.1135349987	Intercept	-4.8714544587	3.54570071	-1.3739045839	0.1767599037	-12.0269681853	2.2840592678	-12.0269681853	2.2840592678
40.4	1.01	1	40	32	100	8	1	5.7	1	Mid	0.0034995027	0.0006492568	5.3900133356	0.0000029767	0.0021892495	0.0048097559	0.0021892495	0.0048097559	Mid	1.2284155048	0.0281713308	43.6051641629	1.32019333894083E-36	1.1715634576	1.2852675521	1.1715634576	1.2852675521
42.7	1.068	1	40	30	100	2	1	4.7	0	Age	0.0005527738	0.0014459446	0.3822925256	0.7041721007	-0.0023652605	0.0034708081	-0.0023652605	0.0034708081	Age	0.0368279425	0.0627397124	0.5869957178	0.5603489282	-0.0897859231	0.1634418081	-0.0897859231	0.1634418081
53.4	1.112	1	48	48	65	6	1	3.8	1	EES	-0.0018462553	0.0010252155	-1.8008461371	0.0789105539	-0.0039152239	0.0002227133	-0.0039152239	0.0002227133	EES	-0.0821579785	0.0444842245	-1.8469014451	0.0718147225	-0.171930778	0.007614821	-0.171930778	0.007614821
51.5	1.072	1	48	30	75	9	1	3.8	0	SR	-0.0004182288	0.0018278101	-0.2288141345	0.820123898	-0.004106899	0.0032704414	-0.004106899	0.0032704414	SR	-0.0778484529	0.079308905	-0.9815852701	0.3319249969	-0.2379003029	0.0822033971	-0.2379003029	0.0822033971
49.8	1.037	1	48	36	95	8	1	5.2	1	G	0.0646649961	0.0183396697	3.5259629624	0.001034866	0.0276540443	0.101675948	0.0276540443	0.101675948	G	2.9145083112	0.7957605113	3.6625445343	0.000693549	1.3085985836	4.5204180389	1.3085985836	4.5204180389
68.3	1.198	1	57	27	55	3	1	3	1	Raise	0.0146549564	0.0139088976	1.0536389608	0.2980722322	-0.0134143354	0.0427242483	-0.0134143354	0.0427242483	Raise	0.6763294824	0.6035087689	1.1206622295	0.2687988764	-0.5416005215	1.8942594864	-0.5416005215	1.8942594864
65.4	1.148	1	57	34	90	11	1	5.3	1	Deg	0.0014675988	0.0161098249	0.0910996125	0.9278465471	-0.0310433441	0.0339785418	-0.0310433441	0.0339785418	Deg	0.0345044482	0.6990072742	0.0493620731	0.9608647532	-1.3761493419	1.4451582383	-1.3761493419	1.4451582383
78.4	1.17	1	67	44	95	9	1	4.4	0
75.9	1.133	1	67	42	95	20	1	5.5	0
24	1.044	0	23	32	85	1	0	4.6	1
23.3	1.012	0	23	41	70	4	0	4	0
24.1	1.049	0	23	24	90	2	0	6.3	0
27.5	0.887	0	31	52	80	7	0	3.9	0	t-Test: Two-Sample Assuming Equal Variances
27.1	0.875	0	31	25	95	4	0	5.6	0
27.7	0.895	0	31	26	80	2	0	4.9	1		Variable 1	Variable 2
40.8	1.019	0	40	44	90	4	0	5.7	0	Mean	1.06684	1.04836
43.9	1.097	0	40	35	80	7	0	3.9	1	Variance	0.00430164	0.00648099
41	1.025	0	40	25	80	5	0	4.3	0	Observations	25	25
48.7	1.014	0	48	36	90	16	0	5.7	1	Pooled Variance	0.005391315
49.4	1.029	0	48	45	90	18	0	4.3	0	Hypothesized Mean Difference	0
64.4	1.13	0	57	34	85	8	0	5.7	0	df	48
64.5	1.132	0	57	42	100	16	0	5.5	1	t Stat	0.8898352784
58.9	1.033	0	57	52	95	22	0	4.5	0	P(T<=t) one-tail	0.188996287
57.9	1.016	0	57	35	90	9	0	5.5	1	t Critical one-tail	1.6772241961
59	1.035	0	57	45	95	11	0	4.5	0	P(T<=t) two-tail	0.3779925741
63.3	1.111	0	57	45	90	16	0	5.2	1	t Critical two-tail	2.0106347576
56.8	0.996	0	57	39	75	20	0	3.9	1
58	1.017	0	57	37	95	5	0	5.5	1
62.4	1.094	0	57	41	95	21	0	6.6	0
63.8	1.12	0	57	38	80	12	0	4.6	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.116	0	67	43	95	13	0	6.3	1
76	1.135	0	67	52	95	5	0	5.4	0

Continue to order Get a quote