Question
Activity I - Your firm is interested in learning more about how its salaries relate to its employees' tenure with the firm. It has collected
Activity I - Your firm is interested in learning more about how its salaries relate to its employees' tenure with the firm. It has collected the following data for 25 of its employees.
EMPLOYEE NUMBER | TENURE (YEARS) | SALARY ($) |
1 | 15 | 53,908 |
2 | 32 | 78,230 |
3 | 14 | 55,164 |
4 | 20 | 57,647 |
5 | 25 | 63,111 |
6 | 14 | 54,991 |
7 | 28 | 74,571 |
8 | 30 | 73,189 |
9 | 28 | 71,859 |
10 | 17 | 55,978 |
11 | 14 | 61,676 |
12 | 6 | 44,865 |
13 | 21 | 64,676 |
14 | 11 | 59,101 |
15 | 14 | 58,441 |
16 | 32 | 81,964 |
17 | 29 | 76,373 |
18 | 33 | 82,860 |
19 | 27 | 70,019 |
20 | 16 | 58,474 |
21 | 26 | 80,074 |
22 | 3 | 45,594 |
23 | 14 | 63,676 |
24 | 9 | 68,444 |
25 | 14 | 70,306 |
Plot these data points, and describe using regression how salary relates to firm tenure for this group.
Activity II - The data attached contains information on customers' ratings of your product (CustRate), on a scale of 1 to 100, along with demographic information. The demographic information includes: income (Inc), age (Age), education (Educ), and marital status (Marr). The last variable equals one if the respondent is married and zero otherwise. Assume the data-generating process can be written as:
CustRatei=+1Inci+2Agei+3Educi+4Marri+Ui.
- Test the hypothesis that income has no impact on customer rating, using a confidence level of 95%. Be sure to provide the reasoning behind your result.
- Test the hypothesis that 2=0.05, using a confidence level of 90%. Be sure to provide the reasoning behind your result.
- Build a 95% confidence interval for the impact of education on customer rating. Be sure to provide the reasoning for your result.
- Build a 95% confidence interval for the impact of being married on customer rating. Be sure to provide the reasoning for your result.
- Predict the change in customer rating if a customer's income increases by $10,000, with no change in age, education, or marital status.
CustRate | Inc | Age | Educ | Marr |
28 | 58402 | 43 | 18 | 0 |
79 | 89893 | 83 | 17 | 1 |
35 | 58034 | 51 | 13 | 1 |
35 | 62843 | 40 | 13 | 0 |
36 | 80854 | 56 | 13 | 0 |
41 | 86470 | 65 | 18 | 1 |
43 | 74518 | 40 | 19 | 1 |
35 | 55958 | 44 | 14 | 0 |
18 | 50279 | 41 | 12 | 1 |
46 | 102499 | 57 | 20 | 0 |
17 | 62816 | 43 | 18 | 0 |
36 | 79303 | 76 | 16 | 0 |
83 | 106960 | 77 | 16 | 0 |
56 | 89134 | 76 | 15 | 0 |
8 | 39297 | 35 | 14 | 1 |
58 | 93130 | 55 | 19 | 1 |
48 | 70350 | 55 | 16 | 0 |
58 | 92032 | 67 | 18 | 1 |
49 | 78536 | 76 | 11 | 1 |
35 | 55760 | 46 | 13 | 1 |
45 | 48631 | 45 | 13 | 0 |
50 | 48622 | 38 | 14 | 1 |
86 | 102460 | 80 | 16 | 0 |
32 | 38090 | 32 | 11 | 0 |
44 | 60977 | 44 | 16 | 1 |
49 | 65962 | 39 | 19 | 1 |
44 | 47447 | 37 | 10 | 1 |
16 | 52479 | 47 | 16 | 1 |
45 | 51238 | 55 | 10 | 0 |
50 | 79284 | 82 | 11 | 1 |
52 | 73283 | 41 | 14 | 0 |
53 | 78156 | 64 | 13 | 0 |
26 | 42190 | 42 | 10 | 0 |
58 | 90846 | 82 | 15 | 1 |
75 | 88087 | 71 | 12 | 0 |
54 | 77947 | 79 | 12 | 1 |
46 | 73839 | 72 | 10 | 1 |
67 | 79504 | 70 | 17 | 1 |
79 | 103551 | 71 | 20 | 0 |
55 | 81651 | 73 | 11 | 1 |
38 | 76964 | 73 | 11 | 0 |
41 | 92002 | 77 | 16 | 1 |
56 | 92630 | 65 | 17 | 0 |
38 | 81637 | 62 | 13 | 0 |
41 | 59079 | 60 | 10 | 0 |
47 | 53481 | 33 | 13 | 0 |
33 | 61981 | 31 | 18 | 0 |
22 | 47444 | 34 | 11 | 0 |
45 | 62345 | 61 | 10 | 1 |
59 | 90636 | 71 | 11 | 0 |
39 | 66924 | 47 | 16 | 0 |
6 | 43472 | 34 | 14 | 0 |
36 | 63223 | 41 | 19 | 0 |
83 | 102024 | 83 | 16 | 1 |
60 | 91859 | 50 | 20 | 1 |
50 | 51800 | 32 | 17 | 1 |
68 | 74147 | 46 | 20 | 0 |
41 | 49001 | 40 | 15 | 1 |
21 | 63189 | 52 | 12 | 0 |
45 | 65693 | 40 | 20 | 1 |
59 | 82952 | 81 | 14 | 0 |
23 | 65459 | 37 | 19 | 0 |
47 | 73623 | 67 | 11 | 1 |
46 | 58703 | 53 | 10 | 0 |
39 | 75724 | 52 | 14 | 0 |
69 | 89721 | 79 | 17 | 1 |
84 | 92167 | 69 | 18 | 1 |
50 | 84185 | 75 | 15 | 0 |
45 | 62827 | 41 | 16 | 0 |
66 | 73275 | 54 | 15 | 0 |
81 | 97682 | 73 | 11 | 0 |
68 | 91359 | 84 | 10 | 1 |
68 | 104446 | 81 | 16 | 1 |
15 | 32026 | 38 | 10 | 0 |
24 | 63546 | 49 | 16 | 1 |
37 | 61179 | 38 | 17 | 1 |
50 | 71387 | 56 | 19 | 0 |
64 | 100364 | 71 | 18 | 1 |
24 | 37724 | 28 | 10 | 1 |
68 | 84308 | 60 | 12 | 1 |
38 | 61819 | 50 | 16 | 1 |
20 | 34068 | 29 | 13 | 1 |
28 | 54646 | 30 | 17 | 1 |
57 | 84758 | 59 | 12 | 1 |
41 | 50313 | 30 | 19 | 0 |
62 | 73319 | 64 | 12 | 0 |
19 | 52824 | 36 | 15 | 0 |
59 | 96290 | 63 | 20 | 1 |
59 | 94847 | 82 | 10 | 0 |
73 | 106430 | 83 | 20 | 1 |
68 | 94519 | 72 | 17 | 1 |
60 | 79568 | 44 | 20 | 0 |
33 | 70571 | 65 | 13 | 1 |
42 | 77195 | 56 | 18 | 0 |
61 | 94754 | 67 | 13 | 0 |
57 | 63482 | 60 | 12 | 1 |
36 | 54621 | 40 | 18 | 1 |
58 | 98958 | 83 | 16 | 1 |
17 | 62514 | 41 | 19 | 1 |
58 | 94638 | 66 | 12 | 1 |
59 | 77590 | 65 | 16 | 1 |
56 | 62972 | 52 | 18 | 1 |
34 | 75715 | 50 | 18 | 1 |
50 | 66851 | 48 | 14 | 0 |
26 | 52452 | 48 | 10 | 1 |
61 | 120595 | 76 | 16 | 0 |
55 | 81983 | 79 | 13 | 1 |
41 | 66972 | 52 | 15 | 0 |
28 | 38026 | 35 | 17 | 1 |
40 | 93236 | 76 | 18 | 0 |
39 | 98003 | 75 | 17 | 1 |
26 | 43014 | 42 | 12 | 1 |
34 | 57142 | 41 | 13 | 0 |
55 | 89995 | 74 | 18 | 1 |
32 | 68975 | 50 | 16 | 0 |
53 | 76995 | 78 | 15 | 0 |
31 | 41771 | 32 | 13 | 1 |
75 | 107119 | 82 | 17 | 0 |
36 | 79423 | 60 | 15 | 1 |
33 | 52455 | 37 | 11 | 0 |
43 | 74186 | 53 | 18 | 1 |
50 | 88230 | 76 | 13 | 1 |
49 | 77681 | 68 | 14 | 0 |
53 | 81907 | 60 | 20 | 0 |
32 | 74105 | 53 | 11 | 1 |
71 | 103295 | 82 | 17 | 1 |
43 | 62365 | 41 | 20 | 0 |
24 | 50388 | 34 | 17 | 0 |
29 | 73826 | 43 | 18 | 0 |
50 | 96867 | 76 | 20 | 0 |
66 | 81473 | 59 | 15 | 0 |
46 | 84895 | 71 | 18 | 1 |
14 | 50703 | 29 | 17 | 1 |
22 | 50514 | 35 | 19 | 1 |
65 | 91143 | 76 | 17 | 1 |
33 | 60094 | 51 | 11 | 1 |
34 | 72363 | 40 | 18 | 0 |
55 | 61569 | 65 | 10 | 1 |
61 | 111907 | 80 | 13 | 0 |
19 | 50860 | 39 | 13 | 0 |
69 | 81328 | 63 | 20 | 0 |
55 | 76263 | 43 | 18 | 0 |
39 | 52869 | 34 | 17 | 1 |
76 | 92165 | 79 | 12 | 1 |
41 | 60211 | 55 | 14 | 1 |
74 | 88320 | 74 | 19 | 0 |
49 | 73401 | 71 | 12 | 0 |
29 | 41098 | 28 | 18 | 1 |
45 | 46355 | 52 | 10 | 0 |
64 | 59752 | 52 | 10 | 1 |
52 | 86557 | 62 | 13 | 1 |
25 | 50342 | 46 | 14 | 0 |
61 | 107203 | 74 | 18 | 0 |
53 | 50377 | 31 | 14 | 1 |
24 | 72087 | 57 | 12 | 1 |
27 | 68073 | 45 | 17 | 1 |
39 | 68824 | 62 | 10 | 1 |
61 | 84953 | 42 | 20 | 1 |
76 | 88289 | 77 | 15 | 0 |
42 | 54169 | 42 | 20 | 1 |
40 | 47445 | 50 | 12 | 0 |
64 | 79659 | 67 | 14 | 0 |
59 | 87149 | 53 | 20 | 0 |
58 | 85160 | 65 | 16 | 0 |
86 | 115642 | 79 | 19 | 0 |
30 | 26671 | 30 | 10 | 0 |
65 | 99436 | 83 | 14 | 1 |
57 | 99677 | 80 | 17 | 0 |
50 | 75679 | 45 | 20 | 1 |
64 | 86013 | 76 | 11 | 1 |
49 | 66922 | 49 | 20 | 0 |
51 | 95313 | 62 | 15 | 0 |
60 | 102551 | 69 | 19 | 0 |
47 | 71334 | 34 | 19 | 0 |
67 | 68982 | 48 | 16 | 0 |
70 | 89113 | 74 | 15 | 0 |
68 | 73545 | 61 | 14 | 1 |
49 | 92819 | 79 | 11 | 1 |
49 | 78207 | 84 | 13 | 0 |
46 | 83274 | 62 | 18 | 0 |
33 | 31363 | 28 | 11 | 0 |
33 | 57397 | 48 | 14 | 0 |
45 | 95774 | 81 | 19 | 0 |
37 | 57384 | 44 | 19 | 1 |
42 | 63775 | 63 | 10 | 1 |
80 | 109560 | 85 | 17 | 0 |
72 | 98326 | 60 | 20 | 1 |
54 | 73643 | 64 | 15 | 1 |
48 | 89103 | 59 | 16 | 0 |
58 | 94844 | 56 | 17 | 0 |
30 | 65985 | 39 | 17 | 1 |
56 | 77875 | 76 | 10 | 0 |
58 | 69793 | 67 | 13 | 0 |
57 | 74239 | 42 | 20 | 0 |
55 | 100675 | 70 | 19 | 1 |
55 | 83572 | 56 | 17 | 1 |
77 | 99332 | 63 | 20 | 1 |
44 | 73084 | 59 | 14 | 0 |
73 | 108769 | 82 | 15 | 1 |
41 | 59581 | 45 | 12 | 0 |
54 | 70716 | 69 | 13 | 0 |
56 | 94821 | 78 | 14 | 0 |
33 | 62336 | 37 | 14 | 0 |
62 | 95083 | 69 | 20 | 0 |
43 | 66276 | 36 | 19 | 1 |
70 | 108664 | 79 | 18 | 0 |
56 | 90094 | 62 | 16 | 1 |
62 | 93481 | 78 | 20 | 0 |
42 | 83496 | 62 | 19 | 0 |
39 | 62503 | 54 | 11 | 1 |
66 | 84253 | 83 | 17 | 0 |
79 | 105591 | 76 | 19 | 0 |
36 | 67780 | 57 | 13 | 1 |
80 | 124010 | 83 | 19 | 0 |
59 | 74465 | 63 | 17 | 0 |
45 | 50544 | 31 | 18 | 0 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started