Question

Question 22 (3.45 points) years Xi | bonus Yi | XiYi | Xi^2 4 | 5.7 | 22.8 | 16 2 | 3.5 | 7 | 4 7.4 | 10.1 | 74.74 | 54.76 5 | 9 | 45 | 25 2 | 2.7 | 5.4 | 4 12 | 12 | 144 | 144 Question 22. Are years of service and annual bonuses related? The annual bonuses of 6 randomly selected employees (measured in "thousands of dollars") along their respective years of service for the company. Suppose we estimate a linear regression using the Ordinary Least Squares technique of the form: Bonus_i = b0 + b1(years_i) where the subscript i indicates the i^th employee Using excel to complete this problem, what is the sample coefficient of correlation, or r, for this data? (hint: we covered this in the bedroom regression lectures and in the bonus football video lecture) a) years Xi | bonus Yi years Xi | 1 | 0.929136 bonus Yi | 0.929136 | 1 b) years Xi | bonus Yi years Xi | 1 | 1 bonus Yi | 1 | 1 c) years Xi | bonus Yi years Xi | 1 | 0.14631 bonus Yi | 0.14631 | 1 d) years Xi | bonus Yi years Xi | 1 | 0.0214 bonus Yi | 0.0214 | 1

          Question 22 (3.45 points)

years Xi | bonus Yi | XiYi | Xi^2
4 | 5.7 | 22.8 | 16
2 | 3.5 | 7 | 4
7.4 | 10.1 | 74.74 | 54.76
5 | 9 | 45 | 25
2 | 2.7 | 5.4 | 4
12 | 12 | 144 | 144

Question 22. Are years of service and annual bonuses related? The annual bonuses of 6 randomly selected employees (measured in "thousands of dollars") along their respective years of service for the company. Suppose we estimate a linear regression using the Ordinary Least Squares technique of the form:
Bonus_i = b0 + b1(years_i)
where the subscript i indicates the i^th employee
Using excel to complete this problem, what is the sample coefficient of correlation, or r, for this data?
(hint: we covered this in the bedroom regression lectures and in the bonus football video lecture)

a)
years Xi | bonus Yi
years Xi | 1 | 0.929136
bonus Yi | 0.929136 | 1

b)
years Xi | bonus Yi
years Xi | 1 | 1
bonus Yi | 1 | 1

c)
years Xi | bonus Yi
years Xi | 1 | 0.14631
bonus Yi | 0.14631 | 1

d)
years Xi | bonus Yi
years Xi | 1 | 0.0214
bonus Yi | 0.0214 | 1

Question 22 (3.45 points)

years Xi | bonus Yi | XiYi | Xi^2
4 | 5.7 | 22.8 | 16
2 | 3.5 | 7 | 4
7.4 | 10.1 | 74.74 | 54.76
5 | 9 | 45 | 25
2 | 2.7 | 5.4 | 4
12 | 12 | 144 | 144

Question 22. Are years of service and annual bonuses related? The annual bonuses of 6 randomly selected employees (measured in "thousands of dollars") along their respective years of service for the company. Suppose we estimate a linear regression using the Ordinary Least Squares technique of the form:
Bonusi = b0 + b1(yearsi)
where the subscript i indicates the i^th employee
Using excel to complete this problem, what is the sample coefficient of correlation, or r, for this data?
(hint: we covered this in the bedroom regression lectures and in the bonus football video lecture)

a)
years Xi | bonus Yi
years Xi | 1 | 0.929136
bonus Yi | 0.929136 | 1

b)
years Xi | bonus Yi
years Xi | 1 | 1
bonus Yi | 1 | 1

c)
years Xi | bonus Yi
years Xi | 1 | 0.14631
bonus Yi | 0.14631 | 1

d)
years Xi | bonus Yi
years Xi | 1 | 0.0214
bonus Yi | 0.0214 | 1

Added by Robert J.

Question

Please give Ace some feedback