MATH 533 Week 2 Course Project Part A: Exploratory Data Analysis (GRADED A)

Course Project Part A: Exploratory Data Analysis DeVry University Applied Managerial Statistics MATH533 MATH 533: Applied Managerial Statistics Course Project –Part A I. Introduction. Salescall Inc. is a compa ...

Course Project Part A: Exploratory Data Analysis DeVry University Applied Managerial Statistics MATH533 MATH 533: Applied Managerial Statistics Course Project –Part A I. Introduction. Salescall Inc. is a company with many 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) and 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 identify if changes are needed. This analysis will help the Company increase sales. II. Individual Variables. 1. Sales Descriptive Statistics: SALES Variable N Mean SE Mean StDev Variance Minimum Q1 Median Sales (Y) 100 42.550 0.717 7.171 51.422 21.000 39.000 43.000 Q3 47.000 Maximum 67.000 Range 46.000 The variable ‘SALES’ defines the number of sales made by a sales person this week. The mean number of sales made by a sales person this week is 42.550 with a standard deviation of 7.171. The following histogram shows the frequency distribution of the number of sales made by the sales persons this week: Data for sales made in a week for Salescall Inc. shows that an average of 42 sales are made. The company can expect to have as few as 21 and up to 67 sales in a week. From the data gathered the company can expect to see the average sales made. Looking at the Steam and leaf graphic above shows it is normally distributed. 2. Calls Descriptive Statistics: CALLS Variable N Mean SE Mean StDev Variance Minimum Q1 Median Calls (X1) 100 161.88 1.84 18.43 339.82 120.00 149.00 160.50 Q3 Maximum Range 176.75 201.00 81.00 The table and Histogram Chart shows 33 % of the number of calls made by each sales person were from 130 to 182 calls in a week. The mean of the remaining calls is 169. The minimum number of calls made was 120 and the maximum was 201. 3. Time Descriptive Statistics: TIME Variable N Mean SE Mean StDev Variance Minimum Q1 Median Time (X2) 100 15.338 0.230 2.300 5.289 10.000 13.600 15.050 Q3 17.225 Maximum 20.000 Range 10.000 The box plot and table represent the average time of a call. The median, 15.050, and mean, 15.338, are very close which shows that the average of a sales call can be expected to last 15 minutes. The whiskers of the Boxplot show that the shortest call was 10 minutes, while the longest call was 20 minutes. (assuming time is measure in minutes) III. Pairing of Variables 1. Calls & Type Descriptive Statistics: Calls (X1) Variable Type N N* Mean SE Mean StDev Variance Minimum Q1 Variable Type Median Q3 Maximum Range Mode Mode Calls (X1) GROUP 154.50 166.50 192.00 61.00 149, 150, 152, 154 2 NONE 141.00 145.00 160.00 40.00 130, 140, 144, 145 2 ONLINE 174.00 184.25 201.00 52.00 178 4 Number of Calls and Type are compared above. The data shows that the number of calls has a correlation with the Type. The higher number of calls is for the salesperson who have online training. The highest mean is also for the online training type 173.70 which confirms that the training is important to achieve sales. The mean calls fall between 156.57 to 173.70. 2. Sales and Type Descriptive Statistics: SALES Variable Type Mean StDev Variance Minimum Q1 Median Sales (Y) GROUP 42.77 7.16 51.29 31.00 38.75 43.00 NONE 39.30 8.44 71.27 29.00 35.25 37.00 ONLINE 43.720 6.338 40.165 21.000 41.000 44.000 Variable Type Median Q3 Maximum Range Mode N for Mode Sales (Y) GROUP 43.00 47.00 67.00 36.00 42, 44 4 NONE 37.00 39.75 67.00 38.00 37 4 ONLINE 44.000 48.000 56.000 35.000 48 8 Sales and the type of training are compared in the above table and boxplot. The most effective sales persons are the person that has received group or online training. The maximum of sales made, 67, by both group and none type are outliers. We must look at the median sales which shows sales are higher for online trained sales persons. 3. Sales and Years Descriptive Statistics: Sales (Y) Years Variable (X3) Mean StDev Variance Minimum Q1 Median Sales (Y) 0 40.11 8.40 70.61 21.00 37.00 41.00 1 44.55 9.05 81.88 32.00 38.75 43.00 2 41.69 6.28 39.44 21.00 40.50 42.00 3 42.10 6.90 47.57 32.00 34.75 43.50 4 40.90 6.84 46.77 31.00 34.25 41.50 5 45.40 3.37 11.38 40.00 43.00 45.00 Years Variable (X3) Median Q3 Maximum Range N for Mode Mode Sales (Y) 0 41.00 46.00 50.00 29.00 37, 41 2 1 43.00 48.25 67.00 35.00 42 3 2 42.00 45.50 50.00 29.00 41 5 3 43.50 47.75 56.00 24.00 33 3 4 41.50 46.50 52.00 21.00 * 0 5 45.00 48.00 52.00 12.00 43, 44, 46, 48 2 Sales and years are paired above and show that sales persons with 5 years of experience tend to sale consistently over the minimum of 40 sales. This should indicate that experienced sales persons produce more sales with less variation. IV. Conclusion The analysis of the data above indicates that training should be mandatory for all sales persons at the Company. The training yields more sales and increases the number of call made. The data also proves that the Company should focus on keeping experienced sales persons to maximize sales.