Question: Introduction Your instructor will provide you with a data file that includes data on five variables: SALES represents the number sales made this week. CALLS
Introduction
Your instructor will provide you with a data file that includes data on five variables:
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 AnalysisPreparation
- Open the files for the course project and the data set.
- For each of the five variables, process, organize, present and summarize the data. Analyze each variable by itself using graphical and numerical techniques of summarization. Use Excel as much as possible, explaining what the results reveal. Some of the following graphs may be helpful: stem-leaf diagram, frequency/relative frequency table, histogram, boxplot, dotplot, pie chart, bar graph. Caution: not all of these are appropriate for each of these variables, nor are they all necessary. More is not necessarily better. 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). Once again, use Excel as appropriate, and explain what the results mean.
- Analyze the connections or relationships between the variables. There are ten possible pairings of two variables. Use graphical as well as numerical summary measures. Explain the results of the analysis. Be sure to consider all 10 pairings. Some variables show clear relationships, while others do not.
Report Requirements
- From the variable analysis above, provide the analysis and interpretation for three individual variables. This would include no more than 1 graph for each, one or two measures of central tendency and variability (as appropriate), the shapes of the distributions for quantitative variables, and two or three sentences of interpretation.
- For the 10 pairings, identify and report only on three of the pairings, again using graphical and numerical summary (as appropriate), with interpretations. Please note that at least one pairing must include a qualitative variable and at least one pairing must not include a qualitative variable.
- Prepare the report in Microsoft Word, integrating graphs and tables with text explanations and interpretations. Be sure to include graphical and numerical back up for the explanations and interpretations. Be selective in what is included in the report to meet the requirements of the report without extraneous information.
- All DeVry University policies are in effect, including the plagiarism policy.
- Project Part A report is due by the end of Week 2.
- Project Part A is worth 100 total points. See grading rubric below.
Submission: The report, including all relevant graphs and numerical analysis along with interpretations
Format for report:
- Brief Introduction
- Discuss 1st individual variable, using graphical, numerical summary and interpretation
- Discuss 2nd individual variable, using graphical, numerical summary and interpretation
- Discuss 3rd individual variable, using graphical, numerical summary and interpretation
- Discuss 1st pairing of variables, using graphical, numerical summary and interpretation
- Discuss 2nd pairing of variables, using graphical, numerical summary and interpretation
- Discuss 3rd pairing of variables, using graphical, numerical summary and interpretation
- Conclusion
Part A: Grading Rubric
Category Points % Description Three individual variables - 12 points each 36 36 Graphical analysis, numerical analysis (when appropriate), and interpretation Three relationships - 15 points each 45 45 Graphical analysis, numerical analysis (when appropriate), and interpretation Communication skills 19 19 Writing, grammar, clarity, logic, cohesiveness, adherence to the above format Total100100A quality paper will meet or exceed all of the above requirements.ales
(Y)
Calls
(X1)
Time
(X2)
Years
(X3)
Type
48
171
13.0
5
ONLINE
32
139
16.9
4
NONE
44
165
15.7
3
ONLINE
47
186
13.5
3
ONLINE
41
180
14.0
2
ONLINE
46
184
12.7
5
ONLINE
32
120
19.9
3
NONE
46
172
14.7
3
GROUP
42
161
13.2
1
GROUP
33
143
15.4
3
NONE
42
181
11.5
4
ONLINE
50
148
16.0
0
NONE
42
140
17.5
2
GROUP
41
198
13.2
2
ONLINE
41
149
17.3
0
ONLINE
44
168
11.0
5
ONLINE
36
121
18.0
2
NONE
47
149
15.8
1
GROUP
38
135
18.5
1
GROUP
21
185
18.9
2
ONLINE
67
155
17.9
1
NONE
45
149
13.5
1
ONLINE
52
193
13.7
5
ONLINE
37
159
18.1
0
NONE
33
152
15.0
3
GROUP
31
170
14.3
4
GROUP
44
192
16.7
1
GROUP
44
165
12.4
3
ONLINE
39
150
15.3
3
GROUP
43
174
12.7
2
ONLINE
42
168
16.4
0
ONLINE
49
178
15.1
3
ONLINE
41
164
17.8
3
GROUP
40
191
19.0
5
ONLINE
37
132
10.0
0
NONE
36
140
15.7
1
NONE
46
171
14.9
5
ONLINE
41
170
12.3
0
ONLINE
49
153
19.0
3
GROUP
42
154
14.3
2
GROUP
37
142
13.9
3
NONE
37
130
16.9
2
NONE
21
177
17.0
0
ONLINE
39
160
14.3
4
NONE
44
134
19.4
5
GROUP
49
131
14.6
1
GROUP
35
130
19.4
4
NONE
46
183
15.4
4
ONLINE
43
169
14.0
5
GROUP
41
155
16.0
2
ONLINE
48
182
13.0
2
ONLINE
39
140
12.4
1
NONE
40
157
15.4
1
ONLINE
48
167
14.8
3
ONLINE
50
144
15.8
2
NONE
44
168
12.4
2
GROUP
43
175
13.6
5
GROUP
33
150
14.9
2
GROUP
32
155
17.9
1
GROUP
46
163
16.6
2
ONLINE
48
162
14.5
4
GROUP
56
189
15.0
3
ONLINE
44
153
15.3
2
ONLINE
34
158
14.2
3
ONLINE
43
160
10.9
4
ONLINE
33
173
17.5
1
ONLINE
49
178
18.3
2
GROUP
50
189
14.3
1
ONLINE
52
184
11.4
4
ONLINE
45
174
13.6
2
ONLINE
48
188
13.6
0
ONLINE
35
149
15.6
1
GROUP
44
159
14.6
2
GROUP
44
160
14.8
2
ONLINE
67
166
18.9
1
GROUP
51
178
16.5
1
ONLINE
41
178
13.4
2
ONLINE
40
176
12.6
1
ONLINE
45
138
15.3
2
NONE
41
159
18.8
2
ONLINE
40
145
14.7
2
NONE
47
151
16.6
2
GROUP
48
186
14.2
1
ONLINE
42
194
13.6
2
ONLINE
41
152
14.5
4
GROUP
29
145
19.0
2
NONE
48
188
11.3
2
ONLINE
33
139
19.3
3
GROUP
48
201
12.5
1
ONLINE
45
156
13.2
3
GROUP
36
131
18.5
2
NONE
43
161
17.3
3
ONLINE
42
152
14.6
1
ONLINE
49
178
16.4
2
ONLINE
50
157
15.9
3
GROUP
42
154
15.3
1
GROUP
44
156
20.0
0
ONLINE
45
170
14.2
1
ONLINE
48
170
17.4
5
ONLINE
39
144
17.7
3
NON
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
Study Help