COURSE PROJECT PART A(Melissa McCrary MATH533 )

SALESCALL Inc. is a company with thousands of salespeople. The data provided:  SALES (the number of sales made this week)  CALLS (the number of sales calls made this week)  TIME (the average time per call this week)  YEARS (years of experience in the call center)  TYPE (the type of training, either group training, online training of no training). The data is used to determine the most productive sales person. With this information the company can tailor it’s training to achieve the greatest number of sales. SALES Total Count Mean St. Dev Variance Min Q1 Median Q3 Max 100 42.34 4.17 17.39 32 39. 52 20 15 10 5 0 SALES Fre q u e ncy Histogramof SALES 52 20 15 10 5 0 SALES Fre q u e ncy Histogramof SALES This study resource was shared via CourseH Data shows that for sales made in a week for SALESCALLS. Shows that an average of 42 sales were made. The company can expect to have as limited as 32 and up to 52 sales in a week. From the data assembled the company can expect to see an average sales made. CALLS Total Count Mean St. Dev Variance Min Q1 Median Q3 Max 100 162.09 18.01 324..50 176.75 201 The table and Pie Chart shows that 33 % of the sales man made 134 to 178 calls in a week. The mean of the remaining calls is 169. The minimum number of calls made was 124 and the maximum was 201. TIME Other 134 149 152 153 154 157 168 170 178 Category Other 67, 67.0% 178 5, 5.0% 170 4, 4.0% 168 3, 3.0% 157 3, 3.0% 154 3, 3.0% 153 3, 3.0% 152 3, 3.0% 149 6, 6.0% 134 3, 3.0% Calls Other 134 149 152 153 154 157 168 170 178 Category Other 67, 67.0% 178 5, 5.0% 170 4, 4.0% 168 3, 3.0% 157 3, 3.0% 154 3, 3.0% 153 3, 3.0% 152 3, 3.0% 149 6, 6.0% 134 3, 3.0% Calls This study resource was shared via CourseH 22 20 18 16 14 12 10 TIME Boxplot of TIME Total Count Mean St. Dev Variance Min Q1 Median Q3 Max 100 15.34 2.42 5.83 10 13.50 15.05 17 21.60 The box plot and table represent the average time of a call. The median, 15.05, and mean, 15.34, are very close that shows the average sales call is expected to last 15 minutes. The whiskers of the Boxplot show that the shortest call was 10 minutes, while the longest call was 21.6 minutes. I. Pairing of Variables SALES, CALLS Variable Mean St. Dev Variance Min Q1 Median Q3 Max Sales 42.34 4.17 17.39 32 39. Calls 162.09 18.01 324..50 176.75 201 This study resource was shared via CourseH SALES CALLS 46 47 48 49 134 149 152 153 154 157 37 168 170 178 Other 38 39 40 41 42 43 44 45 Category Other 9, 9.0% 49 4, 4.0% 48 5, 5.0% 47 4, 4.0% 46 5, 5.0% 45 5, 5.0% 44 12, 12.0% 43 9, 9.0% 42 9, 9.0% 41 10, 10.0% 40 8, 8.0% 39 6, 6.0% 38 5, 5.0% 37 9, 9.0% Other 67, 67.0% 178 5, 5.0% 170 4, 4.0% 168 3, 3.0% 157 3, 3.0% 154 3, 3.0% 153 3, 3.0% 152 3, 3.0% 149 6, 6.0% 134 3, 3.0% Sales and Calls SALES CALLS 46 47 48 49 134 149 152 153 154 157 37 168 170 178 Other 38 39 40 41 42 43 44 45 Category Other 9, 9.0% 49 4, 4.0% 48 5, 5.0% 47 4, 4.0% 46 5, 5.0% 45 5, 5.0% 44 12, 12.0% 43 9, 9.0% 42 9, 9.0% 41 10, 10.0% 40 8, 8.0% 39 6, 6.0% 38 5, 5.0% 37 9, 9.0% Other 67, 67.0% 178 5, 5.0% 170 4, 4.0% 168 3, 3.0% 157 3, 3.0% 154 3, 3.0% 153 3, 3.0% 152 3, 3.0% 149 6, 6.0% 134 3, 3.0% Sales and Calls This study resource was shared via CourseH Sale and number of calls are compared above. The data shows that the number of calls has a correlation with the number of calls made. The more calls made will generate more sales. To achieve the mean of 42 sales it can be expected that 162 calls must be made. 1. Sales and Type Descriptive Statistics: SALES Variable Type Total Count Mean St. Dev Variance Min Q1 Median Q3 Max Sales Group 30 40.84 2.08 4. 44 None 20 37.10 2.25 5. 40 Online 50 45.34 2.97 8. 52 Sales and the type of training are compared in the above table and boxplot. The most effective sales person has received online training. The maximum number of sales was made by the employee who was trained online followed by the group training and no training respectfully. GROUP NONE ONLINE 55 50 45 40 35 30 TYPE SALES Boxplot of SALES GROUP NONE ONLINE 55 50 45 40 35 30 TYPE SALES Boxplot of SALES This study resource was shared via CourseH The online trained had the largest variance of 8.8 of the three groups. The majority of online trained made sales from 42 to 48. 2. Sales and Time SALES, TIME Variable Mean St. Dev Variance Min Q1 Median Q3 Max Sales 42.34 4.17 17.39 32 39. Time 15.34 2.42 5.83 10 13.50 15.05 17 21.60 Sales and time are paired above and show that sales start to decline the longer a sales person is on a call. The mean of time is 15.341 units of time. The maximum amount of time was 21.6 minutes. The most productive time spent on calls is between 13 and 17 minutes. II. Conclusion 20 22 55 50 45 40 35 30 TIME SA L E S Sales and Time 20 22 55 50 45 40 35 30 TIME SA L E S Sales and Time This study resource was shared via CourseH In conclusion the most benefit to the company comes from online training and time of call. With this data the company can show that the longer a person stays on a call the probability of a sale declines. The data also shows that the most beneficial training is done online. This study resource was shared via CourseH