Question
The Excel file has 5 variables:Sales, Calls, Time, Years and Type.Only Type (for type of training) is not a quantitative variable. For each of them,
The Excel file has 5 variables:Sales, Calls, Time, Years and Type.Only Type (for type of training) is not a quantitative variable. For each of them, use Excel to run graphs and charts (such as pie charts, bar graphs, frequency tables, etc.), and, of course our "good ol'" measures of central tendency (like the average, min., max, standard deviation)...and use your own words to describe the analyses.
NEXT, Give us your perspective (again, your own words suffice) for three of those 5 variables.Again, use Excel to show the five-number(Min, Max, Q1, Q3 and median) summary calculations.Explain what are the measures of dispersion and show the shapes of the distributions look.
Introduction
Your instructor will provide you with a data file that includes data on five variables:
SALESrepresents the number of 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.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored 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