Question
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
Your instructor will provide you with a data file that includes data on five variables:
SALESrepresents the number sales made this week.
CALLSrepresents the number of sales calls made this week.
TIMErepresents the average time per call this week.
YEARSrepresents years of experience in the call center.
- TYPErepresents the type of training the employee received.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, and 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 10 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, whereas others do not.
Report Requirements
- From the variable analysis above, provide the analysis and interpretation forthree individual variables.This would include no more than one 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 onthree 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 the grading rubric below.
Submission: The report, including all relevant graphs and numerical analysis along with interpretationsFormat for report:
- Brief Introduction
- Discuss the first individual variable, using graphical, numerical summary and interpretation.
- Discuss the second individual variable, using graphical, numerical summary and interpretation.
- Discuss the third individual variable, using graphical, numerical summary and interpretation.
- Discuss the first pairing of variables, using graphical, numerical summary and interpretation.
- Discuss the second pairing of variables, using graphical, numerical summary and interpretation.
- Discuss the third pairing of variables, using graphical, numerical summary and interpretation.
- Conclusion
Sales
(Y)
Calls
(X1)
Time
(X2)
Years
(X3)
Type
48
168
12.3
5
ONLINE
36
131
16.4
4
NONE
46
162
15.7
3
NONE
47
183
13.0
3
ONLINE
44
177
15.3
3
ONLINE
49
181
12.4
2
ONLINE
35
123
19.0
3
NONE
46
169
14.8
3
GROUP
44
158
13.9
1
GROUP
39
146
15.4
3
GROUP
48
178
12.6
4
ONLINE
42
142
17.0
0
ONLINE
45
137
13.0
2
ONLINE
54
195
15.2
2
ONLINE
43
146
16.4
0
ONLINE
44
165
17.4
3
ONLINE
34
121
13.2
2
NONE
44
146
16.5
1
NONE
40
132
18.2
1
NONE
51
182
17.9
2
ONLINE
41
151
18.0
1
NONE
45
146
15.6
3
ONLINE
52
190
13.2
3
ONLINE
39
150
19.4
0
GROUP
41
149
13.2
3
GROUP
45
167
14.5
4
GROUP
46
189
20.0
1
GROUP
47
162
16.4
3
ONLINE
42
147
13.2
3
GROUP
45
171
19.4
2
ONLINE
44
165
15.0
0
ONLINE
50
175
15.1
3
ONLINE
46
161
13.2
3
GROUP
53
188
11.0
2
ONLINE
39
136
17.3
0
NONE
39
135
17.7
1
ONLINE
48
168
15.9
5
ONLINE
46
167
10.1
0
ONLINE
43
150
17.4
3
GROUP
44
151
15.2
2
GROUP
42
141
12.2
3
NONE
39
131
19.4
2
NONE
49
174
18.3
0
ONLINE
41
154
14.5
4
NONE
42
131
20.2
3
GROUP
39
128
15.3
1
GROUP
37
126
13.4
4
NONE
46
180
15.1
4
NONE
45
166
19.5
5
NONE
44
152
16.0
2
ONLINE
50
179
12.8
3
ONLINE
39
140
18.2
1
NONE
43
154
15.3
1
ONLINE
45
164
17.2
3
ONLINE
42
139
18.6
2
NONE
44
165
19.2
2
NONE
45
172
12.6
3
GROUP
41
147
18.5
3
GROUP
43
152
17.2
1
GROUP
48
160
15.8
2
ONLINE
42
159
13.6
4
GROUP
46
186
14.1
3
GROUP
46
150
20.7
2
GROUP
43
155
11.2
3
ONLINE
45
157
16.3
4
ONLINE
48
170
12.1
1
ONLINE
45
175
18.3
2
GROUP
49
186
17.5
1
GROUP
51
181
11.4
4
GROUP
47
171
17.3
2
ONLINE
50
185
16.4
0
ONLINE
39
146
15.8
1
GROUP
42
156
18.6
2
GROUP
46
157
19.3
2
ONLINE
43
163
11.7
1
GROUP
54
175
14.2
1
ONLINE
51
175
12.0
2
ONLINE
50
173
13.3
1
ONLINE
41
140
14.9
3
NONE
43
156
20.5
2
ONLINE
40
146
18.2
2
NONE
42
148
10.5
2
GROUP
50
183
11.7
1
GROUP
49
191
13.1
2
GROUP
40
149
14.2
4
ONLINE
40
143
18.3
2
NONE
47
185
15.2
2
ONLINE
41
136
17.4
3
GROUP
51
198
13.0
1
ONLINE
43
153
13.2
3
GROUP
38
129
15.2
3
NONE
44
158
11.8
3
ONLINE
43
149
12.7
1
GROUP
47
175
13.9
2
GROUP
40
154
16.4
3
GROUP
43
151
14.3
1
GROUP
46
153
22.0
0
ONLINE
46
167
14.8
1
ONLINE
46
167
15.8
0
ONLINE
39
143
17.7
3
NONE
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Information Technology Control And Audit
Authors: Angel R. Otero
5th Edition
1498752284, 9781498752282
