Part A: Exploratory Data Analysis, statistics homework help

Anonymous
timer Asked: May 15th, 2017
account_balance_wallet $20

Question Description

NEED AN EXCEL SPREAD SHEET DONE NOTHING ELSE- SEE ATTACHED EXCEL SHEET W/ DATA.

INSTRUCTIONS BELOW: THERE ARE FIVE VARIABLES TO COMPUTE PLEASE USE ONE OR TWO GRAPHS FOR EACH.

SALES represents the number sales made this week.

CALLS represents the number of sales calls made this week.
TIME represents the average time per call this week.
YEARS represents years of experience in the call center.

TYPE represents the type of training the employee received.

Part A: Exploratory Data Analysis

PREPARATION

  • For each of the five variables, process, organize, present. Use Excel to graph each one. Some of the following graphs may be helpful: stem-leaf diagram, frequency/relative frequency table, histogram, boxplot, dotplot, pie chart, bar graph. In addition be sure to find the appropriate measures of central tendency, the measures of dispersion, and the shapes of the distributions (for the quantitative variables) for the above data. Where appropriate, use the five number summary (the Min, Q1, Median, Q3, Max).

Unformatted Attachment Preview

Sales (Y) Calls (X1) Time (X2) Years (X3) 51 167 12,6 5 34 133 15,2 4 49 161 16,1 3 45 185 13,3 1 47 176 14,1 2 47 183 12,8 2 38 122 19,3 3 44 171 13,6 3 47 157 14,3 1 37 148 15,7 3 51 177 11,4 4 40 144 17,4 0 48 136 13,3 2 52 197 14 2 46 145 16,8 0 42 167 17,7 3 37 120 12 2 42 148 16,9 1 43 131 18,5 1 49 184 16,7 2 44 150 18,4 1 43 148 15,9 1 55 189 12 1 37 152 19,8 0 44 148 13,5 3 43 169 13,3 4 49 188 20,4 1 45 164 16,7 3 45 146 12 3 43 173 19,8 2 47 164 15,3 0 48 177 13,9 3 49 160 13,6 3 51 190 11,3 1 42 135 16,1 0 37 137 18,1 1 51 167 16,2 1 44 169 8,9 0 46 149 17,8 3 42 153 15,5 2 45 140 11 3 37 133 19,8 2 52 173 18,6 0 39 156 13,3 4 45 130 20,6 3 37 130 15,6 1 40 125 12,2 4 44 182 15,5 4 Type ONLINE GROUP NONE ONLINE ONLINE ONLINE GROUP GROUP GROUP GROUP NONE NONE ONLINE ONLINE ONLINE ONLINE NONE NONE NONE ONLINE NONE ONLINE ONLINE GROUP GROUP NONE NONE NONE GROUP ONLINE ONLINE ONLINE GROUP ONLINE NONE ONLINE ONLINE ONLINE NONE GROUP GROUP NONE ONLINE NONE GROUP GROUP NONE NONE 48 42 53 37 46 43 45 42 48 39 46 46 45 44 49 41 48 46 48 47 54 45 53 37 45 44 46 52 54 48 44 41 43 40 53 47 43 38 50 39 54 41 42 46 45 43 41 49 44 165 154 178 142 153 166 138 167 171 149 151 162 158 188 149 157 156 172 174 188 180 173 184 148 155 159 162 177 174 175 139 158 145 150 182 193 148 145 184 138 197 128 160 148 177 153 153 152 169 19,8 14,8 13,2 18,5 14,1 17,6 18,9 18 13 18,8 16 16,2 13,9 12,9 21,1 11,5 15,1 12,5 18,6 16,3 11,8 17,6 15,2 16,2 18,9 18,1 12,1 14,5 10,8 13,7 15,2 19,3 18,6 10,8 10,5 13,5 14,5 17,1 15,6 17,7 11,8 15,5 10,6 13,1 14,2 15,2 14,7 22,3 13,6 5 2 2 1 1 3 2 2 2 1 1 2 1 3 2 3 4 1 2 1 4 2 0 1 2 2 1 1 2 1 2 2 2 1 1 2 4 2 2 3 1 2 3 1 2 3 1 0 1 ONLINE ONLINE ONLINE NONE ONLINE ONLINE NONE NONE GROUP GROUP GROUP ONLINE ONLINE GROUP GROUP ONLINE ONLINE ONLINE GROUP NONE GROUP ONLINE ONLINE GROUP GROUP ONLINE GROUP ONLINE NONE ONLINE NONE ONLINE NONE GROUP ONLINE ONLINE ONLINE NONE ONLINE GROUP ONLINE NONE NONE GROUP GROUP GROUP GROUP ONLINE ONLINE 49 37 166 145 16,2 18 0 3 ONLINE NONE ...
Purchase answer to see full attachment

