You are a statistician hired by a company owner for data analysis of employee records. For your first assignment, the owner wants you to find and compare data for full-time employees in the sales department and full-time employees in the advertising department. All directions are on the assignment and MUST be followed. You will use the excel sheet to answer the questions. There is a total of three questions. All questions must be answered thoughtfully, thoroughly, and fully. All work must be 100% original.
hs_al2_l4_s2_09_01_groupcomparisons_ga_a11y.docx
company_data.xls
Unformatted Attachment Preview
Math | Graded Assignment | Honors Project: Group Comparisons
Name:
Date:
Graded Assignment
Honors Project: Group Comparisons
You are a statistician hired by a company owner for data analysis of employee records. For your first assignment,
the owner wants you to find and compare data for full-time employees in the sales department and full-time
employees in the advertising department.
You will find the necessary employee data in the Excel spreadsheet titled Company Data. Download and open the
spreadsheet, which lists data for all full-time employees. Employees 001 through 014 are all the employees in the
sales department and employees 045 through 062 are all the employees in the advertising department.
Total score: ____ of 50 points
(Score for Question 1: ___ of 10 points)
1. Find and compare the mean salaries and mean ages of the employees in the sales and advertising
departments. Explain to the owner how these values could be misleading.
Answer:
© 2015 K12 Inc. All rights reserved.
Copying or distributing without K12’s written consent is prohibited.
Page 1 of 3
Math | Graded Assignment | Honors Project: Group Comparisons
(Score for Question 2: ___ of 20 points)
2. Find and compare the standard deviations of the salaries and ages of the employees in the sales and
advertising departments. Tell how you would you explain the meaning of these values when you present them
to the owner.
Answer:
© 2015 K12 Inc. All rights reserved.
Copying or distributing without K12’s written consent is prohibited.
Page 2 of 3
Math | Graded Assignment | Honors Project: Group Comparisons
(Score for Question 3: ___ of 20 points)
3. Draw side-by-side box-and-whisker plots for the salaries of the employees for both departments (using one
number line). Draw another pair of side-by-side box-and-whisker plots for the ages of the employees for both
departments (using one number line). Tell how you would you interpret these box-and-whisker plots when you
present them to the owner.
Answer:
© 2015 K12 Inc. All rights reserved.
Copying or distributing without K12’s written consent is prohibited.
Page 3 of 3
Employee
Number
Annual Salary
(rouned to nearest
thousands of dollars)
Age
001
002
003
004
005
006
007
008
009
010
011
012
013
014
015
016
017
018
019
020
021
022
023
024
025
026
027
028
029
030
031
032
033
034
035
036
037
038
039
040
041
042
043
044
045
046
047
48
35
26
31
27
52
55
63
18
74
35
61
28
42
76
35
38
64
71
26
53
65
47
41
102
38
35
84
41
26
73
62
35
39
62
49
104
62
54
19
28
64
36
39
53
89
26
35
27
24
42
25
31
41
34
32
46
29
44
29
35
39
27
41
63
52
31
38
46
39
27
58
32
33
47
36
28
65
53
40
32
39
44
48
59
46
62
22
39
35
29
36
66
33
048
049
050
051
052
053
054
055
056
057
058
059
060
061
062
063
064
065
066
067
068
069
070
071
072
073
074
075
076
077
078
079
080
081
082
083
084
085
086
087
088
089
090
091
092
093
094
095
096
097
098
099
53
43
75
35
39
29
26
45
39
31
30
70
42
37
54
85
42
36
91
25
28
53
65
78
42
68
44
41
50
46
48
75
29
53
72
17
28
38
30
48
43
27
46
36
48
62
31
42
48
61
22
124
45
50
62
27
27
41
33
54
44
26
31
45
33
42
63
51
70
42
53
38
28
35
49
47
54
44
40
39
62
30
35
38
26
34
61
19
30
34
26
41
35
26
54
28
32
50
27
31
35
38
26
47
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
27
53
86
60
47
41
37
27
36
45
80
45
70
53
25
29
16
30
36
38
42
48
51
38
39
43
61
75
38
42
55
72
39
28
51
43
49
67
25
37
39
46
41
50
93
53
82
47
36
38
51
42
30
28
62
57
56
30
32
31
36
32
42
33
51
35
30
28
20
23
27
33
36
35
42
43
28
36
44
58
41
36
37
49
34
23
39
34
37
62
23
28
26
29
30
37
46
43
56
53
31
36
44
39
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
40
24
68
38
36
34
49
65
68
62
53
67
23
51
40
43
49
57
61
26
54
35
32
38
39
24
51
21
51
34
30
25
31
38
52
49
43
50
31
36
32
28
44
61
57
24
63
28
31
32
26
28
…
Purchase answer to see full
attachment
Recent Comments