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:
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 |
The data here (data204.dat) is the LOS in months and wages for 60 women who work in Indiana banks. Wages are yearly tota...
We assume that our wages will increase as we gain experience and become more valuable to our employers. Wages also increase because of inflation. By examining a sample of employees at a given point in time, we can look at part of the picture. How does length of service (LOS) relate to wages? The data here (data393.dat) is the LOS in months and wages for 60 women who work in Indiana banks. Wages are yearly total income divided by the...
We assume that our wages will increase as we gain experience and become more valuable to our employers. Wages also increase because of inflation. By examining a sample of employees at a given point in time, we can look at part of the picture. How does length of service (LOS) relate to wages? The data here (data81.dat) is the LOS in months and wages for 60 women who work in Indiana banks. Wages are yearly total income divided by the...
We assume that our wages will increase as we gain experience and become more valuable to our employers. Wages also increase because of inflation. By examining a sample of employees at a given point in time, we can look at part of the picture. How does length of service (LOS) relate to wages? The data here (data238.dat) is the LOS in months and wages for 60 women who work in Indiana banks. Wages are yearly total income divided by the...
We assume that our wages will increase as we gain experience and become more valuable to our employers. Wages also increase because of inflation. By examining a sample of employees at a given point in time, we can look at part of the picture. How does length of service (LOS) relate to wages? The data here (data303.dat) is the LOS in months and wages for 60 women who work in Indiana banks. Wages are yearly total income divided by the...
We assume that our wages will increase as we gain experience and become more valuable to our employers. Wages also increase because of inflation. By examining a sample of employees at a given point in time, we can look at part of the picture. How does length of service (LOS) relate to wages? The data here (data126.dat) is the LOS in months and wages for 60 women who work in Indiana banks. Wages are yearly total income divided by the...
We assume that our wages will increase as we gain experience and become more valuable to our employers. Wages also increase because of inflation. By examining a sample of employees at a given point in time, we can look at part of the picture. How does length of service (LOS) relate to wages? The data here (data197.dat) is the LOS in months and wages for 60 women who work in Indiana banks. Wages are yearly total income divided by the...
We assume that our wages will increase as we gain experience and become more valuable to our employers. Wages also increase because of inflation. By examining a sample of employees at a given point in time, we can look at part of the picture. How does length of service (LOS) relate to wages? The data here (data17.dat) is the LOS in months and wages for 60 women who work in Indiana banks. Wages are yearly total income divided by the...
worker wages los size 1 52.6227 21 Large 2 85.865 96 Small 3 61.7581 65 Small 4 43.6764 173 Small 5 58.733 50 Large 6 38.0873 35 Small 7 38.3659 58 Large 8 59.8889 217 Large 9 62.6846 73 Large 10 43.9656 165 Small 11 69.9273 35 Large 12 52.5823 56 Small 13 46.2363 55 Small 14 40.7646 42 Large 15 45.2743 97 Large 16 52.1446 63 Large 17 40.6916 110 Large 18 73.5716 84 Small 19 71.0977 71 Large...
We assume that our wages will increase as we gain experience and become more valuable to our employers. Wages also increase because of inflation. By examining a sample of employees at a given point in time, we can look at part of the picture. How does length of service (LOS) relate to wages? The data here (data45.dat) is the LOS in months and wages for 60 women who work in Indiana banks. Wages are yearly total income divided by the...
We assume that our wages will increase as we gain experience and become more valuable to our employers. Wages also increase because of inflation. By examining a sample of employees at a given point in time, we can look at part of the picture. How does length of service (LOS) relate to wages? The data here (data117.dat) is the LOS in months and wages for 60 women who work in Indiana banks. Wages are yearly total income divided by the...