Explanation in Youtube: https://www.youtube.com/watch?v=Pczs8tFxztU
Case Study 1 (20 marks) |
|
|
|
|
|
|
|
|
|
Consider
the table below. It shows three performance measures for 10 students. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Student |
Test score |
IQ |
Study hours |
|
|
|
|
|
|
|
1 |
100 |
125 |
30 |
|
|
|
|
|
|
|
2 |
95 |
104 |
40 |
|
|
|
|
|
|
|
3 |
92 |
110 |
25 |
|
|
|
|
|
|
|
4 |
90 |
105 |
20 |
|
|
|
|
|
|
|
5 |
85 |
100 |
20 |
|
|
|
|
|
|
|
6 |
80 |
100 |
20 |
|
|
|
|
|
|
|
7 |
78 |
95 |
15 |
|
|
|
|
|
|
|
8 |
75 |
95 |
10 |
|
|
|
|
|
|
|
9 |
72 |
85 |
0 |
|
|
|
|
|
|
|
10 |
65 |
90 |
5 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
In
this lesson, using data from the table, we are going to complete the
following tasks: |
|
|
|
|
|
1)
Develop a least-squares regression equation to predict test score, based on
(1) IQ and (2) the number of hours that the student studied. |
2)
Assess how well the regression equation predicts the test score, the
dependent variable. |
|
|
|
|
3)
Assess the contribution of each independent variable (i.e., IQ and study
hours) to the prediction. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Case Study 2 (20 Marks) |
|
|
|
|
|
A
nonprofit home healthcare agency has asked “a consultant” whether its CEO is
fairly |
paid
relative to the marketplace for similar agencies. The Agency has supplied
a |
|
database
to the consultant, who also has his own survey database of CEO pay. |
|
In
this case, the CEO’s rate is $79.50 per hour (or $165,360 per year). The
Agency’s |
revenue is $25M. Is the CEO fairly paid? The
survey of nonprofit home health- care |
agency
pay levels shows the pay levels in the table below. |
|
|
|
|
|
|
|
|
|
|
Base Pay |
Revenue |
|
|
|
|
|
151.81 |
76,328,000 |
|
|
|
|
|
148.29 |
57,000,000 |
|
|
|
|
|
101.65 |
51,000,000 |
|
|
|
|
|
100 |
50,897,721 |
|
|
|
|
|
95.59 |
45,493,200 |
|
|
|
|
|
91.35 |
32,506,801 |
|
|
|
|
|
88.95 |
26,987,146 |
|
|
|
|
|
79.5 |
25,000,000 |
|
|
|
|
|
78.76 |
24,587,000 |
|
|
|
|
|
69.75 |
21,500,000 |
|
|
|
|
|
68 |
17,609,573 |
|
|
|
|
|
65.9 |
15,214,178 |
|
|
|
|
|
58.53 |
14,675,724 |
|
|
|
|
|
57.69 |
13,504,173 |
|
|
|
|
|
57.52 |
13,126,413 |
|
|
|
|
|
55.91 |
12,830,000 |
|
|
|
|
|
52.88 |
12,296,908 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|