Tutor Answer

Selenica
School: Carnegie Mellon University

Hi there!So I went through all of the data, and I separated out every comparison possible. The tabs are labeled as such. You have all correlations possible, including bar charts, frequency charts/histograms, etc.Please take a look at it, and let me know what you think :)Thanks again,Selenica

Sales (Y)Calls (X1)Time (X2)
Years (X3) Type

51
34
49
45
47
47
38
44
47
37
51
40
48
52
46
42
37
42
43
49
44
43
55
37
44
43
49
45
45
43
47
48
49
51
42
37
51
44
46
42
45
37
52
39
45
37

167
133
161
185
176
183
122
171
157
148
177
144
136
197
145
167
120
148
131
184
150
148
189
152
148
169
188
164
146
173
164
177
160
190
135
137
167
169
149
153
140
133
173
156
130
130

12,6
15,2
16,1
13,3
14,1
12,8
19,3
13,6
14,3
15,7
11,4
17,4
13,3
14
16,8
17,7
12
16,9
18,5
16,7
18,4
15,9
12
19,8
13,5
13,3
20,4
16,7
12
19,8
15,3
13,9
13,6
11,3
16,1
18,1
16,2
8,9
17,8
15,5
11
19,8
18,6
13,3
20,6
15,6

5
4
3
1
2
2
3
3
1
3
4
0
2
2
0
3
2
1
1
2
1
1
1
0
3
4
1
3
3
2
0
3
3
1
0
1
1
0
3
2
3
2
0
4
3
1

ONLINE
GROUP
NONE
ONLINE
ONLINE
ONLINE
GROUP
GROUP
GROUP
GROUP
NONE
NONE
ONLINE
ONLINE
ONLINE
ONLINE
NONE
NONE
NONE
ONLINE
NONE
ONLINE
ONLINE
GROUP
GROUP
NONE
NONE
NONE
GROUP
ONLINE
ONLINE
ONLINE
GROUP
ONLINE
NONE
ONLINE
ONLINE
ONLINE
NONE
GROUP
GROUP
NONE
ONLINE
NONE
GROUP
GROUP

Dummy
1
2
0
1
1
1
2
2
2
2
0
0
1
1
1
1
0
0
0
1
0
1
1
2
2
0
0
0
2
1
1
1
2
1
0
1
1
1
0
2
2
0
1
0
2
2

40
44
48
42
53
37
46
43
45
42
48
39
46
46
45
44
49
41
48
46
48
47
54
45
53
37
45
44
46
52
54
48
44
41
43
40
53
47
43
38
50
39
54
41
41
42
46

125
182
165
154
178
142
153
166
138
167
171
149
151
162
158
188
149
157
156
172
174
188
180
173
184
148
155
159
162
177
174
175
139
158
145
150
182
193
148
145
184
138
197
155
128
160
148

12,2
15,5
19,8
14,8
13,2
18,5
14,1
17,6
18,9
18
13
18,8
16
16,2
13,9
12,9
21,1
11,5
15,1
12,5
18,6
16,3
11,8
17,6
15,2
16,2
18,9
18,1
12,1
14,5
10,8
13,7
15,2
19,3
18,6
10,8
10,5
13,5
14,5
17,1
15,6
17,7
11,8
13,6
15,5
10,6
13,1

4
4
5
2
2
1
1
3
2
2
2
1
1
2
1
3
2
3
4
1
2
1
4
2
0
1
2
2
1
1
2
1
2
2
2
1
1
2
4
2
2
3
1
3
2
3
1

NONE
NONE
ONLINE
ONLINE
ONLINE
NONE
ONLINE
ONLINE
NONE
NONE
GROUP
GROUP
GROUP
ONLINE
ONLINE
GROUP
GROUP
ONLINE
ONLINE
ONLINE
GROUP
NONE
GROUP
ONLINE
ONLINE
GROUP
GROUP
ONLINE
GROUP
ONLINE
NONE
ONLINE
NONE
ONLINE
NONE
GROUP
ONLINE
ONLINE
ONLINE
NONE
ONLINE
GROUP
ONLINE
GROUP
NONE
NONE
GROUP

0
0
1
1
1
0
1
1
0
0
2
2
2
1
1
2
2
1
1
1
2
0
2
1
1
2
2
1
2
1
0
1
0
1
0
2
1
1
1
0
1
2
1
2
0
0
2

45
43
41
49
44
49
37

177
153
153
152
169
166
145

14,2
15,2
14,7
22,3
13,6
...

flag Report DMCA
Review

Anonymous
awesome work thanks

Similar Questions
Related Tags

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors