Question

The data here (data204.dat) is the LOS in months and wages for 60 women who work in Indiana banks. Wages are yearly total income divided by the number of weeks worked. We have multiplied wages by a constant for reasons of confidentiality. (a) Plot wages versus LOS. Consider the relationship and whether or not linear regression might be appropriate. (Do this on paper. Your instructor may ask you to turn in this graph.) (b) Find the least-squares line. Summarize the significance test for the slope. What do you conclude? Wages = 50.54 Correct: Your answer is correct. + 0.052 Correct: Your answer is correct. LOS t = Incorrect: Your answer is incorrect. P = 0.2917 Correct: Your answer is correct. (c) State carefully what the slope tells you about the relationship between wages and length of service.

los 83 57 72 56 49 66 122 163 20 55 52 130 148 54 51 94 111 76 100 47 90 36 90 73 20 68 25 23 24 115 25 74 32 115 91 75 17 60 42 92 54 60 64 16 24 44 128 47 28 101 109 88 92 87 138 83 61 28 52 113

wages

72.0307
40.3992
52.3045
74.6124
39.851
55.647
62.9563
75.0588
75.4979
40.6147
45.8697
79.7908
48.9902
88.3223
60.8146
55.5607
64.1616
57.8368
43.5545
40.2911
38.9536
60.7334
43.2482
52.115
44.9973
45.2266
43.8769
45.6814
40.83
57.361
75.2132
44.0945
63.4918
56.3357
69.8723
83.9476
43.562
37.6027
37.6366
56.6385
49.6549
72.0122
49.2824
45.6189
61.1109
44.2107
48.1307
51.12
41.1498
47.6714
43.769
44.9421
54.0075
90.7208
50.1256
38.9778
55.0703
59.2961
51.0465
39.1219

Answer 1

The data here (data204.dat) is the LOS in months and wages for 60 women who work in Indiana banks. Wages are yearly total income divided by the number of weeks worked. We have multiplied wages by a constant for reasons of confidentiality.

(a) Plot wages versus LOS. Consider the relationship and whether or not linear regression might be appropriate. (Do this on paper. Your instructor may ask you to turn in this graph.)

The plot shows that linear regression may not be appropriate.

(b) Find the least-squares line. Summarize the significance test for the slope. What do you conclude? Wages = 50.54 Correct: Your answer is correct. + 0.052 Correct: Your answer is correct.

LOS t = 1.064

. P = 0.2917 Correct: Your answer is correct.

(c) State carefully what the slope tells you about the relationship between wages and length of service.

There is no significant relationship between wages and length of service.

When length of service increases by 1, wages increases by 0.052 units.

Excel Addon Megastat used.

Menu used: correlation/Regression ---- Regression Analysis

Regression Analysis
	r²	0.019	n	60
	r	0.138	k	1
	Std. Error of Estimate	13.587	Dep. Var.	Wages
Regression output						confidence interval
variables		coefficients	std. error	t (df=58)	p-value	95% lower	95% upper
Intercept	a =	50.544	3.866	13.073	6.16E-19	42.805	58.283
los	b =	0.052	0.049	1.064	.2917	-0.046	0.151
ANOVA table
Source	SS	df	MS	F	p-value
Regression	209.040	1	209.040	1.13	.2917
Residual	10,707.897	58	184.619
Total	10,916.938	59