The attached Excel spreadsheet contains data on a sample of 1080 salespeople from a large electronics retail company. The dataset contains the following variables:
Sales: Total sales (in $) by each salesperson last year
Department: What department (home electronics, computers, etc) the salesperson works in.
Year born: The year in which the salesperson was born
Training Hours: Number of hours of training the individual has received during career.
Gender: Salesperson's Gender
Experience: Number of years the individual has worked with your company.
Education: Level of education completed by salesperson
Marital Status: Salesperson's Marital Status
Problem 1.1: Use the data to determine the following:
(a) Which of the variables are categorical and which are numerical?
(b) Which of the categorical variables are nominal and which are ordinal?
(c) Which of the numerical variables are ratio and which are interval?
Problem 1.2: Use the salesperson data to do the following:
(a) Create a summary table and an ordered summary table of the departments the salespeople work in.
(b) Construct a bar chart, a pie chart, and a Pareto diagram.
(c) Which graphical method do you think is best to portray these data?
(d) Based on this data, what conclusions can you make about the departments your salespeople work in?
Problem 1.3: Use the data to do the following:
(a) Construct a frequency distribution and a percentage distribution of the years of experience of your sales force.
(b) Construct a histogram and a percentage polygon.
(c) Plot a cumulative percentage polygon.
Problem 1.4: Use the salesperson data to do the following:
(a) Compute the mean, median, first quartile, and third quartile for the sales variable.
(b) Compute the variance, standard deviation, range, interquartile range, coefficient of variation, skewness, and Z scores for the sales variable.
(c) Are the data skewed? If so, how?
(d) Based on the results of (a) through (c), what conclusions can you reach concerning sales?
(e) Calculate the proportion of sales that are +/- 1, +/- 2, and +/- 3 standard deviations of the mean.
(f) Compare and contrast your findings with what would be expected on the basis of the empirical rule.
Problem 1.5: Use the sales data to do the following:
(a) Compute the covariance between sales and hours of training.
(b) Compute the coefficient of correlation between sales and hours of training.
(c) Construct a scatterplot between sales and hours of training with sales on the Y-Axis.
(d) Which of (a)-(c) do you think is the most valuable means to understand the relationship between sales and hours of training?
(e) What conclusions can you reach about the relationship between sales and hours of training? What sorts of business implications does this have?
Attachment:- table.xlsx