Problem 3 : The variable “HERE” takes values 0 or 1, where “HERE = 1” is for tho

Question

Problem 3: The variable “HERE” takes values 0 or 1, where “HERE =1” is for those who are still employed by the company and “HERE =0” is for those who left the company. Is there evidence to suggest that employees who left the company received significantly different percentage of 3-month evaluations than those who are still with the company?

1) Perform the necessary statistical analysis.

2) State your conclusion in the context of the problem.

DATA:

SCORE LAG EMP@EOY POS@EOY DEPT GRADE EDUC EMP@EVAL POS@EVAL TYPE JOB HERE 184 -7 7.29 7.29 40 8 13 7.12 7.12 1 2 1 155 9 2.92 2.12 55 13 13 1.82 1.02 1 4 1 132 21 0.77 0.77 55 13 16 0.31 0.31 0 4 1 118 -7 0.8 0.8 55 4 13 0.23 0.23 0 1 1 102 15 13.78 4.7 41 2 12 13.16 4.07 1 1 1 178 4 9.65 9.65 64 3 12 9.02 9.01 1 1 1 115 2 2.19 2.19 41 9 16 2.15 2.15 1 2 1 128 13 0.5 0.5 62 8 16 0.29 0.29 0 2 1 99 35 12.76 2.73 62 2 12 12.1 2.07 1 1 1 133 -2 4.49 0.51 71 11 16 4.23 0.25 0 3 1 158 12 5.14 2.04 55 10 12 4.13 1.03 1 3 1 125 0 6.94 6.94 62 8 16 6 6 1 2 1 113 2 1.88 0.39 73 8 14 1.75 0.26 0 2 1 121 -12 6.35 0.28 73 17 18 6.29 0.22 0 4 1 172 10 3.78 3.78 72 8 16 3.03 3.03 1 2 1 159 49 11.7 11.7 64 8 14 11.67 11.67 1 2 1 135 14 6.1 3.17 55 4 13 5.83 2.9 1 1 1 155 7 7.59 5.29 55 10 18 7.32 5.02 1 3 1 128 22 0.56 0.56 41 2 13 0.31 0.31 0 1 1 127 62 3.42 3.42 73 10 16 3.17 3.17 1 3 1 134 45 0.31 0.31 62 8 16 0.37 0.37 0 2 1 126 13 0.77 0.44 55 2 12 0.29 0.05 0 1 1 131 16 4.24 4.24 41 10 18 4.05 4.05 1 3 1 136 -2 0.96 0.96 55 2 12 0.24 0.24 0 1 1 155 8 0.37 0.37 41 11 16 0.27 0.27 0 3 1 125 17 0.42 0.42 40 13 16 0.3 0.3 0 4 1 128 21 0.39 0.39 72 8 14 0.31 0.31 0 2 1 164 3 4.87 4.87 64 8 14 4.01 4.01 1 2 1 90 27 0.74 0.74 72 2 12 0.32 0.32 0 1 1 146 -5 4.28 2.79 73 11 14 3.47 1.99 1 3 1 159 19 0.92 0.28 55 14 20 0.95 0.3 0 4 1 125 12 4.8 4.8 74 8 16 4.04 4.04 1 2 1 129 36 3.42 3.42 62 8 14 3.1 3.1 1 2 1 149 4 2.61 1.28 63 8 16 2.34 1.01 1 2 1 182 -7 7.34 7.34 72 10 16 6.98 6.98 1 3 1 172 42 3.76 2.34 62 10 14 3.79 2.38 1 3 1 137 -11 6.52 0.28 71 17 16 6.47 0.22 0 4 1 171 30 3.16 2.75 62 3 12 2.5 2.08 1 1 1 144 34 1.27 0.73 55 3 12 1.09 0.55 1 1 1 163 28 1.39 1.39 61 8 14 1.09 1.08 1 2 1 165 4 6.89 5.12 74 8 16 6.75 4.98 1 2 1 128 11 6.52 5.39 72 3 12 6.17 5.03 1 1 1 133 6 1.29 1.29 63 8 14 1.02 1.02 1 2 1 162 -5 4.95 4.95 64 8 14 3.99 3.99 1 2 1 119 8 0.53 0.53 65 8 16 0.27 0.27 0 2 1 131 34 0.37 0.37 74 4 12 0.35 0.35 0 1 1 149 62 2.42 0.74 55 9 12 2.1 0.42 0 2 1 167 24 0.37 0.37 41 2 12 0.32 0.32 0 1 1 136 13 1.31 1.31 63 3 14 1.04 1.04 1 1 1 150 21 0.56 0.56 41 2 14 0.31 0.31 0 1 1 135 8 0.81 0.81 73 10 14 0.27 0.27 0 3 1 176 64 17.24 17.24 62 3 12 17.19 17.19 1 1 1 115 19 0.33 0.33 72 8 18 0.3 0.3 0 2 1 155 0 5.86 5.86 65 3 12 5 5 1 1 1 127 -12 1.17 1.17 62 3 13 0.97 0.97 1 1 1 61 37 4.72 0.28 62 6 14 4.79 0.35 0 1 1 115 15 3.16 0.86 55 2 13 2.58 0.28 0 1 1 121 23 1.69 0.71 55 2 14 1.29 0.31 0 1 1 160 -14 1.42 1.42 72 8 14 0.96 0.96 1 2 1 162 -1 12.58 3.99 72 13 14 11.59 3 1 4 1 155 4 2.86 2.86 72 8 14 2.01 2.01 1 2 1 124 -2 5.32 0.51 73 10 16 5.05 0.25 0 3 1 141 12 1.42 0.74 73 5 14 0.96 0.28 0 1 1 124 13 1.24 1.24 61 8 14 1.04 1.04 1 2 1 131 79 4.76 4.76 63 8 14 4.22 4.22 1 2 1 111 9 4.35 2.69 73 3 12 3.69 2.02 1 1 1 135 10 4.01 0.56 62 10 14 3.7 0.28 0 3 1 164 33 7.64 7.64 64 8 14 7.6 7.6 1 2 1 127 5 0.46 0.46 62 8 14 0.27 0.27 0 2 1 111 3 4.91 0.51 73 10 16 4.67 0.26 0 3 1 171 31 8.1 6.5 61 3 12 7.68 6.09 1 1 1 123 27 2.73 2.73 74 8 14 2.07 2.07 1 2 1 128 15 0.94 0.94 62 8 16 0.29 0.29 0 2 1 128 -6 0.63 0.63 62 8 16 0.24 0.24 0 2 1 132 -12 0.88 0.88 70 6 16 0.21 0.21 1 1 1 173 34 8.73 8.73 63 8 14 8.1 8.1 1 2 1 126 36 0.9 0.54 72 3 12 0.72 0.35 0 1 1 120 8 2.96 1.13 62 8 14 2.02 0.2 0 2 1 121 30 0.96 0.96 65 3 12 0.33 0.33 0 1 1 111 12 0.92 0.92 74 8 14 0.28 0.28 0 2 1 129 58 0.96 0.96 61 3 14 0.41 0.41 0 1 1 132 9 2.52 2.52 71 10 16 2.07 2.07 1 3 1 75 10 10.9 6.5 55 10 16 10.92 6.53 1 3 1 157 6 12.76 12.76 73 4 12 12.02 12.02 1 1 1 155 20 7.39 3.12 73 13 16 7.33 3.05 1 4 1 152 -2 3.28 3.28 62 8 14 2.99 2.99 1 2 1 121 5 5.81 0.92 62 3 12 5.15 0.26 0 1 1 112 18 0.94 0.94 62 8 14 1.3 1.3 1 2 1 170 4 3.42 3.42 62 8 16 3.01 3.01 1 2 1 159 13 4.8 4.8 65 8 16 4.04 4.04 1 2 1 124 17 0.65 0.65 72 8 14 0.3 0.3 0 2 1 174 -7 3.44 3.44 62 8 16 2.98 2.98 1 2 1 120 9 2.44 1.13 74 13 16 1.58 0.28 0 4 1 139 0 1.96 0.89 55 10 14 1.31 0.24 0 3 1 139 0 2.76 2.76 72 2 12 2 2 1 1 1 160 -3 1.69 1.35 41 14 18 1.33 0.99 1 4 1 133 -3 5.35 5.35 72 8 14 4.99 4.99 1 2 1 147 14 7.56 7.56 64 8 16 7.56 7.56 1 2 1 126 15 0.52 0.52 61 8 18 0.29 0.29 0 2 1 112 -3 6.78 0.28 64 13 18 6.74 0.24 0 4 1 140 16 0.96 0.74 72 3 13 0.52 0.29 0 1 1 124 60 1.88 0.39 62 10 14 1.91 0.42 0 3 1 104 10 1.99 1.99 72 2 14 1.03 1.03 1 1 1 126 30 2.78 0.27 73 8 14 2.84 0.33 0 2 1 140 20 5.05 0.91 41 4 12 4.43 0.3 0 1 1 106 7 8.15 0.75 71 9 12 7.67 0.27 0 2 1 138 7 0.73 0.73 72 4 12 0.27 0.27 0 1 1 135 5 2.23 0.81 55 3 12 1.68 0.27 0 1 1 105 35 0.28 0.28 72 8 16 0.35 0.35 0 2 1 143 2 14.27 14.27 73 11 16 14.03 14.03 1 3 1 131 27 2.94 2.69 55 10 18 1.32 1.07 1 3 1 108 -10 11.28 0.28 74 17 14 11.22 0.22 0 4 1 171 -7 5.33 2.08 72 10 14 4.38 1.13 1 3 1 152 22 2.67 2.23 55 5 13 2.5 2.06 1 1 1 171 15 5.89 5.22 64 3 12 5.72 5.04 1 1 1 152 8 1.96 1.96 62 2 12 1.02 1.02 1 1 1 115 69 0.46 0.32 72 3 12 0.58 0.44 0 1 1 80 8 0.48 0.48 41 4 12 0.27 0.27 0 1 1 115 15 2.13 0.36 41 5 16 2.06 0.29 0 1 1 134 -8 7.35 0.28 61 13 14 7.3 0.23 0 4 1 132 10 1.69 0.74 55 3 13 1.23 0.28 0 1 1 137 19 12.7 0.28 55 17 18 12.72 0.3 0 4 1 129 12 2.7 0.94 62 3 13 2.047 0.28 0 1 1 154 11 16.85 13.51 41 14 14 16.59 13.25 1 4 1 113 2 5.9 0.98 71 13 14 5.18 0.25 0 4 1 104 5 1.99 1.99 55 2 12 1.01 1.01 1 1 0 131 -4 1.1 1.1 72 8 14 0.24 0.24 0 2 0 117 34 0.81 0.81 62 8 14 0.35 0.35 0 2 0 171 -7 18.15 13.79 65 13 14 17.34 12.99 1 4 0 90 9 1.19 1.19 74 8 14 0.28 0.28 0 2 0 123 6 1.25 1.25 74 8 14 0.27 0.27 0 2 0 101 -3 8.25 4.49 62 13 16 7.76 3.99 1 4 0 40 87 0.96 0.96 62 8 18 0.48 0.48 0 2 0 117 6 2.8 2.8 74 8 14 2.02 2.02 1 2 0 132 9 1.27 1.27 74 8 14 1.02 1.02 1 2 0 159 -14 1.84 1.84 72 2 18 0.96 0.96 1 1 0 105 26 11.38 10.13 55 4 12 10.82 9.57 1 1 0 106 6 2.05 0.64 73 8 14 1.68 0.27 0 2 0 116 10 0.58 0.58 41 3 12 0.28 0.28 0 1 0 171 21 2.74 2.74 62 8 16 2.06 2.06 1 2 0 143 35 7.52 5.32 65 8 16 7.33 5.12 1 2 0 90 3 0.65 0.65 74 8 14 0.26 0.26 0 2 0 115 24 0.92 0.92 41 3 12 0.31 0.31 0 1 0 117 10 0.42 0.42 71 8 16 0.28 0.28 0 2 0

Explanation / Answer

Copy the data into Excel and save it as .csv file.

data1=read.csv(file.choose(),header=T) #import the Excel file
attach(data1)
t.test(EMP.EVAL.[HERE==1],EMP.EVAL.[HERE==0]) #Two-sample t-test

Welch Two Sample t-test

data: EMP.EVAL.[HERE == 1] and EMP.EVAL.[HERE == 0]
t = 0.6816, df = 21.762, p-value = 0.5027
alternative hypothesis: true difference in means is not equal to 0
95 percent confidence interval:
-1.558932 3.083886
sample estimates:
mean of x mean of y
3.644056 2.881579

Since p-value > 0.05, we accept the null hypothesis at 5% level and conclude that there is no significant difference in the evaluation between the people who are still in the company and the people who left the company.

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.