Instructions:Please use this worksheet to complete Step 1 of the Individual Analysis Project (the project instructions and dataset are provided on Blackboard. This worksheet is due by 11:59pm on October 31st. Please submit using the link provided on Blackboard.
1.Descriptive Statistics:
Mean Median Mode Standard Deviation
Customer Satisfaction 3.50
3.00
3.00
0.70
Intent to Leave 2.86
3.00
3.00
0.88
Team Player 2.86
3.00
3.00
0.93
Satisfaction with Paid Time Off 2.69
3.00
3.00
0.72
Employee Age 34.33
34.50
35.00
8.50
Employee Gender 0.47
0.00
0.00
0.50
2. How many individuals completed the survey? 256
3. The company as a whole (all 100 locations) has an average age of 43 years old. How does the age composition of the sample compare to the age composition of the company?
The average age composition of the sample is 34 years old. The average age is 9 years younger than the average age of the company as a whole. It appears that the sample may not accurately represent the population as a whole.
4. The company as a whole (all 100 locations) is 31% female. How does the gender composition of the sample (the 256 individuals in the dataset) compare to the gender composition of the company?
Female is higher than the company’s average. While the sample is 47% female, the company as a whole is only 31% female. This suggests that the gender composition of the sample is not representative of the company as a whole.
5. Why is it important to consider how the age and gender composition of the sample compares to the age and gender composition of the company as a whole?
Because the sample doesn’t represent the company as a whole.Its best to have realistic information to determine a good analysis.Its important to consider how the attributes of the sample compare to the attritubes of the company (population) because differences between the sample and population could influence our results. Since we base our recommendations on these results. It is vital that the results be as generalizable as possible to the overall population.
EmployeeID CustomerSatisfaction IntentLeave TeamPlayer SatisfactionTimeOff EmployeeAge EmployeeGender
1 5 2 3 2 39 1
2 5 3 3 1 41 1
3 4 4 2 2 24 0
4 4 3 2 2 28 0
5 3 2 3 3 24 1
6 3 3 3 2 45 1
7 3 2 3 1 27 0
8 4 2 3 2 39 0
9 4 2 4 3 32 0
10 4 2 3 2 27 1
11 3 3 4 3 46 1
12 3 2 2 2 34 1
13 2 3 2 3 25 1
14 3 4 2 2 35 1
15 3 3 4 2 35 0
16 4 5 3 3 36 1
17 4 2 3 3 40 0
18 3 2 2 2 33 0
19 2 3 2 2 42 0
20 4 2 1 3 29 0
21 5 2 3 2 31 0
22 4 1 3 4 50 1
23 4 3 2 2 34 0
24 5 4 3 4 45 0
25 3 4 2 2 50 0
26 4 2 2 2 36 0
27 5 2 4 2 23 0
28 4 2 4 2 41 0
29 3 3 2 2 29 0
30 5 2 4 2 35 0
31 3 3 5 3 22 0
32 4 2 3 3 42 0
33 4 3 3 2 35 0
34 4 4 2 2 43 0
35 4 3 3 3 31 0
36 3 3 3 3 53 0
37 4 4 5 2 40 0
38 4 5 4 2 29 1
39 3 1 4 2 43 0
40 3 3 3 2 30 1
41 4 3 3 3 27 1
42 4 4 3 2 26 0
43 3 2 2 3 33 1
44 3 3 2 3 31 0
45 4 4 4 3 36 1
46 4 3 4 2 27 0
47 3 3 2 2 33 0
48 3 3 3 2 42 0
49 3 3 3 2 43 0
50 4 3 3 2 44 0
51 4 2 4 2 35 0
52 3 3 2 3 43 0
53 3 3 3 3 35 1
54 3 2 2 2 57 1
55 4 3 3 2 32 1
56 3 4 3 2 35 0
57 4 4 2 3 41 0
58 4 3 2 3 36 0
59 3 3 2 3 34 0
60 3 2 2 3 46 0
61 3 1 4 3 21 0
62 3 2 3 3 29 0
63 3 3 1 3 36 1
64 3 4 3 3 27 0
65 3 4 4 2 29 0
66 3 3 3 3 35 0
67 5 3 3 3 44 0
68 5 3 3 2 37 0
69 2 2 3 2 43 1
70 4 4 3 3 34 1
71 3 3 2 3 53 0
72 3 1 1 4 33 1
73 3 4 3 3 31 0
74 3 3 3 3 37 1
75 4 3 2 2 35 0
76 3 3 3 2 30 1
77 3 2 4 3 37 1
78 4 3 2 3 27 1
79 3 2 3 3 32 0
80 3 4 4 3 41 1
81 4 2 3 2 20 1
82 4 3 3 2 33 1
83 4 3 1 3 32 1
84 2 4 2 3 33 0
85 3 3 2 2 44 0
86 4 3 2 2 41 0
87 4 2 2 4 39 0
88 5 3 3 2 34 1
89 3 3 4 2 35 1
90 2 3 4 2 31 1
91 4 4 3 1 31 0
92 4 3 3 1 34 1
93 4 2 3 3 27 1
94 3 3 3 2 32 0
95 3 2 2 2 35 0
96 3 3 3 3 40 0
97 3 2 4 2 38 0
98 3 4 4 3 35 0
99 3 2 4 3 24 1
100 3 4 2 3 41 0
101 3 2 3 3 31 0
102 3 2 3 3 35 1
103 2 2 2 2 30 1
104 3 2 3 3 43 0
105 3 3 2 2 41 0
106 3 2 4 4 56 1
107 3 3 2 2 24 0
108 4 4 3 2 36 0
109 2 4 3 3 30 1
110 3 2 3 2 24 1
111 4 3 2 2 26 1
112 2 4 3 2 46 0
113 3 2 3 3 32 1
114 4 2 2 3 36 1
115 3 5 2 2 21 1
116 4 4 4 3 33 0
117 4 3 3 3 35 0
118 3 4 4 3 41 0
119 4 3 5 2 45 0
120 3 3 3 3 36 0
121 4 3 3 3 25 0
122 3 4 5 2 37 1
123 4 4 4 3 41 0
124 4 4 3 3 29 1
125 3 2 3 2 40 0
126 3 2 3 3 45 1
127 4 2 3 3 42 1
128 3 1 2 3 41 1
129 4 2 3 3 27 1
130 4 5 4 2 31 1
131 3 2 4 3 39 0
132 2 3 2 3 36 1
133 4 4 2 3 37 1
134 3 3 4 2 27 1
135 3 4 4 3 26 1
136 2 2 2 1 36 1
137 3 3 3 1 34 1
138 3 3 2 3 31 1
139 5 2 3 2 36 1
140 3 2 2 2 32 0
141 3 4 4 3 45 1
142 4 2 2 3 36 0
143 2 4 3 3 38 1
144 4 4 5 3 25 1
145 5 2 3 3 26 1
146 3 2 2 3 31 1
147 4 3 3 4 28 1
148 3 2 4 3 31 1
149 3 3 2 3 34 0
150 4 3 5 3 39 0
151 4 4 3 3 31 1
152 5 2 2 4 47 0
153 3 2 3 3 45 0
154 3 4 4 2 32 0
155 4 4 3 2 29 0
156 3 2 3 3 34 1
157 4 3 2 3 41 1
158 3 3 3 3 35 0
159 4 2 4 3 42 1
160 3 4 3 2 33 0
161 4 3 3 3 33 0
162 3 2 4 2 34 0
163 4 3 3 3 40 1
164 4 4 4 3 23 1
165 4 3 3 2 21 1
166 5 3 3 2 32 0
167 4 2 3 3 46 1
168 3 1 2 3 29 0
169 3 4 4 3 38 0
170 4 3 3 3 40 0
171 3 4 3 2 28 0
172 3 3 3 3 37 0
173 4 4 3 4 37 1
174 3 2 5 4 40 0
175 3 3 2 3 35 0
176 4 2 4 3 41 1
177 3 2 2 4 51 1
178 4 4 3 2 21 1
179 3 3 3 2 43 1
180 4 3 3 3 38 1
181 4 3 3 3 36 1
182 3 4 4 3 31 0
183 4 3 3 3 37 1
184 3 3 2 2 21 1
185 3 3 3 3 25 1
186 3 5 4 2 45 0
187 3 3 3 3 32 1
188 3 1 4 3 34 1
189 4 3 4 4 48 1
190 4 3 3 3 50 1
191 4 2 4 4 45 0
192 3 3 3 3 40 0
193 3 3 3 2 34 0
194 5 2 3 2 35 0
195 4 2 2 3 33 1
196 4 2 3 2 31 1
197 4 1 3 3 37 1
198 4 2 2 2 40 0
199 3 4 3 3 31 1
200 4 3 4 2 36 0
201 4 3 3 2 33 1
202 3 4 4 2 32 0
203 3 2 3 5 53 0
204 3 3 3 2 35 0
205 4 3 3 2 32 1
206 4 4 3 3 33 0
207 5 3 3 2 35 0
208 4 2 3 3 36 0
209 4 2 4 3 33 1
210 4 4 3 3 30 1
211 3 4 4 3 36 1
212 3 4 1 3 28 0
213 4 2 1 3 28 1
214 3 2 2 3 39 0
215 3 2 2 2 29 0
216 4 4 4 2 24 0
217 2 2 2 3 37 0
218 4 4 1 3 44 1
219 4 3 2 3 37 1
220 4 4 4 2 35 0
221 4 3 3 3 18 0
222 5 3 3 2 23 0
223 4 2 3 3 33 0
224 4 3 4 3 44 0
225 4 3 3 3 16 1
226 3 2 4 3 25 0
227 3 2 1 5 17 1
228 4 2 1 5 53 1
229 3 1 2 3 21 1
230 3 2 2 3 16 1
231 4 4 4 5 40 1
232 2 3 2 3 47 1
233 4 3 1 3 23 0
234 4 4 2 3 58 0
235 4 2 4 2 19 1
236 3 3 1 3 16 0
237 4 3 1 3 19 0
238 4 3 3 3 16 1
239 3 2 4 3 25 0
240 3 2 1 5 17 1
241 4 2 1 5 53 1
242 3 1 2 3 21 1
243 3 2 2 3 16 1
244 4 4 4 5 40 1
245 2 3 2 3 47 1
246 4 3 1 3 23 0
247 4 4 2 3 58 0
248 4 2 4 2 19 1
249 3 3 1 3 16 0
250 4 3 1 3 19 0
251 4 4 3 3 30 1
252 3 4 4 3 36 1
253 3 4 1 3 28 0
254 4 2 1 3 28 1
255 3 2 2 3 39 0
256 3 2 2 2 29 0
MEAN 3.50 2.86 2.86 2.69 34.33 0.47
MEDIAN 3.00 3.00 3.00 3.00 34.50 0.00
MODE 3.00 3.00 3.00 3.00 35.00 0.00
STDEV 0.70 0.88 0.93 0.72 8.50 0.50