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.